File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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 REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Connection not available" Watch "Connection not available" New topic

Connection not available

Lalit mishra
Ranch Hand

Joined: Sep 01, 2005
Posts: 100
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(
at oracle.jdbc.dbaccess.DBError.throwSqlException(
at oracle.jdbc.dbaccess.DBError.throwSqlException(
at oracle.jdbc.ttc7.TTC7Protocol.handleIOException(
at oracle.jdbc.ttc7.TTC7Protocol.logon(
at oracle.jdbc.driver.OracleConnection.<init>(
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(
at oracle.jdbc.driver.OracleDriver.connect(
at java.sql.DriverManager.getConnection(
at java.sql.DriverManager.getConnection(
at com.iflex.fcat.infra.JFGlobalFunctions.getConnection(
at com.iflex.fcat.infra.JFGlobalFunctions.getConnection(
at com.iflex.fcat.infra.JFGlobalMessages.loadMessages(
at com.iflex.fcat.infra.JFProperties.loadPropertiesFromDB(
at com.iflex.fcat.infra.JFProperties.loadProperties(
at com.iflex.fcat.apps.DexiReconcilation.initializeClass(

Thanks in advance
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.
jQuery in Action, 3rd edition
subject: Connection not available
jQuery in Action, 3rd edition