• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Rao Nadella
Greenhorn
Posts: 16
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 8521
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Since the peer is very much operating system dependant, can you tell us what OS you are using???
 
Rao Nadella
Greenhorn
Posts: 16
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 37
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Please let me also know the solution
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic