aspose file tools*
The moose likes JDBC and the fly likes problem in connectivity through datasource to oracle database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "problem in connectivity through datasource to oracle database" Watch "problem in connectivity through datasource to oracle database" New topic
Author

problem in connectivity through datasource to oracle database

Saptarshi Chakraborty
Greenhorn

Joined: Jul 26, 2007
Posts: 23
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
Greenhorn

Joined: Feb 11, 2008
Posts: 7
Hai,

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

Joined: Jul 26, 2007
Posts: 23
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)
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: problem in connectivity through datasource to oracle database