• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC thin /Oracle - Connection refused

 
Abraham Jacob
Greenhorn
Posts: 25
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,
I am using JDBC thin driver (classes12.zip) to connect to an Oracle database. The driver registers but during while trying to get the connection I get the following error ---
Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153092352)(ERR=12500)(ERROR_STACK=(
ERROR=(CODE=12500)(EMFI=4))(ERROR=(CODE=12540)(EMFI=4))(ERROR=(CODE=12560)(EMFI=4))(ERROR=(COD
E=510)(EMFI=4))(ERROR=(BUF='HPUX Error: 11: Resource temporarily unavailable')))): java.sql.SQ
LException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153092352)(ERR=12500)(E
RROR_STACK=(ERROR=(CODE=12500)(EMFI=4))(ERROR=(CODE=12540)(EMFI=4))(ERROR=(CODE=12560)(EMFI=4)
)(ERROR=(CODE=510)(EMFI=4))(ERROR=(BUF='HPUX Error: 11: Resource temporarily unavailable'))))
DCan anyone help decode this / or know what the problem is....
Regards,
Abraham
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
1. make sure that the database is up and running properly
2. make sure that you can access the database from a SQL*Plus session
3. Connect to the database using java ( use the same information as #2 for logging in ).
If you still have problems, post the connection code snippet so we can see if you have a correct URL.
Jamie
 
Premkumar N
Greenhorn
Posts: 22
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This error appeared for me when the database exceeds the min-num of connections.
May be you are making new connections and not releasing/closing it properly.. or you are trying to open&close&open ... in immediate succession..
in such cases .... Oracle has some "latency" in destroying the connections [it is marked inactive].. though Java releases the connection ...
Hope you are using connection-pooling ...
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic