Connection to DB2

[gregsting]

Hi,

I have configured a JBoss cluster and I want it to use a DB2 database on another server. To test that I want to deploy Jboss portal on the cluster.

I've pretty much followed these instructions to set up the jdbc connection: http://www.onjava.com/lpt/a/4525#db2

I've seen many ways to configure such a connection but none seems to work. It seems that the config files are OK but JBoss cannot find the files it needs... the error is the following:

WARN [JBossManagedConnectionPool] Throwable while attempting to get a new connection: null
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))

What is the "java.librairy.path"? do I have to put some files there? Could it be a problem of a wrong version of JDK/JRE?

[gregsting]

Seems I was missing the licence file that needs to be copied with the .jar
Anyway if anybody has problems with that this topic:
http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0504vohra/index.html
Is the best I have found on the subject...

Now I got :

--- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
ObjectName: jboss.jca:name=PortalDS,service=DataSourceBinding
State: NOTYETINSTALLED
Depends On Me:
portal:service=CMS
portal:service=Hibernate,type=CMS
portal:service=Hibernate
portal:service=Hibernate,type=Instance
portal:service=Hibernate,type=PortalObject
portal:service=Hibernate,type=Portlet


But it looks more like a JBoss portal error so maybe it's not the right place to talk about it

[wrwttkl22]

Maybe you put the com.ibm.db2.jdbc.app.DB2Driver in wrong place.
You should put it in the path:$JBOSS_HOME/conf/$YOUR_CONFIG(default)/lib/