We're updating the issue view to help you get more done. 

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

Acceptance Test - Entry

None

Activity

Show:
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.

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

Good catch! Thanks Francisco!

Assignee

Daniel Henninger

Reporter

Daniel Henninger

Labels

None

Expected Effort

None

Ignite Forum URL

None

Components

Fix versions

Affects versions

Priority

Major
Configure