• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • Ron McLeod
  • paul wheaton
  • Jeanne Boyarsky
Sheriffs:
  • Paul Clapham
  • Devaka Cooray
Saloon Keepers:
  • Tim Holloway
  • Roland Mueller
  • Himai Minh
Bartenders:

Connection not available

 
Ranch Hand
Posts: 100
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
Ranch Hand
Posts: 45
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
reply
    Bookmark Topic Watch Topic
  • New Topic