5 Replies Latest reply on Apr 16, 2002 2:09 PM by Josh Sents

    JBOSS configuration for DB2

    Christian Stærmose Newbie

      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