0 Replies Latest reply on Dec 18, 2007 11:30 AM by Santosh Bhojraj

    DB2: Communication link failure

    Santosh Bhojraj Newbie

      Hi:
      I am getting the following error when trying to run a query against a DB2 table. Below is the system configuration:
      JBoss 4.0.3.SP1
      OS: Linux
      Db2: version 8.0

      Error message: CLI0108E Communication link failure. QLSTATE=40003

      If JBoss is restarted when this message occurs, this doesn't happen anymore. The data source configuration is below:

      <jndi-name>iraTxDataSource</jndi-name>
      <connection-url>jdbc:db2:db2ntcp</connection-url>
      <driver-class>COM.ibm.db2.jdbc.app.DB2Driver</driver-class>
      <user-name>test</user-name>
      test
      <min-pool-size>5</min-pool-size>
      <max-pool-size>70</max-pool-size>
      <track-statements>true</track-statements>
      <idle-timeout-minutes>4</idle-timeout-minutes>


      <type-mapping>DB2</type-mapping>

      </local-tx-datasource>


      Thanx!!!!
      santosh.bhojraj@bankofamerica.com