1 Reply Latest reply on Jul 21, 2004 12:33 PM by Adrian Brock

    DataStore to DB-2 Connect

    Jeff Brown Newbie

      I am trying to move from Websphere to JBoss. My application talks to DB-2 Connect Client which talks to OS/390 DB-2 Version 7. I set up the data source like this:


      <local-tx-datasource>
      <jndi-name>b2t4</jndi-name>
      <connection-url>jdbc:db2:b2t4</connection-url>
      <driver-class>COM.ibm.db2.jdbc.app.DB2Driver</driver-class>
      <user-name>w951ahn</user-name>
      ****
      <min-pool-size>0</min-pool-size>
      <!-- sql to call when connection is created
      <new-connection-sql>some arbitrary sql</new-connection-sql>
      -->

      <!-- sql to call on an existing pooled connection when it is obtained from pool
      <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
      -->

      </local-tx-datasource>




      I get the following error when I try to lookup the resource:

      WARN [Thread-10] [2004-07-20 14:07:52,531] interfaces.NamingContext - Failed to connect to iiop:1099
      javax.naming.CommunicationException: Failed to connect to server iiop:1099. Root exception is
      javax.naming.ServiceUnavailableException: Failed to connect to server iiop:1099. Root exception is
      java.net.UnknownHostException: iiop
      at java.net.InetAddress.getAllByName0(InetAddress.java:1024)
      at java.net.InetAddress.getAllByName0(InetAddress.java:990)
      at java.net.InetAddress.getAllByName(InetAddress.java:984)
      at java.net.InetAddress.getByName(InetAddress.java:904)
      at org.jnp.interfaces.TimedSocketFactory.createSocket(TimedSocketFactory.java:61)
      at org.jnp.interfaces.NamingContext.getServer(NamingContext.java:183)
      at org.jnp.interfaces.NamingContext.checkRef(NamingContext.java:1185)
      at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:516)
      at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:509)
      at javax.naming.InitialContext.lookup(InitialContext.java:360)
      at com.metavante.xaa.util.XaaDBConnect.connect(XaaDBConnect.java:115)
      at com.metavante.xaa.util.XaaDBConnect.hostCallRemote(XaaDBConnect.java:163)
      at com.metavante.xaa.components.dao.RemoteDao.getSystemMessageStatus(RemoteDao.java:580)
      at com.metavante.xaa.components.dao.AbstractDao.setPOPsContextData(AbstractDao.java:55)
      at com.metavante.xaa.control.threads.BankOptionsThreadRequest.reLoad(BankOptionsThreadRequest.java:71)
      at com.metavante.edelivery.core.control.threads.ThreadRequest.run(ThreadRequest.java:77)


      JBoss Server shows that the jndi name is bound to Java:/b2t4

      Any help would be great.

      Just on more thing. In Websphere, I use the driver class:COM.ibm.jdbc.DB2ConnectionPool.DataSource.