Re: Tomcat/apache - JDBC errors w/ jt400.jar?
Hi Guys, Thanks for the tips. Ok - I'll make sure I have jt400.jar in only one dir. And not mess with the ClassPath, got it. Yep, sorry - I meant JDBC. We never used jk2, just mod_jk - I mis-wrote! Wwe found that we coded the server.xml wrong. Apparently it changed - we had been using Tomcat 5.5.12 and it appears the syntax for the XML changed in 5.5.26? -P David Smith-2 wrote: > > 1. Don't ever modify the CLASSPATH. Tomcat by default ignore's it and > for good reason. > > 2. Your webapp's WEB-INF/lib and tomcat's common/lib are essentially > mutually exclusive when it comes to jar files. If the .jar file exists > in one, it can't exist in the other. If you have jt400.jar in both, > remove it from one. If you are using it for a tomcat provided database > pool, it should be removed from your webapp's WEB-INF/lib. Otherwise > it's up to you which one is dropped. > >> WE have compiled a mod_jk tha apache accepts and we can server up *.jsp's >> from our website but don;t have issues until we add the jt400.jar file? >> WE have tried multiple versions of the jt400.jar file with no luck... > > I doubt mod_jk has anything to do with getting your IBM AS400 ODBC > connections to work. BTW, I hope you meant JDBC. ODBC is a MS > technology. > > --David > > pichels wrote: >> Hi, >> >> I am newbie - pardon any lack of details or etiquite on my first post! >> >> >> We are trying to get our website to run correctly on a RHEL5.2 Linux >> server >> and getting errors with the JDBC - IBM AS400 ODBC connection. >> >> >> >> >> SEVERE: Servlet /wsidr threw load() exception >> java.lang.NoClassDefFoundError: com/ibm/as400/access/DirectoryEntryList >> at java.lang.Class.getDeclaredConstructors0(Native Method) >> >> ERROR LOADING CALENDAR: org.apache.tomcat.dbcp.dbcp.SQLNestedException: >> Cannot load JDBC driver class 'com.ibm.as400.access.AS400JDBCDriver' >> SQL error: Cannot load JDBC driver class >> 'com.ibm.as400.access.AS400JDBCDriver' >> >> >> >> >> >> >> JAVA: >> [EMAIL PROTECTED] root]# java -version >> java version "1.5.0_15" >> Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_15-b04) >> Java HotSpot(TM) Client VM (build 1.5.0_15-b04, mixed mode, sharing) >> >> HTTP: >> [EMAIL PROTECTED] root]# apachectl -v >> Server version: Apache/2.0.46 >> Server built: Jun 19 2008 11:46:47 >> >> APACHE-Tomat: >> Tomcat 5.5.26 >> >> We have our jt400.jar in our classpath var within our webapps dir and in >> common/lib. >> >> /usr/local/tomcat5/common/lib/jt400.jar >> >> But, when we copy the jt400.jar file to this dir - it locks tomcat and >> the >> apache/tomcat connection locks and we have to "killall java" to shutdown! >> >> WE have compiled a mod_jk tha apache accepts and we can server up *.jsp's >> from our website but don;t have issues until we add the jt400.jar file? >> WE have tried multiple versions of the jt400.jar file with no luck... >> >> Our server.xml appears to be configured correctly. >> Haven't messed with the web.xml or any other config files. >> Do we need to add a workers.properties file to the Apache httpd conf? >> >> We configured older versions of tomcat/apache along time ago that worked >> with mod_jk + workers.properties, etc. >> Do we need to use jk2 or something else now? >> >> Any ideas or need more details? >> TIA >> >> -P >> >> >> >> >> >> >> >> > > > - > To start a new topic, e-mail: users@tomcat.apache.org > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > -- View this message in context: http://www.nabble.com/Tomcat-apache---JDBC-errors-w--jt400.jar--tp19544738p19559690.html Sent from the Tomcat - User mailing list archive at Nabble.com. - To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Tomcat/apache - JDBC errors w/ jt400.jar?
agreed you should'nt duplicate any jars for webapp specific WEB-INF/lib with same driver jars in COMMON/lib keep your java and JDBC and TC environment simple by deploying everything either on windows and or unix box first when you get Java, TC, DB and webapps working and your boss has alot of money *and time* feel free to complicate your working environment with ODBC drivers (why you need to use MS DB driver technology when a jdbc driver will do is beyond me) port the environment to problematic platforms such as AS400 In case anything goes awry and it will you can always fall back to your working environment GL Martin __ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission. > Date: Thu, 18 Sep 2008 08:58:46 -0400 > From: [EMAIL PROTECTED] > To: users@tomcat.apache.org > Subject: Re: Tomcat/apache - JDBC errors w/ jt400.jar? > > 1. Don't ever modify the CLASSPATH. Tomcat by default ignore's it and > for good reason. > > 2. Your webapp's WEB-INF/lib and tomcat's common/lib are essentially > mutually exclusive when it comes to jar files. If the .jar file exists > in one, it can't exist in the other. If you have jt400.jar in both, > remove it from one. If you are using it for a tomcat provided database > pool, it should be removed from your webapp's WEB-INF/lib. Otherwise > it's up to you which one is dropped. > > > WE have compiled a mod_jk tha apache accepts and we can server up *.jsp's > > from our website but don;t have issues until we add the jt400.jar file? > > WE have tried multiple versions of the jt400.jar file with no luck... > > I doubt mod_jk has anything to do with getting your IBM AS400 ODBC > connections to work. BTW, I hope you meant JDBC. ODBC is a MS technology. > > --David > > pichels wrote: > > Hi, > > > > I am newbie - pardon any lack of details or etiquite on my first post! > > > > > > We are trying to get our website to run correctly on a RHEL5.2 Linux server > > and getting errors with the JDBC - IBM AS400 ODBC connection. > > > > > > > > > > SEVERE: Servlet /wsidr threw load() exception > > java.lang.NoClassDefFoundError: com/ibm/as400/access/DirectoryEntryList > > at java.lang.Class.getDeclaredConstructors0(Native Method) > > > > ERROR LOADING CALENDAR: org.apache.tomcat.dbcp.dbcp.SQLNestedException: > > Cannot load JDBC driver class 'com.ibm.as400.access.AS400JDBCDriver' > > SQL error: Cannot load JDBC driver class > > 'com.ibm.as400.access.AS400JDBCDriver' > > > > > > > > > > > > > > JAVA: > > [EMAIL PROTECTED] root]# java -version > > java version "1.5.0_15" > > Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_15-b04) > > Java HotSpot(TM) Client VM (build 1.5.0_15-b04, mixed mode, sharing) > > > > HTTP: > > [EMAIL PROTECTED] root]# apachectl -v > > Server version: Apache/2.0.46 > > Server built: Jun 19 2008 11:46:47 > > > > APACHE-Tomat: > > Tomcat 5.5.26 > > > > We have our jt400.jar in our classpath var within our webapps dir and in > > common/lib. > > > > /usr/local/tomcat5/common/lib/jt400.jar > > > > But, when we copy the jt400.jar file to this dir - it locks tomcat and the > > apache/tomcat connection locks and we have to "killall java" to shutdown! > > > > WE have compiled a mod_jk tha apache accepts and we can server up *.jsp's > > from our website but don;t have issues until we add the jt400.jar file? > > WE have tried multiple versions of the jt400.jar file with no luck... > > > > Our server.xml appears to be configured correctly. > > Haven't messed with the web.xml or any other config files. > > Do we need to add a workers.properties file to the Apache httpd conf? > > > > We configured older versions of tomcat/apache along time ago that worked > > with mod_jk + workers.properties, etc. > > Do we need to use jk2 or something else now? > > > > Any ideas or need more details? > > TIA > > > > -P > > > > > > > > > > > > > > > > > > > - > To start a new topic, e-mail: users@tomcat.apache.org > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > _ See how Windows connects the people, information, and fun that are part of your life. http://clk.atdmt.com/MRT/go/msnnkwxp1020093175mrt/direct/01/
Re: Tomcat/apache - JDBC errors w/ jt400.jar?
1. Don't ever modify the CLASSPATH. Tomcat by default ignore's it and for good reason. 2. Your webapp's WEB-INF/lib and tomcat's common/lib are essentially mutually exclusive when it comes to jar files. If the .jar file exists in one, it can't exist in the other. If you have jt400.jar in both, remove it from one. If you are using it for a tomcat provided database pool, it should be removed from your webapp's WEB-INF/lib. Otherwise it's up to you which one is dropped. > WE have compiled a mod_jk tha apache accepts and we can server up *.jsp's > from our website but don;t have issues until we add the jt400.jar file? > WE have tried multiple versions of the jt400.jar file with no luck... I doubt mod_jk has anything to do with getting your IBM AS400 ODBC connections to work. BTW, I hope you meant JDBC. ODBC is a MS technology. --David pichels wrote: > Hi, > > I am newbie - pardon any lack of details or etiquite on my first post! > > > We are trying to get our website to run correctly on a RHEL5.2 Linux server > and getting errors with the JDBC - IBM AS400 ODBC connection. > > > > > SEVERE: Servlet /wsidr threw load() exception > java.lang.NoClassDefFoundError: com/ibm/as400/access/DirectoryEntryList > at java.lang.Class.getDeclaredConstructors0(Native Method) > > ERROR LOADING CALENDAR: org.apache.tomcat.dbcp.dbcp.SQLNestedException: > Cannot load JDBC driver class 'com.ibm.as400.access.AS400JDBCDriver' > SQL error: Cannot load JDBC driver class > 'com.ibm.as400.access.AS400JDBCDriver' > > > > > > > JAVA: > [EMAIL PROTECTED] root]# java -version > java version "1.5.0_15" > Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_15-b04) > Java HotSpot(TM) Client VM (build 1.5.0_15-b04, mixed mode, sharing) > > HTTP: > [EMAIL PROTECTED] root]# apachectl -v > Server version: Apache/2.0.46 > Server built: Jun 19 2008 11:46:47 > > APACHE-Tomat: > Tomcat 5.5.26 > > We have our jt400.jar in our classpath var within our webapps dir and in > common/lib. > > /usr/local/tomcat5/common/lib/jt400.jar > > But, when we copy the jt400.jar file to this dir - it locks tomcat and the > apache/tomcat connection locks and we have to "killall java" to shutdown! > > WE have compiled a mod_jk tha apache accepts and we can server up *.jsp's > from our website but don;t have issues until we add the jt400.jar file? > WE have tried multiple versions of the jt400.jar file with no luck... > > Our server.xml appears to be configured correctly. > Haven't messed with the web.xml or any other config files. > Do we need to add a workers.properties file to the Apache httpd conf? > > We configured older versions of tomcat/apache along time ago that worked > with mod_jk + workers.properties, etc. > Do we need to use jk2 or something else now? > > Any ideas or need more details? > TIA > > -P > > > > > > > > - To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Tomcat/apache - JDBC errors w/ jt400.jar?
> From: pichels [mailto:[EMAIL PROTECTED] > Subject: Tomcat/apache - JDBC errors w/ jt400.jar? > > We have our jt400.jar in our classpath var within our webapps > dir and in common/lib. Never, ever, use a CLASSPATH environment variable with Tomcat. Your jt400.jar must not be in two places at once; put it in either the webapp's WEB-INF/lib directory OR in common/lib, but not both. (WEB-INF/lib is preferred.) > Do we need to use jk2 or something else now? The jk2 connector died several years ago, as noted in the Tomcat doc. Get things working with direct Tomcat access first, then worry about hooking Tomcat up to httpd, if that's really necessary at all. (Unless you're using httpd for load balancing or something like PHP, it will only worsen performance with modern versions of Tomcat.) - Chuck THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY MATERIAL and is thus for use only by the intended recipient. If you received this in error, please contact the sender and delete the e-mail and its attachments from all computers. - To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Tomcat/apache - JDBC errors w/ jt400.jar?
Hi, I am newbie - pardon any lack of details or etiquite on my first post! We are trying to get our website to run correctly on a RHEL5.2 Linux server and getting errors with the JDBC - IBM AS400 ODBC connection. SEVERE: Servlet /wsidr threw load() exception java.lang.NoClassDefFoundError: com/ibm/as400/access/DirectoryEntryList at java.lang.Class.getDeclaredConstructors0(Native Method) ERROR LOADING CALENDAR: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.ibm.as400.access.AS400JDBCDriver' SQL error: Cannot load JDBC driver class 'com.ibm.as400.access.AS400JDBCDriver' JAVA: [EMAIL PROTECTED] root]# java -version java version "1.5.0_15" Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_15-b04) Java HotSpot(TM) Client VM (build 1.5.0_15-b04, mixed mode, sharing) HTTP: [EMAIL PROTECTED] root]# apachectl -v Server version: Apache/2.0.46 Server built: Jun 19 2008 11:46:47 APACHE-Tomat: Tomcat 5.5.26 We have our jt400.jar in our classpath var within our webapps dir and in common/lib. /usr/local/tomcat5/common/lib/jt400.jar But, when we copy the jt400.jar file to this dir - it locks tomcat and the apache/tomcat connection locks and we have to "killall java" to shutdown! WE have compiled a mod_jk tha apache accepts and we can server up *.jsp's from our website but don;t have issues until we add the jt400.jar file? WE have tried multiple versions of the jt400.jar file with no luck... Our server.xml appears to be configured correctly. Haven't messed with the web.xml or any other config files. Do we need to add a workers.properties file to the Apache httpd conf? We configured older versions of tomcat/apache along time ago that worked with mod_jk + workers.properties, etc. Do we need to use jk2 or something else now? Any ideas or need more details? TIA -P -- View this message in context: http://www.nabble.com/Tomcat-apache---JDBC-errors-w--jt400.jar--tp19544738p19544738.html Sent from the Tomcat - User mailing list archive at Nabble.com. - To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]