File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
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
 
Similar Threads
Could not create connection !!!!
Problem oin connecting Oracle database in JBOSS AS 4.2.3
Oracle driver expeption
JBoss Classpath
Oracle XA Exception