OPENFIRE 3.5.2 on windows can't connect to Oracle 10g

Openfire Openfire Support
1

I currently have openfire 3.5.2 running on a windows ,I’ve got it working on windows with mysql very well.However, I tried to get openfire to connect to the Oracle 10g database, I got errors as follows(but I can successly connect to Oracle 10g database with the same URL and JDBC IN elipse 3.3.2):

I’'m using oracle 10g database

JDBC: oracle.jdbc.driver.OracleDriver

URL: jdbc:oracle:thin:@172.16.129.84:1521:DCDP

2008.08.03 16:38:15 [org.jivesoftware.util.log.util.CommonsLogFactory$1.error(CommonsLogFactory.jav a:92)
] Prototype
org.logicalcobwebs.proxool.ProxoolException: Unexpected prototyping problem
at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:229)
at org.logicalcobwebs.proxool.Prototyper.sweep(Prototyper.java:102)
at org.logicalcobwebs.proxool.PrototyperThread.run(PrototyperThread.java:44)
Caused by: java.lang.NoClassDefFoundError: oracle/dms/instrument/ExecutionContextForJDBC
at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:341)
at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:854)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.logicalcobwebs.proxool.DefaultConnectionBuilder.buildConnection(DefaultConn ectionBuilder.java:39)
at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:159)
… 2 more

Caused by:
java.lang.NoClassDefFoundError: oracle/dms/instrument/ExecutionContextForJDBC
at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:341)
at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:854)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.logicalcobwebs.proxool.DefaultConnectionBuilder.buildConnection(DefaultConn ectionBuilder.java:39)
at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:159)
at org.logicalcobwebs.proxool.Prototyper.sweep(Prototyper.java:102)
at org.logicalcobwebs.proxool.PrototyperThread.run(PrototyperThread.java:44)

2

Thank you, I have resolved the problem. It’s because the version of JDK is 1.6, but JDBC 10.0.2.1 is only work with JDK 1.4 and JDK 1.5. When I use JDBC 11.0.1.6 with JDK 1.6 , I can connect to Oracle 10g successfully.