DB2 connection test fails

Description

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, 5:57 AM

Good catch! Thanks Francisco!

Francisco Vives
April 24, 2008, 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, 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.

Fixed
Your pinned fields
Click on the next to a field label to start pinning.

Assignee

Daniel Henninger

Reporter

Daniel Henninger