It's not a secret anymore!
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
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.
I agree. Here's the link:
subject: Connection not available
It's not a secret anymore!