Connecting to a remote database

["OSullivan, Patrick" <OSullivanP@xxxxxxxxxxx>]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
When we tried to use a local database for websphere Entity bean on AS400
...it worked perfectly ....
but we could n't connect to remote database from same application server
.....got following Exception

com.ibm.ejs.cm.pool.ConnectionWaitTimeoutException: Timeout waiting for free
connection
      java/lang/Throwable.<init>(Ljava/lang/String;)V+4 (Throwable.java:94)
      java/sql/SQLException.<init>(Ljava/lang/String;)V+1
(SQLException.java:82)

com/ibm/ejs/cm/pool/ConnectionPool.waitForVictimConnection()Lcom/ibm/ejs/cm/
pool/ConnectO;+502 (ConnectionPool.java:960)

com/ibm/ejs/cm/pool/ConnectionPool.createOrWaitForConnection(Ljava/lang/Stri
ng;Ljava/lang/String;)Lcom/ibm/ejs/cm/pool/ConnectO;+56
(ConnectionPool.java:706)

com/ibm/ejs/cm/pool/ConnectionPool.findFreeConnection(Ljava/lang/String;Ljav
a/lang/String;)Lcom/ibm/ejs/cm/pool/ConnectO;+109 (ConnectionPool.java:669)

com/ibm/ejs/cm/pool/ConnectionPool.findConnectionForTx(Lorg/omg/CosTransacti
ons/Coordinator;Ljava/lang/String;Ljava/lang/String;Ljava/util/Properties;)L
com/ibm/ejs/cm/pool/ConnectO;+143 (ConnectionPool.java:582)

com/ibm/ejs/cm/pool/ConnectionPool.allocateConnection(Ljava/lang/String;Ljav
a/lang/String;Ljava/util/Properties;)Lcom/ibm/ejs/cm/pool/ConnectO;+99
(ConnectionPool.java:507)

com/ibm/ejs/cm/pool/ConnectionPool.getConnection(Ljava/lang/String;Ljava/lan
g/String;)Ljava/sql/Connection;+1 (ConnectionPool.java:220)

com/ibm/ejs/cm/DataSourceImpl.getConnection(Ljava/lang/String;Ljava/lang/Str
ing;)Ljava/sql/Connection;+13 (DataSourceImpl.java:113)

com/ibm/ejs/persistence/EJSJDBCPersister.initialize(Ljavax/sql/DataSource;Lj
ava/lang/String;Ljava/lang/String;Ljava/lang/String;)V+30
(EJSJDBCPersister.java:418)

com/ibm/ejs/persistence/EJSJDBCPersister.create(Lcom/ibm/ejs/util/PortableDe
ploymentDescriptor;Ljavax/sql/DataSource;Ljava/lang/ClassLoader;)Lcom/ibm/ej
s/persistence/EJSJDBCPersister;+86 (EJSJDBCPersister.java:340)

com/ibm/ejs/sm/active/ActiveEJBContainer.create(Lcom/ibm/websphere/csi/EJBCo
nfigData;)Lcom/ibm/websphere/csi/EJBPersister;+131
(ActiveEJBContainer.java:957)

com/ibm/ejs/container/EJSContainer.loadBeanMetaData(Ljava/lang/String;)Ljava
/rmi/Remote;+44 (EJSContainer.java:1079)

com/ibm/ejs/container/EJSContainer.getHomeInstance(Ljava/lang/String;)Ljava/
rmi/Remote;+20 (EJSContainer.java:1020)

com/ibm/ejs/sm/active/ActiveEJBContainer.startBean(Ljava/lang/String;Lcom/ib
m/ejs/util/PortableDeploymentDescriptor;Ljava/lang/String;ZLjava/lang/String
;Lcom/ibm/ejs/sm/active/ActiveEnterpriseBean;Ljava/lang/String;)Ljava/rmi/Re
mote;+443 (ActiveEJBContainer.java:563)

com/ibm/ejs/sm/active/ActiveEnterpriseBean.startAction(ZLcom/ibm/ejs/sm/util
/ObjectCollection;)V+62 (ActiveEnterpriseBean.java:55)
      com/ibm/ejs/sm/active/ActiveObject.startObject(JZ)V+23
(ActiveObject.java:682)

com/ibm/ejs/sm/active/ActiveObject.start(ILcom/ibm/ejs/sm/active/ActiveObjec
tConfig;)V+269 (ActiveObject.java:117)

com/ibm/ejs/sm/active/ActiveObject.operateOnContainedObjects(Lcom/ibm/ejs/sm
/active/ActiveObjectConfig;Ljava/lang/String;Lcom/ibm/ejs/sm/util/ObjectColl
ection;)V+210 (ActiveObject.java:585)

com/ibm/ejs/sm/active/ActiveEJBContainer.startAction(ZLcom/ibm/ejs/sm/util/O
bjectCollection;)V+661 (ActiveEJBContainer.java:380)


Any ideas???

Thanks,
P O'Sullivan
ICI/ADP