One note I forgot to mention about the OCI driver: You must set your ORACLE_HOME and LD_LIBRARY_PATH vars!!! In my server.sh I have these lines:
ORACLE_HOME=/home/oracle/product/817 export ORACLE_HOME LD_LIBRARY_PATH=$ORACLE_HOME/lib export LD_LIBRARY_PATH If you do all that and you can do a tnsping, everything *should* work. -James > -----Original Message----- > From: Shapira, Yoav [mailto:[EMAIL PROTECTED]] > Sent: Thursday, July 11, 2002 9:52 AM > To: Tomcat Users List > Subject: RE: JDBC OCI driver + Tomcat 4.04 > > Hi, > James: thank you for that URL. I recommend everyone read it ;) > <goes off in search of his db programmers> > > > Yoav Shapira > Millennium ChemInformatics > > > >-----Original Message----- > >From: James Ward [mailto:[EMAIL PROTECTED]] > >Sent: Thursday, July 11, 2002 11:31 AM > >To: Tomcat Users List > >Subject: RE: JDBC OCI driver + Tomcat 4.04 > > > >O'Reilly has a good article about the performance differences between > >the oci and the thin client driver: > >http://www.oreilly.com/catalog/jorajdbc/chapter/ch19.html > > > >In order to use the OCI driver you will have to install the oracle > >client. Then make sure your tnsnames.ora file is correct. Check it > >with a tnsping. > > > >Personally I am sticking with the thin client driver. > > > >-James > > > > > >> -----Original Message----- > >> From: Durham David Cntr 805CSS/SCBE > >[mailto:[EMAIL PROTECTED]] > >> Sent: Thursday, July 11, 2002 9:10 AM > >> To: Tomcat Users List > >> Subject: RE: JDBC OCI driver + Tomcat 4.04 > >> > >> Do you have to install the oracle tnsclient software or something > like > >> that to use OCI? > >> > >> > >> -----Original Message----- > >> From: Larry Meadors [mailto:[EMAIL PROTECTED]] > >> Sent: Thursday, July 11, 2002 9:31 AM > >> To: [EMAIL PROTECTED] > >> Subject: Re: JDBC OCI driver + Tomcat 4.04 > >> > >> > >> The OCI driver is *at least* 10X faster than the thin driver. It is > >> worth getting it going. ;-) > >> > >> I do not have my ora docs handy, what is a ORA-12560 error? Any hints > >> there? > >> > >> Send some simple sample code, that will help too. > >> > >> Larry > >> > >> >>> [EMAIL PROTECTED] 07/11/02 07:46 AM >>> > >> I know this doesn't solve your problem, but is there a compelling > >reason > >> to use OCI driver as compared to the type 4 driver? > >> > >> > >> -- > >> To unsubscribe, e-mail: <mailto:tomcat-user- > >> [EMAIL PROTECTED]> > >> For additional commands, e-mail: <mailto:tomcat-user- > >> [EMAIL PROTECTED]> > >> > >> > >> -- > >> To unsubscribe, e-mail: <mailto:tomcat-user- > >> [EMAIL PROTECTED]> > >> For additional commands, e-mail: <mailto:tomcat-user- > >> [EMAIL PROTECTED]> > > > > > >-- > >To unsubscribe, e-mail: <mailto:tomcat-user- > >[EMAIL PROTECTED]> > >For additional commands, e-mail: <mailto:tomcat-user- > >[EMAIL PROTECTED]> > > > -- > To unsubscribe, e-mail: <mailto:tomcat-user- > [EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:tomcat-user- > [EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>