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.jan...@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.pro...@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.caldar...@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.pro...@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-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@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-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org