I think the big problem is that Oracle didn't put much thought on the naming convention for its jdbc drivers, so basically all versions are classes12.zip. There are a very big library of releases and there is not (or at least I haven't found a central repository). You have to unzip/unjar the file and see what it contains. If you see things like ocijdbc9_g.dll, it will work with 9i.
I personally keep a directory structure where I put all releases of classes12.zip that I find, and with which versions, jdk, OS and connection type (thin/OCI) they work. Ex: NT/8.1.7/Thin/classes12.zip 1887KB NT/8.1.7.1/Thin/classes12.zip 1888KB NT/9.0.1/Thin/classes12.zip 1081KB There are sometimes patches with one or two classes, that you have to move to your all zip to make it work. Many times a jdbc may work with thin client but not with fat, or work in NT but not in Solaris. Personally I think Oracle has done a mess with this, the only solution is try until you find a good one. By the way, having the latest doesn't warranty it will work with your current setup. The are not backward compatible. angel -----Original Message----- From: Laura [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 1:06 PM To: Tomcat Users List Subject: Re: AW: PLEASE HELP ME: JNDI ERROR 1 I use classes12.jar (classes12.zip): well, the database my examples was ok with, was 8i. My new database I don't know what version is: if it was 9i which driver I should use? Laura Alle 19:00, lunedì 15 aprile 2002, hai scritto: > If the Oracle database that you are trying to connect to is a different > version than the old one, check for updated Oracle jdbc drivers > (classes12.zip). I have found that there are many releases of this file, > and newer releases are not always backwards compatible. For instance, > classes12.zip that work well with 8i do not work well with 9i. > > angel > > -----Original Message----- > From: peter lin [mailto:[EMAIL PROTECTED]] > Sent: Monday, April 15, 2002 12:48 PM > To: Tomcat Users List > Subject: Re: AW: PLEASE HELP ME: JNDI ERROR 1 > > > > look in the tnslistener network log to see if tomcat is getting to the > machine correctly. If not, it's most likely a typo someplace. If it is, > the log will give you more data to debug the problem. > > peter lin > > Laura wrote: > > But I have controlled all. > > > > If I try to connect with sql plus, I connect to the db. > > > > Any suggestions? > > > > Laura > > > > Alle 18:30, lunedì 15 aprile 2002, hai scritto: > > > You said that you changed user, password, and url. > > > > > > I would suspect, that you mistyped either the name > > > of the server or the port or that your new database > > > is using different parameters than your old one. > > > > > > > -----Ursprüngliche Nachricht----- > > > > Von: Laura [mailto:[EMAIL PROTECTED]] > > > > Gesendet: Montag, 15. April 2002 18:26 > > > > An: Tomcat Users List > > > > Betreff: PLEASE HELP ME: JNDI ERROR 1 > > > > -- > > To unsubscribe: <mailto:[EMAIL PROTECTED]> > > For additional commands: <mailto:[EMAIL PROTECTED]> > > Troubles with the list: <mailto:[EMAIL PROTECTED]> -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]> -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>