Problem with DB2 and jboss.jcml

[georges]

Hello!

I have installed a working environment on windowsXP wich works well, but if I try to use this Installation I get always an SQL-Error. Whats wrong??

My config is like this:


COM.ibm.db2.jdbc.app.DB2Driver


DB2
org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
jdbc:db2:xifsadb2
administrator
password


I get this error:

[J2EE Deployer Default] Starting customer.jar failed!
[Default] java.lang.UnsatisfiedLinkError: SQLAllocStmt
[Default] at COM.ibm.db2.jdbc.app.DB2Statement.SQLAllocStmt(Native Method)
[Default]
[Default] at COM.ibm.db2.jdbc.app.DB2Statement.(DB2Statement.java:291)
[Default]
[Default] at COM.ibm.db2.jdbc.app.DB2Statement.(DB2Statement.java:307)
[Default]
[Default] at COM.ibm.db2.jdbc.app.DB2Statement.(DB2Statement.java:314)
[Default]
[Default] at COM.ibm.db2.jdbc.app.DB2Connection.createStatement(DB2Connection.java:488)
[Default]
[Default] at COM.ibm.db2.jdbc.app.DB2DatabaseMetaData.getTables(DB2DatabaseMetaData.java:1557)
[Default]
[Default] at org.jboss.ejb.plugins.jaws.jdbc.JDBCInitCommand.execute(JDBCInitCommand.java:102)
[Default]
[Default] at org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.init(JAWSPersistenceManager.java:103
[Default]
[Default] at org.jboss.ejb.plugins.CMPPersistenceManager.init(CMPPersistenceManager.java:110)
[Default]
[Default] at org.jboss.ejb.EntityContainer.init(EntityContainer.java:291)
[Default]
[Default] at org.jboss.ejb.Application.init(Application.java:202)
[Default]
[Default] at org.jboss.ejb.ContainerFactory.deploy(ContainerFactory.java:372)
[Default]
[Default] at org.jboss.ejb.ContainerFactory.deploy(ContainerFactory.java:304)
[Default]
[Default] at java.lang.reflect.Method.invoke(Native Method)
[Default]
[Default] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[Default]
[Default] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[Default]
[Default] at org.jboss.deployment.J2eeDeployer.startModules(J2eeDeployer.java:494)
[Default]
[Default] at org.jboss.deployment.J2eeDeployer.startApplication(J2eeDeployer.java:468)
[Default]
[Default] at org.jboss.deployment.J2eeDeployer.deploy(J2eeDeployer.java:208)
[Default]
[Default] at java.lang.reflect.Method.invoke(Native Method)
[Default]
[Default] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[Default]
[Default] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[Default]
[Default] at org.jboss.ejb.AutoDeployer.deploy(AutoDeployer.java:379)
[Default]
[Default] at org.jboss.ejb.AutoDeployer.run(AutoDeployer.java:217)
[Default]
[Default] at java.lang.Thread.run(Unknown Source)

But this works on WindowsXP!!!
Any suggestions.

Sincerly
Dan

[georges]

Sorry, I forget to say that I want to port this Installation to another pc on wich win2000 is running.

Dan

[ilyanov]

Make sure that you are using the right JDBC version, you should run useJDBC2 <your db2 installation folder>/java directory (make sure all db2 processes are stopped before doig it). JTA support is supported in JDBC 2.0

Also make sure that <your db2 intallation folder>/bin is in your path so that th JNI library can be loaded. Optionally you could use the net driver but I dont think they support JTA.

[georges]

Thank you very much!
Now all works fine.

Bye
Dan