[#JM-1317] DB2 connection test fails - Jive Software Open Source

Openfire

DB2 connection test fails

Created: 04/08/08 09:50 AM Updated: 04/24/08 05:57 PM

Component/s:

Database

Affects Version/s:

3.5.0

Fix Version/s:

3.5.1

Time Tracking:

Not Specified

Support Plan Customer Issue:	No
Resolution Date:	04/24/08 05:57 PM
Acceptance Test - Add?:	No

Description

« Hide

The connection test for DB2 "select 1" does not work. Similar to Oracle. Need to find a solution.

All

Comments

Work Log

Change History

Subversion Commits

Sort Order:

Ascending order - Click to sort in descending order

[ Permlink | « Hide ]

Daniel Henninger - 04/08/08 09:51 AM

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.

[ Permlink | « Hide ]

Francisco Vives - 04/23/08 05:37 PM

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)

[ Permlink | « Hide ]

Daniel Henninger - 04/24/08 05:57 PM

Good catch! Thanks Francisco!