Mark,
Thanks for your reply! Please see below for the details. BTW, I removed the
database connection info. for security reasons. The same data source
configuration and jdbc driver "ojdbc6_g" works in the Weblogic 14 server.
web.xml:
<resource-ref>
<description>project datasource</description>
<res-ref-name>jdbc/ariesDS</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
Tomcat 9.0.75 conf/context.xml:
<Resource auth="Container" driverClassName="oracle.jdbc.OracleDriver"
maxIdle="10" maxTotal="20" maxWaitMillis="-1" name="jdbc/ariesDS"
password="PW" type="javax.sql.DataSource"
url="jdbc:oracle:thin@hostname:portNumber/servic
name" username="userName"/>
Datasource lookup code:
Context initContext = new InitialContext();
Context envContext = (Context)initContext.lookup("java:/comp/env");
DataSource ods = (DataSource)envContext.lookup("jdbc/ariesDS");
if (ods==null)
{
System.out.println("ods = (OracleDataSource)
envCtx.lookup('jdbc/ariesDS') is null");
throw new Exception ("the data souce is null, error throwed.");
}else{
conn = ods.getConnection();
}
The database version is Oracle 19C and I found out the Oracle jdbc driver
should be ojdbc8.jar. If using this version of jar file, any code changes
need to be done for the data source lookup code?
The complete stacktrace:
[image: image.png]
Your help is greatly appreciated!
Thanks,
Jenny
On Mon, Jun 12, 2023 at 3:26 AM Mark Thomas <ma...@apache.org> wrote:
> 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
>
>
