problem in connectivity through datasource to oracle database

[Saptarshi Chakraborty]

Hi folks,

I am having a trouble in connecting my application through datasource to oracle database.I can see that the datasource object has been created properly
but I am getting an exception while creating the connection object.The stack is coming like this..........


org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153092352)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4)))))
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:161)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:508)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:207)
at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:534)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:395)
at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:297)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:447)
at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:874)

can any one here come up with a solution to this or at least mention what could cause the problem.

[Santhosh Kumar Nunna]

Hai,

Can you check for whether, connection pool is properly created or not.

[Saptarshi Chakraborty]

yaah
i tried to print the connection object into the log ,but it is showing the exeption while creating
the code is like this
Connection con = null;
try
{
con = ds.getConnection();
}
catch(Exception e)
{
}
(ds is the datasource object which has been created)