Hi Dilip, Are you using Oracle 8.1.6 Version? Try to run the same SQL from SQLPLUS. If that also fails problem is not with JAVA .Problem is with Oracle. I have encountered this problem while I was running a complicated SQL having a few inner Queries and Distinct clauses. Funny thing was once I removed some Distinct clause the SQL worked. The problem is still a misery.We moved to Oracle 8.1.7 then everything went fine.
Rgds Savant -----Original Message----- From: Theodore Zimmerman [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 2:26 AM To: JRun-Talk Subject: RE: Connection reset by peer: socket write error Are you using a datatypes like blobs or clobs? I've been doing some testing lately with those datatypes and unless you used Oracle's implementation would get that same error. Ted Zimmerman -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 11:51 AM To: JRun-Talk Subject: RE: Connection reset by peer: socket write error Ya, I am using Oracle's thin driver. -----Original Message----- From: Ben Groeneveld [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 11:34 AM To: JRun-Talk Subject: Re: Connection reset by peer: socket write error What's JRun's Oracle driver? Have you tried using oracle's free thin driver? We use oracle JDBC driver-8.1.6.2.0 on a large variety of projects and operations w/o a hiccup. Maybe trying it will help you. BenG. [EMAIL PROTECTED] wrote: >Hi, >I am getting the following error while accessing the database. >I have JRun 3.1.15506 app server running on win2000 and NT both, and using >oracle database. Instead of using JRun's connection pool for oracle I am >using my own connection pool. The system works fine most of the times but >all of a sudden it starts giving "Connection reset by peer". I didn't have >this problem when I was using JRun's Oracle thin driver connection pool >before. But for migrating reasons I started using my own connection pool. >Sometimes when I query the database using preparedStatement, it throws the >below exception. I am seeing the same exception both on NT and win2000. >Please tell what might the reason behind. >Thanks >_________________________________________ >_________________________________________ > >Thu Mar 28 10:13:31 EST 2002 >Io exception: Connection reset by peer: socket write error >java.sql.SQLException: Io exception: Connection reset by peer: socket write >error > at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114) > at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156) > at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269) > at >oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:292) > at >oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:307) > at >oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.j a >va:194) > at >oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.j a >va:177) > at >oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java: 3 >39) > at >com.emc.asi.ejb.pool.ASIConnection.prepareStatement(ASIConnection.java:61) > at com.emc.asi.ejb.LoginBean.processLogin(LoginBean.java:48) > at java.lang.reflect.Method.invoke(Native Method) > at >allaire.ejipt._BeanMethod._invoke(allaire/ejipt/_BeanMethod.java:166) > at >allaire.ejipt._SessionObject._invoke(allaire/ejipt/_SessionObject.java:182) > at >allaire.ejipt._CallableObject.call(allaire/ejipt/_CallableObject.java:101) > at java.lang.reflect.Method.invoke(Native Method) > at >sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241) > at sun.rmi.transport.Transport$1.run(Transport.java:152) > at java.security.AccessController.doPrivileged(Native Method) > at sun.rmi.transport.Transport.serviceCall(Transport.java:148) > at >sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:465) > at >sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java: 7 >06) > at java.lang.Thread.run(Thread.java:484) > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
