I have an ejb 1.1 application already deployed in jboss. We are creating another test server in which we have to deploy the same ear file. I just copied the ear file and oracle-ds.xml file from the current server to our test server. But, it keeps on giving this error continously: WARN [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Throwable while attempting to get a new connection: null org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Io exception: The Network Adapter could not establish the connection) 2007-01-25 13:07:13,093 ERROR [org.jboss.ejb.EntityContainer] Initialization failed jboss.j2ee:jndiName=Filing_class,service=EJB org.jboss.deployment.DeploymentException: Error while checking if table aleady exists Tester_Table; - nested throwable: (org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (java.sql.SQLException: Io exception: The Network Adapter could not establish the connection); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Io exception: The Network Adapter could not establish the connection))) at org.jboss.ejb.plugins.cmp.jdbc.SQLUtil.tableExists(SQLUtil.java:978) at org.jboss.ejb.plugins.jaws.jdbc.JDBCInitCommand.execute(JDBCInitCommand.java :107) at org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.create(JAWSPersistenceMana ger.java:131)
From this error, I thought that jboss was not able to make connection with the database, but then I wrote a sample jdbc program to connect to the same database and it was successful.
Maybe I am not following the correct procedure of making the ejb run on the test server. Is there something else or some more configurations that needs to be done to make it work? Any inputs to this would be highly appreciated. Thanks
I would suggest you to give proper permissions to the machiene(test server) from where you are accessing or making connection to oracle DB. Did you made JDBC call from test server ???
Here(on test server) code is unable to connect only to oracle DB...... Do check that out connection settings properly with proper username and password...
Cheers !!! Sumit Malik
If at first you don't succeed, don't try skydiving