Where to place JDBC drivers? How?
I found some JDBC drivers for accesing an IBM AS400 But I can't get them to work within the browser environment. I placed an entry in my system variables Name: CLASSPATH Value: loacation of JDBC.jar file;location of JDBC license.jar (in windows is CLASSPATH = Path???) The Drivers came with a few applets; with the correct information these applets will connect to my as400 db but with the same info my jsp pages won't connect, I keep getting errors that look like this A Servlet Exception Has Occurred Exception Report: javax.servlet.ServletException: hit.as400.As400Driver Root Cause: java.lang.ClassNotFoundException: hit.as400.As400Driver Where should these jar files be placed? Do they need to be within the webapp tree? DO I need to reference their location in the server.xml file?? Should they be placed within the JDK tree??? Anyone? -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
RE: Where to place JDBC drivers? How?
You need to make sure you put a reference to the driver location in your class_path variable. Where you need to do this depends on how you're running tomcat, modify the environment classpath variable or in the worker.properties file, or in the wrapper.properties file etc -Original Message- From: Mike Kelley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 6:53 PM To: [EMAIL PROTECTED] Subject: Where to place JDBC drivers? How? I found some JDBC drivers for accesing an IBM AS400 But I can't get them to work within the browser environment. I placed an entry in my system variables Name: CLASSPATH Value: loacation of JDBC.jar file;location of JDBC license.jar (in windows is CLASSPATH = Path???) The Drivers came with a few applets; with the correct information these applets will connect to my as400 db but with the same info my jsp pages won't connect, I keep getting errors that look like this A Servlet Exception Has Occurred Exception Report: javax.servlet.ServletException: hit.as400.As400Driver Root Cause: java.lang.ClassNotFoundException: hit.as400.As400Driver Where should these jar files be placed? Do they need to be within the webapp tree? DO I need to reference their location in the server.xml file?? Should they be placed within the JDK tree??? Anyone? -- 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]
RE: Where to place JDBC drivers? How?
I have a reference in the environment variables (should the name be CLASSPATH? Or is it an addition to the Path variable??) I'm also finding a few references to putting the jar JDBC files in the WEB-INF folder or in the lib folder... Could you help me out with a little more specifics towards the worker, wrapper etc ... -Original Message- From: Barney Hamish [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 11:07 AM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? You need to make sure you put a reference to the driver location in your class_path variable. Where you need to do this depends on how you're running tomcat, modify the environment classpath variable or in the worker.properties file, or in the wrapper.properties file etc -Original Message- From: Mike Kelley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 6:53 PM To: [EMAIL PROTECTED] Subject: Where to place JDBC drivers? How? I found some JDBC drivers for accesing an IBM AS400 But I can't get them to work within the browser environment. I placed an entry in my system variables Name: CLASSPATH Value: loacation of JDBC.jar file;location of JDBC license.jar (in windows is CLASSPATH = Path???) The Drivers came with a few applets; with the correct information these applets will connect to my as400 db but with the same info my jsp pages won't connect, I keep getting errors that look like this A Servlet Exception Has Occurred Exception Report: javax.servlet.ServletException: hit.as400.As400Driver Root Cause: java.lang.ClassNotFoundException: hit.as400.As400Driver Where should these jar files be placed? Do they need to be within the webapp tree? DO I need to reference their location in the server.xml file?? Should they be placed within the JDK tree??? Anyone? -- 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]
RE: Where to place JDBC drivers? How?
There are variations between versions of Tomcat on how things work. For instance, Tomcat 3.2 recognized things in the classpath whereas Tomcat 3.3 doesn't. 3.3 has directories in its installation where jars can be added globally. I don't know how 4.x handles it. To be safe, I think WEB-INF/lib is the recommended and most universal place to put jar files for your web application. Best Regards, Jason Koeninger JJ Computer Consulting http://www.jjcc.com On Wed, 28 Nov 2001 11:08:35 -0700, Mike Kelley wrote: I have a reference in the environment variables (should the name be CLASSPATH? Or is it an addition to the Path variable??) I'm also finding a few references to putting the jar JDBC files in the WEB-INF folder or in the lib folder... Could you help me out with a little more specifics towards the worker, wrapper etc ... -Original Message- From: Barney Hamish [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 11:07 AM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? You need to make sure you put a reference to the driver location in your class_path variable. Where you need to do this depends on how you're running tomcat, modify the environment classpath variable or in the worker.properties file, or in the wrapper.properties file etc -Original Message- From: Mike Kelley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 6:53 PM To: [EMAIL PROTECTED] Subject: Where to place JDBC drivers? How? I found some JDBC drivers for accesing an IBM AS400 But I can't get them to work within the browser environment. I placed an entry in my system variables Name: CLASSPATH Value: loacation of JDBC.jar file;location of JDBC license.jar (in windows is CLASSPATH = Path???) The Drivers came with a few applets; with the correct information these applets will connect to my as400 db but with the same info my jsp pages won't connect, I keep getting errors that look like this A Servlet Exception Has Occurred Exception Report: javax.servlet.ServletException: hit.as400.As400Driver Root Cause: java.lang.ClassNotFoundException: hit.as400.As400Driver Where should these jar files be placed? Do they need to be within the webapp tree? DO I need to reference their location in the server.xml file?? Should they be placed within the JDK tree??? Anyone? -- 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] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
RE: Where to place JDBC drivers? How?
It needs to be in the Classpath variable so that the jar file can be found. You can add it to the WEB-INF folder but then you will have to put a copy of the driver in the WEB-INF folder of every application that should be able to access the database. As for the other files it depends whether you're running Tomcat as a service under NT or not etc. There is a classpath variable that is passed to java in each of these files. The files are simple to edit, just open them up and have a look. -Original Message- From: Mike Kelley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 7:09 PM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? I have a reference in the environment variables (should the name be CLASSPATH? Or is it an addition to the Path variable??) I'm also finding a few references to putting the jar JDBC files in the WEB-INF folder or in the lib folder... Could you help me out with a little more specifics towards the worker, wrapper etc ... -Original Message- From: Barney Hamish [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 11:07 AM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? You need to make sure you put a reference to the driver location in your class_path variable. Where you need to do this depends on how you're running tomcat, modify the environment classpath variable or in the worker.properties file, or in the wrapper.properties file etc -Original Message- From: Mike Kelley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 6:53 PM To: [EMAIL PROTECTED] Subject: Where to place JDBC drivers? How? I found some JDBC drivers for accesing an IBM AS400 But I can't get them to work within the browser environment. I placed an entry in my system variables Name: CLASSPATH Value: loacation of JDBC.jar file;location of JDBC license.jar (in windows is CLASSPATH = Path???) The Drivers came with a few applets; with the correct information these applets will connect to my as400 db but with the same info my jsp pages won't connect, I keep getting errors that look like this A Servlet Exception Has Occurred Exception Report: javax.servlet.ServletException: hit.as400.As400Driver Root Cause: java.lang.ClassNotFoundException: hit.as400.As400Driver Where should these jar files be placed? Do they need to be within the webapp tree? DO I need to reference their location in the server.xml file?? Should they be placed within the JDK tree??? Anyone? -- 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] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
RE: Where to place JDBC drivers? How?
Yeah, I'm not afraid of editing the files, as you said that easy enough, yours was the first to suggest editing those files though ... The drivers came with some JSP HTML pages that are supposed to scces the as400 db, with all of these files though there was no WEB-INF file Would simply creating a WEB-INF file and placing said drivers in the folder be enough? Or do the jar/driver files just need to be in the WEB-INF in the webapps branch? (where I unpacked all the sample files from the jdbc provider)? Just for Info I'm running win2k sp2, apache 1.3.22, TC4.0, jdk1.3.1_01 The applications (apache tomact and apache) are listed as services under the windows services manager, I currently have them set as manual services so I can control the start up order and have easy access to starting/stopping/restarting -Original Message- From: Barney Hamish [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 11:19 AM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? It needs to be in the Classpath variable so that the jar file can be found. You can add it to the WEB-INF folder but then you will have to put a copy of the driver in the WEB-INF folder of every application that should be able to access the database. As for the other files it depends whether you're running Tomcat as a service under NT or not etc. There is a classpath variable that is passed to java in each of these files. The files are simple to edit, just open them up and have a look. -Original Message- From: Mike Kelley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 7:09 PM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? I have a reference in the environment variables (should the name be CLASSPATH? Or is it an addition to the Path variable??) I'm also finding a few references to putting the jar JDBC files in the WEB-INF folder or in the lib folder... Could you help me out with a little more specifics towards the worker, wrapper etc ... -Original Message- From: Barney Hamish [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 11:07 AM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? You need to make sure you put a reference to the driver location in your class_path variable. Where you need to do this depends on how you're running tomcat, modify the environment classpath variable or in the worker.properties file, or in the wrapper.properties file etc -Original Message- From: Mike Kelley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 6:53 PM To: [EMAIL PROTECTED] Subject: Where to place JDBC drivers? How? I found some JDBC drivers for accesing an IBM AS400 But I can't get them to work within the browser environment. I placed an entry in my system variables Name: CLASSPATH Value: loacation of JDBC.jar file;location of JDBC license.jar (in windows is CLASSPATH = Path???) The Drivers came with a few applets; with the correct information these applets will connect to my as400 db but with the same info my jsp pages won't connect, I keep getting errors that look like this A Servlet Exception Has Occurred Exception Report: javax.servlet.ServletException: hit.as400.As400Driver Root Cause: java.lang.ClassNotFoundException: hit.as400.As400Driver Where should these jar files be placed? Do they need to be within the webapp tree? DO I need to reference their location in the server.xml file?? Should they be placed within the JDK tree??? Anyone? -- 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] -- 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]
RE: Where to place JDBC drivers? How? SOLUTION FOUND!
(for my tower of cards at least) I'm new to all this and this is probably not the best solution BUT Placing my new JDBC.jar driver files within the Tomcat 4.0/common/lib/ folder got things to work . -Original Message- From: Mike Kelley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 11:29 AM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? Yeah, I'm not afraid of editing the files, as you said that easy enough, yours was the first to suggest editing those files though ... The drivers came with some JSP HTML pages that are supposed to scces the as400 db, with all of these files though there was no WEB-INF file Would simply creating a WEB-INF file and placing said drivers in the folder be enough? Or do the jar/driver files just need to be in the WEB-INF in the webapps branch? (where I unpacked all the sample files from the jdbc provider)? Just for Info I'm running win2k sp2, apache 1.3.22, TC4.0, jdk1.3.1_01 The applications (apache tomact and apache) are listed as services under the windows services manager, I currently have them set as manual services so I can control the start up order and have easy access to starting/stopping/restarting -Original Message- From: Barney Hamish [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 11:19 AM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? It needs to be in the Classpath variable so that the jar file can be found. You can add it to the WEB-INF folder but then you will have to put a copy of the driver in the WEB-INF folder of every application that should be able to access the database. As for the other files it depends whether you're running Tomcat as a service under NT or not etc. There is a classpath variable that is passed to java in each of these files. The files are simple to edit, just open them up and have a look. -Original Message- From: Mike Kelley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 7:09 PM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? I have a reference in the environment variables (should the name be CLASSPATH? Or is it an addition to the Path variable??) I'm also finding a few references to putting the jar JDBC files in the WEB-INF folder or in the lib folder... Could you help me out with a little more specifics towards the worker, wrapper etc ... -Original Message- From: Barney Hamish [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 11:07 AM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? You need to make sure you put a reference to the driver location in your class_path variable. Where you need to do this depends on how you're running tomcat, modify the environment classpath variable or in the worker.properties file, or in the wrapper.properties file etc -Original Message- From: Mike Kelley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 6:53 PM To: [EMAIL PROTECTED] Subject: Where to place JDBC drivers? How? I found some JDBC drivers for accesing an IBM AS400 But I can't get them to work within the browser environment. I placed an entry in my system variables Name: CLASSPATH Value: loacation of JDBC.jar file;location of JDBC license.jar (in windows is CLASSPATH = Path???) The Drivers came with a few applets; with the correct information these applets will connect to my as400 db but with the same info my jsp pages won't connect, I keep getting errors that look like this A Servlet Exception Has Occurred Exception Report: javax.servlet.ServletException: hit.as400.As400Driver Root Cause: java.lang.ClassNotFoundException: hit.as400.As400Driver Where should these jar files be placed? Do they need to be within the webapp tree? DO I need to reference their location in the server.xml file?? Should they be placed within the JDK tree??? Anyone? -- 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] -- 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]
Re: Where to place JDBC drivers? How? SOLUTION FOUND!
If you have only one web-app that references this driver, you should put it in WEB-INF/lib. This allows for better maintenance and management of your libraries and dependencies. To reference/load the driver classname, you could use a parameter entry in the web.xml file... You could even have a startup servlet to load the driver in DriverManager and/or have it available through some lookup system such as a JNDI service. I think this is cleaner than having it in Tomcat/common/lib UNLESS you want those drivers to be available for all web-apps you create. - Original Message - From: Mike Kelley [EMAIL PROTECTED] To: 'Tomcat Users List' [EMAIL PROTECTED] Sent: Wednesday, November 28, 2001 02:02 PM Subject: RE: Where to place JDBC drivers? How? SOLUTION FOUND! (for my tower of cards at least) I'm new to all this and this is probably not the best solution BUT Placing my new JDBC.jar driver files within the Tomcat 4.0/common/lib/ folder got things to work . -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
RE: Where to place JDBC drivers? How? SOLUTION FOUND!
But what about those of us who use the Oracle JDBC driver as part of the Oracle client install in /oracle/product//jdbc/lib/classes12.zip ^^^ - not jar Mitchell Evan Marx[EMAIL PROTECTED] ATT IP Network Configuration Provisioning Development -Original Message- From: Mike Kelley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 2:03 PM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? SOLUTION FOUND! (for my tower of cards at least) I'm new to all this and this is probably not the best solution BUT Placing my new JDBC.jar driver files within the Tomcat 4.0/common/lib/ folder got things to work . -Original Message- From: Mike Kelley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 11:29 AM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? Yeah, I'm not afraid of editing the files, as you said that easy enough, yours was the first to suggest editing those files though ... The drivers came with some JSP HTML pages that are supposed to scces the as400 db, with all of these files though there was no WEB-INF file Would simply creating a WEB-INF file and placing said drivers in the folder be enough? Or do the jar/driver files just need to be in the WEB-INF in the webapps branch? (where I unpacked all the sample files from the jdbc provider)? Just for Info I'm running win2k sp2, apache 1.3.22, TC4.0, jdk1.3.1_01 The applications (apache tomact and apache) are listed as services under the windows services manager, I currently have them set as manual services so I can control the start up order and have easy access to starting/stopping/restarting -Original Message- From: Barney Hamish [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 11:19 AM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? It needs to be in the Classpath variable so that the jar file can be found. You can add it to the WEB-INF folder but then you will have to put a copy of the driver in the WEB-INF folder of every application that should be able to access the database. As for the other files it depends whether you're running Tomcat as a service under NT or not etc. There is a classpath variable that is passed to java in each of these files. The files are simple to edit, just open them up and have a look. -Original Message- From: Mike Kelley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 7:09 PM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? I have a reference in the environment variables (should the name be CLASSPATH? Or is it an addition to the Path variable??) I'm also finding a few references to putting the jar JDBC files in the WEB-INF folder or in the lib folder... Could you help me out with a little more specifics towards the worker, wrapper etc ... -Original Message- From: Barney Hamish [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 11:07 AM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? You need to make sure you put a reference to the driver location in your class_path variable. Where you need to do this depends on how you're running tomcat, modify the environment classpath variable or in the worker.properties file, or in the wrapper.properties file etc -Original Message- From: Mike Kelley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 6:53 PM To: [EMAIL PROTECTED] Subject: Where to place JDBC drivers? How? I found some JDBC drivers for accesing an IBM AS400 But I can't get them to work within the browser environment. I placed an entry in my system variables Name: CLASSPATH Value: loacation of JDBC.jar file;location of JDBC license.jar (in windows is CLASSPATH = Path???) The Drivers came with a few applets; with the correct information these applets will connect to my as400 db but with the same info my jsp pages won't connect, I keep getting errors that look like this A Servlet Exception Has Occurred Exception Report: javax.servlet.ServletException: hit.as400.As400Driver Root Cause: java.lang.ClassNotFoundException: hit.as400.As400Driver Where should these jar files be placed? Do they need to be within the webapp tree? DO I need to reference their location in the server.xml file?? Should they be placed within the JDK tree??? Anyone? -- 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] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles
RE: Where to place JDBC drivers? How? SOLUTION FOUND!
I don't know why Oracle still names those files .zip, but it doesn't hurt anything to rename them to .jar. If you're on Unix, you can make a soft-link in WEB-INF/lib with a .jar extension that points to the .zip file. Donnie [EMAIL PROTECTED] 11/28/01 02:26PM But what about those of us who use the Oracle JDBC driver as part of the Oracle client install in /oracle/product//jdbc/lib/classes12.zip ^^^ - not jar Mitchell Evan Marx[EMAIL PROTECTED] ATT IP Network Configuration Provisioning Development -Original Message- From: Mike Kelley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 2:03 PM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? SOLUTION FOUND! (for my tower of cards at least) I'm new to all this and this is probably not the best solution BUT Placing my new JDBC.jar driver files within the Tomcat 4.0/common/lib/ folder got things to work . -Original Message- From: Mike Kelley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 11:29 AM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? Yeah, I'm not afraid of editing the files, as you said that easy enough, yours was the first to suggest editing those files though ... The drivers came with some JSP HTML pages that are supposed to scces the as400 db, with all of these files though there was no WEB-INF file Would simply creating a WEB-INF file and placing said drivers in the folder be enough? Or do the jar/driver files just need to be in the WEB-INF in the webapps branch? (where I unpacked all the sample files from the jdbc provider)? Just for Info I'm running win2k sp2, apache 1.3.22, TC4.0, jdk1.3.1_01 The applications (apache tomact and apache) are listed as services under the windows services manager, I currently have them set as manual services so I can control the start up order and have easy access to starting/stopping/restarting -Original Message- From: Barney Hamish [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 11:19 AM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? It needs to be in the Classpath variable so that the jar file can be found. You can add it to the WEB-INF folder but then you will have to put a copy of the driver in the WEB-INF folder of every application that should be able to access the database. As for the other files it depends whether you're running Tomcat as a service under NT or not etc. There is a classpath variable that is passed to java in each of these files. The files are simple to edit, just open them up and have a look. -Original Message- From: Mike Kelley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 7:09 PM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? I have a reference in the environment variables (should the name be CLASSPATH? Or is it an addition to the Path variable??) I'm also finding a few references to putting the jar JDBC files in the WEB-INF folder or in the lib folder... Could you help me out with a little more specifics towards the worker, wrapper etc ... -Original Message- From: Barney Hamish [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 11:07 AM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? You need to make sure you put a reference to the driver location in your class_path variable. Where you need to do this depends on how you're running tomcat, modify the environment classpath variable or in the worker.properties file, or in the wrapper.properties file etc -Original Message- From: Mike Kelley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 6:53 PM To: [EMAIL PROTECTED] Subject: Where to place JDBC drivers? How? I found some JDBC drivers for accesing an IBM AS400 But I can't get them to work within the browser environment. I placed an entry in my system variables Name: CLASSPATH Value: loacation of JDBC.jar file;location of JDBC license.jar (in windows is CLASSPATH = Path???) The Drivers came with a few applets; with the correct information these applets will connect to my as400 db but with the same info my jsp pages won't connect, I keep getting errors that look like this A Servlet Exception Has Occurred Exception Report: javax.servlet.ServletException: hit.as400.As400Driver Root Cause: java.lang.ClassNotFoundException: hit.as400.As400Driver Where should these jar files be placed? Do they need to be within the webapp tree? DO I need to reference their location in the server.xml file?? Should they be placed within the JDK tree??? Anyone? -- 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
Re: Where to place JDBC drivers? How? SOLUTION FOUND!
Not in my test with TC 4.01. I had to rename classes12.zip to .jar and distribute it with the WAR. Denis Balazuc wrote: Just rename the ZIP file to JAR...(100% safe) Or maybe Tomcat does support the ZIP extension too ? - Original Message - From: Marx, Mitchell E (Mitch), ALSVC [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Sent: Wednesday, November 28, 2001 02:26 PM Subject: RE: Where to place JDBC drivers? How? SOLUTION FOUND! But what about those of us who use the Oracle JDBC driver as part of the Oracle client install in /oracle/product//jdbc/lib/classes12.zip ^^^ - not jar Mitchell Evan Marx[EMAIL PROTECTED] ATT IP Network Configuration Provisioning Development -Original Message- From: Mike Kelley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 2:03 PM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? SOLUTION FOUND! (for my tower of cards at least) I'm new to all this and this is probably not the best solution BUT Placing my new JDBC.jar driver files within the Tomcat 4.0/common/lib/ folder got things to work . -Original Message- From: Mike Kelley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 11:29 AM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? Yeah, I'm not afraid of editing the files, as you said that easy enough, yours was the first to suggest editing those files though ... The drivers came with some JSP HTML pages that are supposed to scces the as400 db, with all of these files though there was no WEB-INF file Would simply creating a WEB-INF file and placing said drivers in the folder be enough? Or do the jar/driver files just need to be in the WEB-INF in the webapps branch? (where I unpacked all the sample files from the jdbc provider)? Just for Info I'm running win2k sp2, apache 1.3.22, TC4.0, jdk1.3.1_01 The applications (apache tomact and apache) are listed as services under the windows services manager, I currently have them set as manual services so I can control the start up order and have easy access to starting/stopping/restarting -Original Message- From: Barney Hamish [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 11:19 AM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? It needs to be in the Classpath variable so that the jar file can be found. You can add it to the WEB-INF folder but then you will have to put a copy of the driver in the WEB-INF folder of every application that should be able to access the database. As for the other files it depends whether you're running Tomcat as a service under NT or not etc. There is a classpath variable that is passed to java in each of these files. The files are simple to edit, just open them up and have a look. -Original Message- From: Mike Kelley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 7:09 PM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? I have a reference in the environment variables (should the name be CLASSPATH? Or is it an addition to the Path variable??) I'm also finding a few references to putting the jar JDBC files in the WEB-INF folder or in the lib folder... Could you help me out with a little more specifics towards the worker, wrapper etc ... -Original Message- From: Barney Hamish [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 11:07 AM To: 'Tomcat Users List' Subject: RE: Where to place JDBC drivers? How? You need to make sure you put a reference to the driver location in your class_path variable. Where you need to do this depends on how you're running tomcat, modify the environment classpath variable or in the worker.properties file, or in the wrapper.properties file etc -Original Message- From: Mike Kelley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 6:53 PM To: [EMAIL PROTECTED] Subject: Where to place JDBC drivers? How? I found some JDBC drivers for accesing an IBM AS400 But I can't get them to work within the browser environment. I placed an entry in my system variables Name: CLASSPATH Value: loacation of JDBC.jar file;location of JDBC license.jar (in windows is CLASSPATH = Path???) The Drivers came with a few applets; with the correct information these applets will connect to my as400 db but with the same info my jsp pages won't connect, I keep getting errors that look like this A Servlet Exception Has Occurred Exception Report: javax.servlet.ServletException: hit.as400.As400Driver Root Cause: java.lang.ClassNotFoundException: hit.as400.As400Driver Where should these jar files be placed? Do they need to be within the webapp tree? DO I need to reference their location