JBOSS configuration for DB2

[cst_it-i]

Hi, I am new to jboss, so please bear with me if this is trivial. I have however read through the forum ect. without finding an answar. So please help ... !

I'am running JBoss-2.4.4_Tomcat-4.0.1 on Linux 2.4.7-10,x86. The VM installed is IBM 1.3.0. On the same box i have the IBM DB2 7.2 workgroup ed. running.

When starting jboos, I get:
...
[INFO,JdbcProvider] Initializing
[INFO,JdbcProvider] Loaded JDBC-driver:COM.ibm.db2.jdbc.app.DB2Driver
[INFO,JdbcProvider] Initialized
...
[INFO,JdbcProvider] Starting
[INFO,JdbcProvider] Started
[INFO,TESTDATA] Starting
[INFO,TESTDATA] XA Connection pool TESTDATA bound to java:/TESTDATA
And here the server hangs.

In my effort to get jboss to talk with the DB2 I have made the following changes to the default configuration:

>>>jboss.jcml<<<
<!-- ==================================================================== -->
<!-- JDBC -->
<!-- ==================================================================== -->


COM.ibm.db2.jdbc.app.DB2Driver



TESTDATA
org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl

jdbc:db2:TESTDATA
1200000
db2inst1
10
password
false
false
false
true
120000
1800000
false
false
1.0
0


I deleted the:
<mbean code="org.jboss.jdbc.HypersonicDatabase" ...
section.

>>>standardjaws.xml<<<
java:/TESTDATA
<type-mapping>DB2</type-mapping>

I copied the db2java.zip file to jbosshome/lib/ext

I would very much appreciate any comment on this topic

Thanks

Christian

[lepe]

Have you tried something like JDBCTEST to see if you really can contact your db2 server from the machine where you are running JBoss?

This is from our jboss.jcml and works with DB2.



org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl

jdbc/ECS

jdbc:db2://xxx.xxx.xxx.xx:xxxx/pn2

ENTER_USER

ENTER_PWD



/Lennart

[cst_it-i]

Thank you,
we are working on that. I would love to see your jboss.jcml and standardjaws.xml to see your whole db2 setup. Currently we have problems configuring the CLI enviroment, just can't bind with the database.

Do you run jboss and db2 on the same box? if so, is there any special setup needed?

Any clues would be very helpfull.

Kind regards
Christian

[lepe]

No changes in standardjaws.xml.

Has been using JBoss and DB2 both on same box as on different boxes.

jboss.jcml follows.

[jsents]

For us to get DB2 running we also added some classpath varibles to the jboss.conf file. I have attached a copy of it. It also contians settings for Oracle and Sql Anywhere but you should be able to just take the DB2 section.

[jsents]

Here is the file, first time posting a attached file.