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
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
Joined: Apr 21, 2001
Posts: 22
posted
0
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 ...