wood burning stoves 2.0*
The moose likes JDBC and the fly likes JDBC thin /Oracle - Connection refused Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC thin /Oracle - Connection refused" Watch "JDBC thin /Oracle - Connection refused" New topic
Author

JDBC thin /Oracle - Connection refused

Abraham Jacob
Greenhorn

Joined: Oct 16, 2001
Posts: 25
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

Joined: Jul 09, 2001
Posts: 1879

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
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 ...


<a href="mailto:pondyprem@yahoo.com" rel="nofollow">pondyprem@yahoo.com</a> <br />Sr.Programmer Analyst ( Bioinformatics)<br />Monsanto Entrprises
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC thin /Oracle - Connection refused