Re: Database connection reset

Thread view:

timothy ma and constance lee - 02 Dec 2007 02:42 GMT

Dear sirs/madam

I am using conneciton pooling for the database connection. And I have
checked all database connection has been closed properly after use. However,
i still always encounter the error as below.

Please kindly help.

[11/29/07 0:46:32:946 GMT+08:00] 5eb994ab SRTServletReq E SRVE0120E: IO
Error java.net.SocketException: Connection reset
at java.net.SocketInputStream.read(SocketInputStream.java(Compiled
Code))
at com.ibm.ws.io.Stream.read(Stream.java(Compiled Code))
at com.ibm.ws.io.ReadStream.read(ReadStream.java(Compiled Code))
at
com.ibm.ws.http.ContentLengthInputStream.read(ContentLengthInputStream.java(Compiled
Code))
at com.ibm.ws.io.ReadStream.read(ReadStream.java(Compiled Code))
at
com.ibm.ws.webcontainer.http.HttpConnection.read(HttpConnection.java(Inlined
Compiled Code))
at
com.ibm.ws.webcontainer.srp.SRPConnection.read(SRPConnection.java(Compiled
Code))
at
com.ibm.ws.webcontainer.srt.SRTInputStream.read(SRTInputStream.java(Compiled
Code))
at
com.ibm.ws.webcontainer.srt.http.HttpInputStream.read(HttpInputStream.java(Compiled
Code))
at java.io.InputStream.read(InputStream.java(Inlined Compiled Code))
at
com.ibm.ws.webcontainer.srt.SRTServletRequest.finish(SRTServletRequest.java(Compiled
Code))
at
com.ibm.ws.webcontainer.srt.SRTConnectionContext.finishConnection(SRTConnectionContext.java(Compiled
Code))
at
com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java(Compiled
Code))
at
com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java(Compiled
Code))
at
com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java(Compiled
Code))
at
com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java(Compiled
Code))
at
com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java(Compiled
Code))
at
com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java(Compiled
Code))
at
com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java(Compiled
Code))
at
com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java(Compiled
Code))
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled
Code))
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled
Code))

Reply to this Message

Owen Jacobson - 02 Dec 2007 02:55 GMT

> Dear sirs/madam
>
[quoted text clipped - 3 lines]
>
> Please kindly help.

Looking at the stacktrace, I'm convinced this is unrelated to the
database connections entirely. There are lots of references to
ServletRequest and so on; I suspect the problem stems from the servlet
mishandling the request's input stream or from the browser closing the
request unexpectedly.

> [11/29/07 0:46:32:946 GMT+08:00] 5eb994ab SRTServletReq E SRVE0120E: IO
> Error java.net.SocketException: Connection reset
> at java.net.SocketInputStream.read(SocketInputStream.java(Compiled
> Code))

...

> com.ibm.ws.webcontainer.http.HttpConnection.read(HttpConnection.java(Inlined
> Compiled Code))

...

> com.ibm.ws.webcontainer.srt.http.HttpInputStream.read(HttpInputStream.java(Compiled

Code))

-O

Reply to this Message

Daniel Pitts - 02 Dec 2007 03:00 GMT

> Dear sirs/madam

It's good that you acknowledge both genders, but I think there might be
more than just Patricia who qualifies as a madam. Using plural might
have been a better choice :-).

I usually don't address my posts to any particular person/people, as it
really is address to the group.

Anyway, not really that important, just feeling pedantic I guess.

Signature

Daniel Pitts' Tech Blog: <http://virtualinfinity.net/wordpress/>

Reply to this Message

Re: Database connection reset

Free Magazines