aspose file tools*
The moose likes JDBC and the fly likes connection to database - reset by peer - SQL Exception -???!!! Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "connection to database - reset by peer - SQL Exception -???!!!" Watch "connection to database - reset by peer - SQL Exception -???!!!" New topic
Author

connection to database - reset by peer - SQL Exception -???!!!

Rao Nadella
Greenhorn

Joined: Jan 19, 2001
Posts: 16
Hi,
I have set up connection to my Oracle dB through thin drivers. Tested connection with database on one host, it works fine, I could retrieve data and display.
When I try to connect to a different database, with proper connection settings, I get an error as follows:
java.sql.SQLException: Connection reset by peer
If you have come across this problem before and can help, please reply to this post.
Your help is very much appreciated.
Thank you,
-Rao
Cindy Glass
"The Hood"
Sheriff

Joined: Sep 29, 2000
Posts: 8521
Since the peer is very much operating system dependant, can you tell us what OS you are using???


"JavaRanch, where the deer and the Certified play" - David O'Meara
Rao Nadella
Greenhorn

Joined: Jan 19, 2001
Posts: 16
I am on an NT 4.0 machine trying to connect to a
Oracle database which is on an IBM VM 3090 - ESA 2.3.
- ORACLE version is 7.3

I am able to connect to the database thro' SQL plus
windows and also another software called 'Benthic'
- which is GUI for the Oracle data display.
The tnsnames.ora file is same for both of them and
works fine from SQL Plus and Benthic tool.
I have tried to connect to my personal Oracle
database on my machine, and another machine,
it works fine. Only the one on IBM machine I am unable to
connect to.
When I try through my java code I get the following msg:
=============================================================
java.sql.SQLException: Connection reset by peer
java.lang.Throwable(java.lang.String)
java.lang.Exception(java.lang.String)
java.sql.SQLException(java.lang.String, java.lang.String, int)
int
oracle.jdbc.dbaccess.DBError.check_error(java.io.IOException)

oracle.jdbc.driver.OracleConnection(oracle.jdbc.dbaccess.DBAccess,
java.lang.String, java.lang.String,
java.lang.String, java.lang.String,
java.util.Properties)
java.sql.Connection
oracle.jdbc.driver.OracleDriver.getConnectionInstance(oracle.jdbc.dbaccess.D
BAccess, java.lang.String, java.lang.String,
java.lang.String,
java.lang.String, java.util.Properties)
java.sql.Connection
oracle.jdbc.driver.OracleDriver.connect(java.lang.String,
java.util.Properties)
java.sql.Connection
java.sql.DriverManager.getConnection(java.lang.String,
java.util.Properties)
java.sql.Connection
java.sql.DriverManager.getConnection(java.lang.String,
java.lang.String,
java.lang.String)
void javaservlets.db.SimpleQuery.performOraQuery()
void
javaservlets.db.SimpleQuery.main(java.lang.String
[])
=================================================================
Thank you very much for your help.
sandhya menon
Ranch Hand

Joined: May 22, 2001
Posts: 37
Please let me also know the solution
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: connection to database - reset by peer - SQL Exception -???!!!