On 11/06/2023 19:33, Ying Jin wrote:
Hello,
We have an old java servlet web application which uses the "ojdbc6_g" jar
as Oracle jdbc driver and it works in Weblogic 14 server. Recently, we need
to try to see if this application can be deployed to Tomcat or not.
The JDBC data source has been configured in Tomcat 9.0.75 server according
to instructions below,
https://tomcat.apache.org/tomcat-9.0-doc/jndi-resources-howto.html
Please see below for the error we encountered in the Tomcat 9 deployment
and help shed some light on this problem. The Oracle database version is
19c.
Error: Cannot create JDBC driver of class 'oracle.jdbc.OracleDriver' for
connect URL 'jdbc:oracle:thin@xxx
java.sql.SQLException: Cannot create JDBC driver of class
'oracle.jdbc.OracleDriver' for connect URL 'jdbc:oracle:thin@
<http://jdbc:oracle%3at...@vdb04ld.hs.it.vumc.io:10920/ARDEV.vumc.vanderbilt>
xxxx'
at
org.apache.tomcat.dbcp.dbcp2.DriverFactory.createDriver(DriverFactory.java:74)
at
org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createConnectionFactory(BasicDataSource.java:465)
at
org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:529)
at
org.apache.tomcat.dbcp.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:710)
And the rest of the stack trace is?
ojdbc6_g.jar has been placed where in the file system?
That is a *very* old Oracle JDBC driver. It is also the debug version of
the JAR. You might want to think about using the latest one for Oracle 19c.
The changes to the configuration are? (Yes, I know you said you followed
the docs but we still need to know what you actually changed. Not
everyone follows the docs correctly.)
Mark
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
