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
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
Joined: Jan 19, 2001
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.