tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jeffrey Janner <>
Subject RE: ODBC jar files
Date Tue, 25 Oct 2011 13:51:55 GMT
Barry -

I run an Oracle mixed environment and I can assure you that you will run into problems running
ojdbc14.jar and connecting to your 11g database.  In particular, you will see some "odd" errors
related to bind peek on the server side - but that is supposedly fixed in  I can't
say for sure as I haven't been able to schedule an upgrade, yet.  If you want to talk to 11g,
you really should use the ojdbc jar file.  You can get that directly from the Oracle

It should be mostly backwards compatible for connecting to 10g, but there are a few "improvements"
that might come back to bite you.  In particular, they have added additional mappings to handle
the Native Language string columns (NCHAR, NVARCHAR, etc.).  Before switching to that jar
in your legacy app, you need to insure that it won't be a problem, or you may need to make
some quick changes to the code.

Also, according to Oracle, make sure you grab the ojdbc file that matches the Java version
you are running.  If your Tomcat runs under Java 5, you need the ojdbc5.jar.  The ojdbc6.jar
is only for using with Java 6.  They are the same code, but compiled for those java versions,
and I assume optimized for them. 

If you don't know what version of the ojdbc file you have, you can always look it up.  Using
your favorite unzip tool, extract the MANIFEST.MF file from the META-INF directory of the
ojdbcx.jar file.  It's a simple text file and contains the release number of the jar file.

And while you're on the Oracle JDBC website, download the documentation that goes along with
it.  Read it thoroughly and see what other changes they've made that might be useful and/or
detrimental to your implementation.


> -----Original Message-----
> From: Propes, Barry L []
> Sent: Monday, October 24, 2011 3:36 PM
> To: Tomcat Users List
> Subject: RE: ODBC jar files
> Ok, thanks for that explanation. I'll test putting one in the WEB-
> INF/lib and see if I can connect to it that way. If so, I'll see where
> I need to go from there.
> -----Original Message-----
> From: Caldarale, Charles R []
> Sent: Thursday, October 20, 2011 4:14 PM
> To: Tomcat Users List
> Subject: RE: ODBC jar files
> > From: Propes, Barry L []
> > Subject: RE: ODBC jar files
> > I had web app A with a context file in its META-INF directory and web
> > app B with a (different) context file in its META-INF directory.
> That's not related to the classloader being used here.  There's a
> separate one for Tomcat's lib directory, and that's the only one that
> sees the jars in that location.  You can put a JDBC jar in WEB-INF/lib,
> but then the webapp has to do its own DB connection pooling.
> - Chuck
> PROPRIETARY MATERIAL and is thus for use only by the intended
> recipient. If you received this in error, please contact the sender and
> delete the e-mail and its attachments from all computers.
> ---------------------------------------------------------------------
> To unsubscribe, e-mail:
> For additional commands, e-mail:
> ---------------------------------------------------------------------
> To unsubscribe, e-mail:
> For additional commands, e-mail:


Confidentiality Notice:  This Transmission (including any attachments) may contain information
that is privileged, confidential, and exempt from disclosure under applicable law.  If the
reader of this message is not the intended recipient you are hereby notified that any dissemination,
distribution, or copying of this communication is strictly prohibited.  

If you have received this transmission in error, please immediately reply to the sender or
telephone (512) 343-9100 and delete this transmission from your system.

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message