In case it is of use to anybody else, this is what worked in the end. HP-UX 10.20, Oracle 8.0.4, Tomcat 3.3.1 (JDK 1.1.8)
1. Install the JDBC package off the Oracle CD onto the HP server 2. This installs the correct classes111.zip and shared library for that version of Oracle 3. Make sure that the shared library (liboci804jdbc.sl) has full execute permissions 4. In the account controlling Tomcat set SHLIB_PATH=$ORACLE_HOME/lib 5. Also copy $ORACLE_HOME/jdbc/lib/classes111.zip to $TOMCAT_HOME/ lib/common/classes111.jar 6. I still couldn't get the OCI driver to work, but the THIN driver does. Thanks to everyone that helped. John -----Original Message----- From: PELOQUIN,JEFFREY (HP-Boise,ex1) [mailto:[EMAIL PROTECTED]] Sent: 08 January 2003 15:09 To: 'Tomcat Users List' Subject: RE: HP-UX 10.20 + Oracle John, I sent two version of the classes111.jar we have used on our HP-UX 11.0 system to your account in order not to clutter up people boxes with the zip file. I do not know why they are different but I have discovered with the classes12.jar that they come in vastly different vintages. I upgraded a linux system once and got the latest and greatest classes12 from oracle since it was easier than copy it from the old server I had. Some of the functionality of the site ceased to work until I rolled back to the prior version that was three years older. Jeff -----Original Message----- From: John Clark [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 08, 2003 6:03 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: HP-UX 10.20 + Oracle Hi I am offsite today, so not sure if this will work, anyway. I have tried setting LD_LIBRARY_PATH but it still does not work. I suspect that I have conflicting versions or classes, so my questions are: 1. Where should I get classes12 or classes111 from for HPUX 10.2 and Oracle 8.0.4 (the ones I am using are copied from Linux) 2. I have seen mentioned that an associated DLL is required, which one? and where should it go? Thanks once again John Make sure you have the LD_LIBRARY_PATH environment variable set to $ORACLE_HOME/lib (I think :-\ ) At least you have to on Linux. -----Original Message----- From: John Clark [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 07, 2003 1:13 PM To: 'Tomcat Users List' Subject: RE: HP-UX 10.20 + Oracle Mark: I tried changing to classes111.jar, but now get this error: java.lang.UnsatisfiedLinkError: no ocijdbc8 in shared library path Also I should point out that I am using Oracle 8.0.4 on HP. Thanks for the suggestions though -----Original Message----- From: p niemandt [mailto:[EMAIL PROTECTED]] Sent: 07 January 2003 18:25 To: Tomcat Users List Subject: RE: HP-UX 10.20 + Oracle As far as I know you should use ojdbc14.jar for Oracle9: Though previous ones should work, the ojdbc14.jar is recommended / needed for Oracle9. {The classnames are different between classes12.jar and the new ojdbc14.jar} On Tue, 2003-01-07 at 17:57, Wagoner, Mark wrote: > I think classes12.jar is for JDK 1.2. You want classes111.jar (if you can > find it). > > -----Original Message----- > From: John Clark [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 07, 2003 12:54 PM > To: 'Tomcat Users List' > Subject: HP-UX 10.20 + Oracle > > > Hi there, > > The story so far: I have an intranet application that currently runs on a > Linux server (with Oracle 9i - built-in Apache) and W2000 server (with > Tomcat 4.x connecting to Oracle 8). It is written in JSP and Java, and works > fine. > > I now want to use HP-UX 10.20 as a server, so I got the only available JDK > from HP which is version 1.1.8 and this has forced me to use Tomcat 3.3.1. > This is all running now (thanks for the help) and I am now testing the > application. > > I have put in the Oracle classes12.jar and DriverManager.registerDriver > seems fine, but DriverManager.getConnection gives the following error (only > partial list): > > java.lang.ClassNotFoundException: java.util.Map > at org.apache.tomcat.util.compat.SimpleClassLoader.loadClass(Compiled Code) > at java.lang.ClassLoader.loadClassInternal(Compiled Code) > at > oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java: 358) > at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:260) > at java.sql.DriverManager.getConnection(DriverManager.java:83) > at java.sql.DriverManager.getConnection(DriverManager.java:126) > at estimating._final.loginvalidate_1._jspService(loginvalidate_1.java:123) > > Anyone got any ideas? > > Many thanks as usual. > > John > > > > -- > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
