Re: Oracle JDBC in CLASSPATH for Tomcat 4.0
On Tue, 17 Jul 2001, Scott Brinker wrote: D:\oracle\ora81\jdbc\lib\classes12.zip Tomcat 4 looks only for JAR files, not ZIP files. Craig McClanahan
RE: Oracle JDBC in CLASSPATH for Tomcat 4.0
Simply renaming classes12.zip to classes12.jar and putting it into WEB-INF/lib works for me. thanks, Jerry -Original Message- From: Mike Jackson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 17, 2001 4:15 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Oracle JDBC in CLASSPATH for Tomcat 4.0 Just rename the files to be a .jar file. --mikej -=- mike jackson [EMAIL PROTECTED] -Original Message- From: Charles Lee [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 17, 2001 4:06 PM To: [EMAIL PROTECTED] Subject: RE: Oracle JDBC in CLASSPATH for Tomcat 4.0 I would suggest you to unzip(use winzip program) the classes12.zip to the .../lib directory. I am sure it will work. TOMCAT doesn't pick up zip file. Charles Lee -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Sampige, Srinivas Sent: Tuesday, July 17, 2001 3:52 PM To: '[EMAIL PROTECTED]' Subject: RE: Oracle JDBC in CLASSPATH for Tomcat 4.0 What i told you definitely works at least for the .jar files;from what you say it looks like Tomcat isn't picking up .zip files (i personally haven't tried it with .zip files).I would leave this question to be anwered by one of the Tomcat Dev Team members .But for now what i would try is - - edit the tomcat.bat found in the bin folder of the tomcat installation .Here is what the first few lines look like(what is in red is what you need to add) :- --- rem - Save Environment Variables That May Change set _CP=%CP% set _TOMCAT_HOME=%TOMCAT_HOME% set _CLASSPATH=%CLASSPATH% --- Modify the last line as - set _CLASSPATH=%CLASSPATH%;D:\oracle\ora81\jdbc\lib\classes12.zip Let me know if this helps. -Srinivas -Original Message- From: John Hebert [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 17, 2001 3:46 PM To: [EMAIL PROTECTED] Subject: Re: Oracle JDBC in CLASSPATH for Tomcat 4.0 Scott Brinker wrote: Alas, it's still not finding it. I now have the classes12.zip in the following locations: /jakarta-tomcat-4.0-b5/lib /jakarta-tomcat-4.0-b5/common/lib /jakarta-tomcat-4.0-b5/webapps/test/WEB-INF/lib ...(the latter being my web app), in addition to the CLASSPATH environment variable. Any other thoughts? Can you confirm it is a valid archive (jar -t classes12.zip)? -- John Alex Hebert [EMAIL PROTECTED] System Engineer
RE: Oracle JDBC in CLASSPATH for Tomcat 4.0
put the zip file under /lib folder that you find under your tomcat installation.Should work without having to set the classpath because tomcat puts everything under /lib in classpath autmoatically when it starts up . -Original Message- From: Scott Brinker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 17, 2001 3:19 PM To: [EMAIL PROTECTED] Subject: Oracle JDBC in CLASSPATH for Tomcat 4.0 I am trying to load the Oracle 8.1.7 thin client JDBC driver in a simple servlet under Tomcat 4.0-b5. However, the following line: Class.forName(oracle.jdbc.driver.OracleDriver); ...keeps generating a ClassNotFoundException. I am running on Windows 2000, and I have verified that the CLASSPATH environment variable is: D:\oracle\ora81\jdbc\lib\classes12.zip ...which is where the JDBC driver is. (I can write a stand-alone Java application that loads that driver just fine, so I know it is where I think it is.) For what it's worth, I'm also running under JDK 1.3.1. Do I have to do something special to have my web app recognize the system CLASSPATH? Is there some place else I need to explicitly define it? Many thanks, Scott
Re: Oracle JDBC in CLASSPATH for Tomcat 4.0
Alas, it's still not finding it. I now have the classes12.zip in the following locations: /jakarta-tomcat-4.0-b5/lib /jakarta-tomcat-4.0-b5/common/lib /jakarta-tomcat-4.0-b5/webapps/test/WEB-INF/lib ...(the latter being my web app), in addition to the CLASSPATH environment variable. Any other thoughts? Thanks, Scott - Original Message - From: Sampige, Srinivas [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 17, 2001 6:24 PM Subject: RE: Oracle JDBC in CLASSPATH for Tomcat 4.0 put the zip file under /lib folder that you find under your tomcat installation.Should work without having to set the classpath because tomcat puts everything under /lib in classpath autmoatically when it starts up .
Re: Oracle JDBC in CLASSPATH for Tomcat 4.0
Scott Brinker wrote: Alas, it's still not finding it. I now have the classes12.zip in the following locations: /jakarta-tomcat-4.0-b5/lib /jakarta-tomcat-4.0-b5/common/lib /jakarta-tomcat-4.0-b5/webapps/test/WEB-INF/lib ...(the latter being my web app), in addition to the CLASSPATH environment variable. Any other thoughts? Can you confirm it is a valid archive (jar -t classes12.zip)? -- John Alex Hebert [EMAIL PROTECTED] System Engineer
Re: Oracle JDBC in CLASSPATH for Tomcat 4.0
Can you confirm it is a valid archive (jar -t classes12.zip)? -- John Alex Hebert [EMAIL PROTECTED] System Engineer Ah, I figured it out: I had to rename the file from classes12.zip to classes12.jar in the root /lib directory. (Apparently Tomcat appends only .jar's to its classpath, not .zip's, and must not pay attention to the system CLASSPATH variable.) Thanks John, Srinivas, Scott
RE: Oracle JDBC in CLASSPATH for Tomcat 4.0
What i told you definitely works at least for the .jar files;from what you say it looks like Tomcat isn't picking up .zip files (i personally haven't tried it with .zip files).I would leave this question to be anwered by one of the Tomcat Dev Team members .But for now what i would try is - - edit the tomcat.bat found in the bin folder of the tomcat installation .Here is what the first few lines look like(what is in red is what you need to add) :- --- rem - Save Environment Variables That May Change set _CP=%CP% set _TOMCAT_HOME=%TOMCAT_HOME% set _CLASSPATH=%CLASSPATH% --- Modify the last line as - set _CLASSPATH=%CLASSPATH%;D:\oracle\ora81\jdbc\lib\classes12.zip Let me know if this helps. -Srinivas -Original Message- From: John Hebert [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 17, 2001 3:46 PM To: [EMAIL PROTECTED] Subject: Re: Oracle JDBC in CLASSPATH for Tomcat 4.0 Scott Brinker wrote: Alas, it's still not finding it. I now have the classes12.zip in the following locations: /jakarta-tomcat-4.0-b5/lib /jakarta-tomcat-4.0-b5/common/lib /jakarta-tomcat-4.0-b5/webapps/test/WEB-INF/lib ...(the latter being my web app), in addition to the CLASSPATH environment variable. Any other thoughts? Can you confirm it is a valid archive (jar -t classes12.zip)? -- John Alex Hebert [EMAIL PROTECTED] System Engineer
RE: Oracle JDBC in CLASSPATH for Tomcat 4.0
I would suggest you to unzip(use winzip program) the classes12.zip to the .../lib directory. I am sure it will work. TOMCAT doesn't pick up zip file. Charles Lee -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Sampige, Srinivas Sent: Tuesday, July 17, 2001 3:52 PM To: '[EMAIL PROTECTED]' Subject: RE: Oracle JDBC in CLASSPATH for Tomcat 4.0 What i told you definitely works at least for the .jar files;from what you say it looks like Tomcat isn't picking up .zip files (i personally haven't tried it with .zip files).I would leave this question to be anwered by one of the Tomcat Dev Team members .But for now what i would try is - - edit the tomcat.bat found in the bin folder of the tomcat installation .Here is what the first few lines look like(what is in red is what you need to add) :- --- rem - Save Environment Variables That May Change set _CP=%CP% set _TOMCAT_HOME=%TOMCAT_HOME% set _CLASSPATH=%CLASSPATH% --- Modify the last line as - set _CLASSPATH=%CLASSPATH%;D:\oracle\ora81\jdbc\lib\classes12.zip Let me know if this helps. -Srinivas -Original Message- From: John Hebert [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 17, 2001 3:46 PM To: [EMAIL PROTECTED] Subject: Re: Oracle JDBC in CLASSPATH for Tomcat 4.0 Scott Brinker wrote: Alas, it's still not finding it. I now have the classes12.zip in the following locations: /jakarta-tomcat-4.0-b5/lib /jakarta-tomcat-4.0-b5/common/lib /jakarta-tomcat-4.0-b5/webapps/test/WEB-INF/lib ...(the latter being my web app), in addition to the CLASSPATH environment variable. Any other thoughts? Can you confirm it is a valid archive (jar -t classes12.zip)? -- John Alex Hebert [EMAIL PROTECTED] System Engineer
RE: Oracle JDBC in CLASSPATH for Tomcat 4.0
Just rename the files to be a .jar file. --mikej -=- mike jackson [EMAIL PROTECTED] -Original Message- From: Charles Lee [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 17, 2001 4:06 PM To: [EMAIL PROTECTED] Subject: RE: Oracle JDBC in CLASSPATH for Tomcat 4.0 I would suggest you to unzip(use winzip program) the classes12.zip to the .../lib directory. I am sure it will work. TOMCAT doesn't pick up zip file. Charles Lee -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Sampige, Srinivas Sent: Tuesday, July 17, 2001 3:52 PM To: '[EMAIL PROTECTED]' Subject: RE: Oracle JDBC in CLASSPATH for Tomcat 4.0 What i told you definitely works at least for the .jar files;from what you say it looks like Tomcat isn't picking up .zip files (i personally haven't tried it with .zip files).I would leave this question to be anwered by one of the Tomcat Dev Team members .But for now what i would try is - - edit the tomcat.bat found in the bin folder of the tomcat installation .Here is what the first few lines look like(what is in red is what you need to add) :- --- rem - Save Environment Variables That May Change set _CP=%CP% set _TOMCAT_HOME=%TOMCAT_HOME% set _CLASSPATH=%CLASSPATH% --- Modify the last line as - set _CLASSPATH=%CLASSPATH%;D:\oracle\ora81\jdbc\lib\classes12.zip Let me know if this helps. -Srinivas -Original Message- From: John Hebert [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 17, 2001 3:46 PM To: [EMAIL PROTECTED] Subject: Re: Oracle JDBC in CLASSPATH for Tomcat 4.0 Scott Brinker wrote: Alas, it's still not finding it. I now have the classes12.zip in the following locations: /jakarta-tomcat-4.0-b5/lib /jakarta-tomcat-4.0-b5/common/lib /jakarta-tomcat-4.0-b5/webapps/test/WEB-INF/lib ...(the latter being my web app), in addition to the CLASSPATH environment variable. Any other thoughts? Can you confirm it is a valid archive (jar -t classes12.zip)? -- John Alex Hebert [EMAIL PROTECTED] System Engineer
RE: Oracle JDBC in CLASSPATH for Tomcat 4.0
From memory this has come up before, and it is in the servlet 2.2 spec that the servlet container will load all jars in the lib dirs - hence excluding zips. I'm not sure how this affects the system classpath though... cheers dim On Tue, 17 Jul 2001, Sampige, Srinivas wrote: What i told you definitely works at least for the .jar files;from what you say it looks like Tomcat isn't picking up .zip files (i personally haven't tried it with .zip files).I would leave this question to be anwered by one of the Tomcat Dev Team members .But for now what i would try is - - edit the tomcat.bat found in the bin folder of the tomcat installation .Here is what the first few lines look like(what is in red is what you need to add) :- --- rem - Save Environment Variables That May Change set _CP=%CP% set _TOMCAT_HOME=%TOMCAT_HOME% set _CLASSPATH=%CLASSPATH% --- Modify the last line as - set _CLASSPATH=%CLASSPATH%;D:\oracle\ora81\jdbc\lib\classes12.zip Let me know if this helps. -Srinivas -Original Message- From: John Hebert [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 17, 2001 3:46 PM To: [EMAIL PROTECTED] Subject: Re: Oracle JDBC in CLASSPATH for Tomcat 4.0 Scott Brinker wrote: Alas, it's still not finding it. I now have the classes12.zip in the following locations: /jakarta-tomcat-4.0-b5/lib /jakarta-tomcat-4.0-b5/common/lib /jakarta-tomcat-4.0-b5/webapps/test/WEB-INF/lib ...(the latter being my web app), in addition to the CLASSPATH environment variable. Any other thoughts? Can you confirm it is a valid archive (jar -t classes12.zip)? -- John Alex Hebert [EMAIL PROTECTED] System Engineer
