You could try CLASSPATH rather than LIBPATH in your startup.sh I think that's what is used for .jar files
-----Original Message----- From: Linux on 390 Port [mailto:[EMAIL PROTECTED] Behalf Of Manuela Vorazzo Sent: Wednesday, August 31, 2005 6:23 AM To: [email protected] Subject: problem with Tomcat and DB2 Connection to Z/OS DB2 Hello everyone! I've configured TomCat 4.0.40 on my Z/Linux (Suse 8), I've deployed an application that has to access DB2 on z/OS via jdbc. In our Linux environment we have installed DB2 Connect too. This is an extract of my server.xml file: <Context path="/sm4c-tc/bks" docBase="/opt/smac/banksys/portal4c" debug="9"> <Resource name="jdbc/smac" auth="Container" type="javax.sql.DataSource"/> <ResourceParams name="jdbc/smac"> <parameter> <name>user</name> <value>pippo</value> </parameter> <parameter> <name>password</name> <value>password</value> </parameter> <parameter> <name>driverClassName</name> <value>COM.ibm.db2.jdbc.app.DB2Driver</value> </parameter> <parameter> <parameter> <name>url</name> <value>jdbc:db2:D555</value> </parameter> <name>driverName</name> <value>jdbc:db2:D555</value> </parameter> </ResourceParams> </Context> I've copied db2java.zip from /opt/IBM/db2/V8.1/java to the common/lib directory of my server TomCat. And here I've renamed it into db2java.jar. When I test my web application I get the following error. TyrexDataSourceFactory: Cannot create DataSource, Exception java.sql.SQLException: java.lang.UnsatisfiedLinkError: Can't find library db2jdbc (libdb2jdbc.so) in sun.boot.library.path sun.boot.library.path=/opt/IBMJava2-s390-142/bin/../jre/bin at COM.ibm.db2.jdbc.app.DB2Driver.<init>(Unknown Source) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAcces sorImpl.java:80) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstruc torAccessorImpl.java:44) at java.lang.reflect.Constructor.newInstance(Constructor.java:315) at java.lang.Class.newInstance3(Class.java:367) .......................................................................... I've tried exporting LIBPATH and LD_LIBRARY_PATH in my catalina.sh but the configuration doesn't work and I get the same error. Then I've tried to put the libdb2jdbc.so in my JVM jre environment in /opt/IBMJava2-s390-142/jre/bin directory. So I don't get the error but it seems that the server Tomcat doesn't work anymore. >From my browser I can't see anything and in my server log file catalina.out I can't see any message. In this situation I've had to kill the server because I cannot stop the server with catalina.sh stop command. It seems like the libdb2jdbc.so '"dirties" the environment (the java environment, I believe) of the TomCat Application Server. How Have I to configure TomCat in order to access my DB2. Could you help me? Where Can I find some information about it. Please let me know. Thanks in advance. Greetings Manuela Vorazzo ---------------------------------------------------------------------- For LINUX-390 subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390 ************************************************************************* PRIVILEGED AND CONFIDENTIAL: This communication, including attachments, is for the exclusive use of addressee and may contain proprietary, confidential and/or privileged information. If you are not the intended recipient, any use, copying, disclosure, dissemination or distribution is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this communication and destroy all copies. ************************************************************************* ---------------------------------------------------------------------- For LINUX-390 subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390
