Yes, we are going to. And I found the problem. The weblogic server will set the following value when it starts even I didn't config it: 12:48:34 PDT 2000:<I> <Config> Property name: 'weblogic.httpd.session.jdbc.connTimeoutSecs', current value: '120' So connection is gone per 120sec. Thanks. --- "Tom K." <[EMAIL PROTECTED]> wrote: > Then use the connection pool. That's what its there > for. > > -----Original Message----- > From: A mailing list for discussion about Sun > Microsystem's Java Servlet > API Technology. > [mailto:[EMAIL PROTECTED]]On Behalf Of > Jen > Sent: Tuesday, August 22, 2000 11:56 AM > To: [EMAIL PROTECTED] > Subject: Re: java.sql.SQLException: Io exception: > Connection reset by > peer > > > I am not using connection pool. I obtain the > connection in init() method like: > try{ > dCon = DriverManager.getConnection(DB_URL, > DB_MFPUSER_ID, DB_MFP_PASSWD); > } > So I am asuming the connection should be there as > long > as the servlet is not destroyed. > Thanks. > > --- "Tom K." <[EMAIL PROTECTED]> wrote: > > Are you using a connection pool (the one built > into > > weblogic)? > > Are you closing your connections? i.e. > > > > > > > > if (dataResultSet > != > > null) > > > > dataResultSet.close(); > > } > > catch (SQLException e1) { > > > > System.out.println("Error code: " + e1 + ""); > > rc = false; > > } > > finally > > { > > //do anything that > > must be executed here > > } > > > > > > > > -----Original Message----- > > From: A mailing list for discussion about Sun > > Microsystem's Java Servlet > > API Technology. > > [mailto:[EMAIL PROTECTED]]On Behalf Of > > Jen > > Sent: Tuesday, August 22, 2000 10:41 AM > > To: [EMAIL PROTECTED] > > Subject: java.sql.SQLException: Io exception: > > Connection reset by peer > > > > > > I have a servlet that I get database connection in > > the > > init(). It runs OK for 2 - 3 hours. After that I > got > > the error: > > java.sql.SQLException: Io exception: Connection > > reset > > by peer > > > > if we reload the same servlet, it works again. > > > > I am using weblogic server, oracle database. > > > > Any ideas will be appreciated. > > > > > > __________________________________________________ > > Do You Yahoo!? > > Yahoo! Mail Free email you can access from > > anywhere! > > http://mail.yahoo.com/ > > > > > ___________________________________________________________________________ > > To unsubscribe, send email to > [EMAIL PROTECTED] > > and include in the body > > of the message "signoff SERVLET-INTEREST". > > > > Archives: > > > http://archives.java.sun.com/archives/servlet-interest.html > > Resources: > > > http://java.sun.com/products/servlet/external-resources.html > > LISTSERV Help: > > http://www.lsoft.com/manuals/user/user.html > > > > > ___________________________________________________________________________ > > To unsubscribe, send email to > [EMAIL PROTECTED] > > and include in the body > > of the message "signoff SERVLET-INTEREST". > > > > Archives: > > > http://archives.java.sun.com/archives/servlet-interest.html > > Resources: > > > http://java.sun.com/products/servlet/external-resources.html > > LISTSERV Help: > http://www.lsoft.com/manuals/user/user.html > > > __________________________________________________ > Do You Yahoo!? > Yahoo! Mail Free email you can access from > anywhere! > http://mail.yahoo.com/ > > ___________________________________________________________________________ > To unsubscribe, send email to [EMAIL PROTECTED] > and include in the body > of the message "signoff SERVLET-INTEREST". > > Archives: > http://archives.java.sun.com/archives/servlet-interest.html > Resources: > http://java.sun.com/products/servlet/external-resources.html > LISTSERV Help: > http://www.lsoft.com/manuals/user/user.html > > ___________________________________________________________________________ > To unsubscribe, send email to [EMAIL PROTECTED] > and include in the body > of the message "signoff SERVLET-INTEREST". > > Archives: > http://archives.java.sun.com/archives/servlet-interest.html > Resources: > http://java.sun.com/products/servlet/external-resources.html > LISTSERV Help: http://www.lsoft.com/manuals/user/user.html __________________________________________________ Do You Yahoo!? Yahoo! Mail � Free email you can access from anywhere! http://mail.yahoo.com/ ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
