DataStore to DB-2 Connect
jpbrown Jul 21, 2004 12:21 PMI 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.