aspose file tools*
The moose likes JDBC and the fly likes Connection not available Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Connection not available" Watch "Connection not available" New topic
Author

Connection not available

Lalit mishra
Ranch Hand

Joined: Sep 01, 2005
Posts: 99
Hi,
I am facing following problem
Sometimes i am able to get database connection (Oracle database) and
my application works fine.But next time i run the same application i get following exception.
java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153093120)(ERR=12519)(ERROR_STACK=(ERROR=(CODE=12519)(EMFI=4))))
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334)
at oracle.jdbc.ttc7.TTC7Protocol.handleIOException(TTC7Protocol.java:3695)
at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:352)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:362)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:536)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:328)
at java.sql.DriverManager.getConnection(DriverManager.java:559)
at java.sql.DriverManager.getConnection(DriverManager.java:211)
at com.iflex.fcat.infra.JFGlobalFunctions.getConnection(JFGlobalFunctions.java:2014)
at com.iflex.fcat.infra.JFGlobalFunctions.getConnection(JFGlobalFunctions.java:1933)
at com.iflex.fcat.infra.JFGlobalMessages.loadMessages(JFGlobalMessages.java:193)
at com.iflex.fcat.infra.JFProperties.loadPropertiesFromDB(JFProperties.java:341)
at com.iflex.fcat.infra.JFProperties.loadProperties(JFProperties.java:311)
at com.iflex.fcat.apps.DexiReconcilation.initializeClass(DexiReconcilation.java:529)
at com.iflex.fcat.apps.DexiReconcilation.run(DexiReconcilation.java:662)
at java.lang.Thread.run(Thread.java:570)

Thanks in advance
Lalit.
Malith Yapa
Ranch Hand

Joined: Jan 17, 2007
Posts: 45
It is quite hard to say with the information you've provided.. Please post how you exactly tried to get the connection..

However if this error occured in a webapp.. It may be because the server is clustered.. That way only the instance that created the database can use it.. Requests sent through the other instance would not be processed.. Well i thought so because that's one way that it could work only sometimes.. Please make your posts in more detail..

The exception is not familiar to me.. I haven't used oracle anyways.
 
Consider Paul's rocket mass heater.
 
subject: Connection not available