Verma, In what scenarios do you get this problem. Is it on inserts or selects or both?
Does it happen all the time? If so is there a way to reproduce the problem. Does JRun continue to work properly after the problem occurs? Have you tried it without connection pooling? I know you indicated previously that this didn't happen when you used JRun's pooling. The problem may very well have to do with the connection pooling classes that you are using. Ted Zimmerman -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 1:35 PM To: JRun-Talk Subject: RE: Connection reset by peer: socket write error Hi, I am using clobs and nested tables but I am also using oracle implementation of those. I am getting this error on prepared statement. -----Original Message----- From: Theodore Zimmerman [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 1:26 PM 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/jrun-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
