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