2 Replies Latest reply on Oct 20, 2004 11:04 AM by Malcolm Sommerville

    DB2 JDBC problems with 3.2.6

    Malcolm Sommerville Newbie

      Hi,

      I can't get 3.2.6 (on Linux) to speak to my DB2 database. I have set up the server config, which is a vanilla copy of the default configuration, called jboss0 (I plan to run multiple instances, if I can ever get the first one working). I have put the db2-ds.xml file, modified for our environment into the jboss0/deploy directory and the driver file db2java.zip into jboss0/lib. I then dropped one of the war files which is working perfectly under 3.2.1 into the deploy directory.

      Start up, the instance - so far so good - everything starts up nicely. Try to use any of the servlets in the war file and I get:

      Error - Time: 20/10/2004 14:02:35 Source: ConnectionPoolMgr.getConnection2-2 Error: Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceException: Failed to register driver for: COM.ibm.db2.jdbc.app.DB2Driver; - nested throwable: (java.sql.SQLException: java.lang.UnsatisfiedLinkError: no db2jdbc in java.library.path)); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceException: Failed to register driver for: COM.ibm.db2.jdbc.app.DB2Driver; - nested throwable: (java.sql.SQLException: java.lang.UnsatisfiedLinkError: no db2jdbc in java.library.path)))

      The request is coming from a web server running apace via jk2 and is comming through ok, and the database is up, running and can be connected to using the DB2 client.

      What am I missing? Any help gratefully received.

      Thanks,

      Malcolm