tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Propes, Barry L " <barry.l.pro...@citi.com>
Subject RE: ODBC jar files
Date Tue, 25 Oct 2011 14:04:30 GMT
Thanks a bunch, Jeff!

This helps. I just downloaded ojdbc6.jar, but have been running  ojdbc14.jar, and it's still
in the lib folder.

I did not take it out, but simply added the new ojdbc6.jar, to the lib, which from the sounds
of things sounds like a bad idea (to add and have both in there).

I am running Tomcat 6.0.29. I'll try removing the other older ojdbc jar file and replace it
with the newer one -  ojdbc6.jar.

I will go get the other documentation, too, Jeff!

Thanks for the tips!

Barry



-----Original Message-----
From: Jeffrey Janner [mailto:Jeffrey.Janner@PolyDyne.com]
Sent: Tuesday, October 25, 2011 8:52 AM
To: 'Tomcat Users List'
Subject: RE: ODBC jar files

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 11.2.0.2.  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 11.2.0.2 ojdbc jar file.  You can get that directly from the Oracle
website.

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.

Jeff

> -----Original Message-----
> From: Propes, Barry L [mailto:barry.l.propes@citi.com]
> 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 [mailto:Chuck.Caldarale@unisys.com]
> Sent: Thursday, October 20, 2011 4:14 PM
> To: Tomcat Users List
> Subject: RE: ODBC jar files
>
> > From: Propes, Barry L [mailto:barry.l.propes@citi.com]
> > 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
>
>
> THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE
> 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: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>

__________________________________________________________________________

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: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message