Hi, In my EJB client program I have looked up for a Datasource. But the getConnection( ) method is failing. The Datasource name, user and password are absolutely fine..Please comment on the possible causes of failure. I'm using WebSphere 3.5 as my application server. The transcript of the error is as follows ---------- java ---------- INITIAL_CONTEXT_FACTORY : com.ibm.ejs.ns.jndi.CNInitialContextFactory Context.PROVIDER_URL : iiop://localhost:900 DataSource Object : com.ibm.ejs.cm.JTADataSource@20921c2d [RFDB] java.sql.SQLException: Io exception: The Network Adapter could not establish the connection at java.sql.SQLException.<init>(SQLException.java:45) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java) at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java) at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java) at java.sql.DriverManager.getConnection(DriverManager.java:459) at java.sql.DriverManager.getConnection(DriverManager.java:139) at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java) at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPhysicalConnection(Oracle ConnectionPoolDataSource.java) at oracle.jdbc.xa.client.OracleXADataSource.getXAConnection(OracleXADataSource. java) at com.ibm.ejs.cm.portability.JTAXADataSource.getXAConnection(JTAXADataSource.j ava:59) at com.ibm.ejs.cm.pool.JTAConnectionFactory.createConnection(JTAConnectionFacto ry.java:28) at com.ibm.ejs.cm.pool.ConnectionPool.createConnection(ConnectionPool.java:713) at com.ibm.ejs.cm.pool.ConnectionPool.createOrWaitForConnection(ConnectionPool. java:666) at com.ibm.ejs.cm.pool.ConnectionPool.findFreeConnection(ConnectionPool.java:59 7) at com.ibm.ejs.cm.pool.ConnectionPool.findConnectionForTx(ConnectionPool.java:5 26) at com.ibm.ejs.cm.pool.ConnectionPool.allocateConnection(ConnectionPool.java:46 9) at com.ibm.ejs.cm.pool.ConnectionPool.getConnection(ConnectionPool.java:204) at com.ibm.ejs.cm.DataSourceImpl.getConnection(DataSourceImpl.java:113) at DBTest.main(DBTest.java:41) Normal Termination Output completed (29 sec consumed). =========================================================================== To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff EJB-INTEREST". For general help, send email to [EMAIL PROTECTED] and include in the body of the message "help".
