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/
