The connection test for DB2 "select 1" does not work. Similar to Oracle. Need to find a solution.
Environment
None
Activity
Show:
Daniel Henninger April 25, 2008 at 5:57 AM
Good catch! Thanks Francisco!
Francisco Vives April 24, 2008 at 5:37 AM
Environment: DB2 version: 9.5 In the installation process, in the step "Database Settings - Standard Connection" the DB2 database configuration produce the following error: 2008.04.23 19:24:28 [org.jivesoftware.database.DefaultConnectionProvider.getConnection(DefaultConnectionProvider.java:79) ] DbConnectionProvider: Error while getting connection: java.sql.SQLException: Created a new connection but it failed its test at org.logicalcobwebs.proxool.ConnectionPool.getConnection(ConnectionPool.java:217) at org.logicalcobwebs.proxool.ProxoolDriver.connect(ProxoolDriver.java:89) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at org.jivesoftware.database.DefaultConnectionProvider.getConnection(DefaultConnectionProvider.java:76) at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager.java:101) at org.jivesoftware.openfire.admin.setup.setup_002ddatasource_002dstandard_jsp.testConnection(setup_002ddatasource_002dstandard_jsp.java:35) at org.jivesoftware.openfire.admin.setup.setup_002ddatasource_002dstandard_jsp._jspService(setup_002ddatasource_002dstandard_jsp.java:203)
Daniel Henninger April 8, 2008 at 9:51 PM
While I'm at it, since I have access to all databases now, I should make sure the test statement works properly in all dbs.
The connection test for DB2 "select 1" does not work. Similar to Oracle. Need to find a solution.