Dear Zimmerman, The problem does not occur always. It happens once in a while. I have seen this problem 2-3 times but I am unable to figure out it's basic nature. When I get a conneciotn from the pool and try to call a prepared statement on that then it problem occurs, but not always. I got this error this morning when I tried to login in the system, which further get login info from the database. There is a possibility that our network was down for few minutes but it was back soon. May that causes that error. I am attaching my connectio pooling classes. Check out if you can find anything wrong.
Thanks -----Original Message----- From: Theodore Zimmerman [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 4:33 PM To: JRun-Talk Subject: RE: Connection reset by peer: socket write error 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
