Skip to Content
0
Jun 09, 2008 at 02:00 PM

JDBC Drivers ...

173 Views

Hello all,

I've created new JDBC Driver (ORACLE_JDBC) in Visual Admin that contains following jar archives:

classes12.jar

classes12dms.jar

nls_charset12.jar

ojdbc14.jar

ojdbc14_g.jar

ojdbc14dms.jar

ojdbc14dms_g.jar

A few of these archives contains oracle.jdbc.driver.OracleDriver.class but the class is different in particular jar files.

Then I've created new connector and insert "library:ORACLE_JDBC" into Loader Referencies.

How is the portal able to find out which OracleDriver.class should be used?

When I try to test the connector by use http://<host>:<port>/TestJDBC_Web/TestJDBCPage.jsp URL then:

a) It works on test EP.

b) It doesn't work on productive EP. The following error message occures in trace file:

Error##Plain###application [TestJDBC_Web] Processing HTTP request to servlet [Control 2] finished with error. The error is: java.lang.NoClassDefFoundError: oracle/dms/instrument/ExecutionContextForJDBC

at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:341)

at oracle.jdbc.driver.T4CConnection.<init>(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(DriverManager.java:512)

at java.sql.DriverManager.getConnection(DriverManager.java:140)

.......

I found out that some of the OracleDriver classes use the class oracle/dms/instrument/ExecutionContextForJDBC and some of them not. So how can I specify which OracleDriver.class should be used.

Even when I tried to remove the ORACLE_JDBC driver from Loader Referencies of the connector and restarted sap.com/com.sap.ip.bi.sdk.dac.connector.jdbc service, it still return the same error. So how does the portal know where should search the OracleDriver.class?

Best Regards,

Zbynek