Hibernate version: 2.1.2

Tomcat version: 4.1.29

C3P0 version: 0.8.3
Hibernate.properties:

hibernate.query.substitutions true 1, false 0, yes 'Y', no 'N'

hibernate.connection.url=jdbc:microsoft:sqlserver://ERE:1433;DatabaseName=ATC;SelectMethod=cursor
hibernate.connection.driver_class=com.microsoft.jdbc.sqlserver.SQLServerDriver
hibernate.dialect=net.sf.hibernate.dialect.SQLServerDialect
hibernate.connection.username=sa
hibernate.connection.password=

###########################
### C3P0 Connection Pool###
###########################

hibernate.c3p0.max_size 20
hibernate.c3p0.min_size 2
hibernate.c3p0.timeout 5000
hibernate.c3p0.max_statements 100
hibernate.c3p0.idle_test_period 3000
hibernate.c3p0.acquire_increment 2
hibernate.c3p0.validate false

hibernate.jdbc.batch_size 0

hibernate.jdbc.use_streams_for_binary true

hibernate.max_fetch_depth 1

hibernate.cache.use_query_cache true
hibernate.cache.provider_class net.sf.hibernate.cache.HashtableCacheProvider

Name and version of the database you are using: MSSQL Server 2000

Stack trace:

Created catalinaLoader in: C:\Tomcat4.1\server\lib
Feb 1, 2005 10:06:34 AM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on port 8080
Feb 1, 2005 10:06:52 AM org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config='org.apache.struts.util.LocalStrings', returnNull=true
Feb 1, 2005 10:06:52 AM org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config='org.apache.struts.action.ActionResources', returnNull=true
Feb 1, 2005 10:06:57 AM org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config='org.apache.webapp.admin.ApplicationResources', returnNull=true
Feb 1, 2005 10:08:30 AM org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on port 8080
Feb 1, 2005 10:08:30 AM org.apache.jk.common.ChannelSocket init
INFO: JK2: ajp13 listening on /0.0.0.0:8009
Feb 1, 2005 10:08:30 AM org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=78/109 config=C:\Tomcat4.1\conf\jk2.properties


**********************************************************


Exception during post-request cleanup.


Session id: 58FA04E691A4FB330757D30603910945
Client address: PARNO

Exceptions:

org.apache.catalina.connector.ClientAbortException


java.net.SocketException: Connection reset by peer: socket write error
java.net.SocketOutputStream.socketWrite0(Native Method)
java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
java.net.SocketOutputStream.write(SocketOutputStream.java:136)
org.apache.coyote.http11.InternalOutputBuffer.realWriteBytes(InternalOutputBuffer.java:731)
org.apache.tomcat.util.buf.ByteChunk.flushBuffer(ByteChunk.java:428)
org.apache.tomcat.util.buf.ByteChunk.append(ByteChunk.java:348)
org.apache.coyote.http11.InternalOutputBuffer$OutputStreamOutputBuffer.doWrite(InternalOutputBuffer.java:754)
org.apache.coyote.http11.filters.ChunkedOutputFilter.doWrite(ChunkedOutputFilter.java:168)
org.apache.coyote.http11.InternalOutputBuffer.doWrite(InternalOutputBuffer.java:586)
org.apache.coyote.Response.doWrite(Response.java:578)
org.apache.coyote.tomcat4.OutputBuffer.realWriteBytes(OutputBuffer.java:399)
org.apache.tomcat.util.buf.ByteChunk.flushBuffer(ByteChunk.java:428)
org.apache.coyote.tomcat4.OutputBuffer.doFlush(OutputBuffer.java:357)
org.apache.coyote.tomcat4.OutputBuffer.flush(OutputBuffer.java:336)
org.apache.coyote.tomcat4.CoyoteOutputStream.flush(CoyoteOutputStream.java:117)
org.apache.tapestry.request.ResponseOutputStream.forceFlush(ResponseOutputStream.java:190)
org.apache.tapestry.engine.AbstractEngine.service(AbstractEngine.java:968)
org.apache.tapestry.ApplicationServlet.doService(ApplicationServlet.java:238)
org.apache.tapestry.ApplicationServlet.doGet(ApplicationServlet.java:199)
javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:193)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:781)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:549)
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:589)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:666)
java.lang.Thread.run(Thread.java:534)

**********************************************************



**********************************************************

What's the problem actually? Is this hibernate problem or Tomcat problem or C3P0 problem??

It has been deployed for 4 months, and the problem occured recently, after some 10000s transaction rows.. anything wrong with my C3P0 setting??

*bump*

Had switched to new C3P0 and had set the properties as advised in this thread:

http://forum.hibernate.org/viewtopic.ph ... light=c3p0

c3p0.acquireRetryDelay=1000
c3p0.acquireRetryAttempts=60
c3p0.breakAfterAcquireFailure=false


still getting the same error.. can anyone help me please?

It is not related to DB or pool, probably you close browser before HTTP server flushes buffer and it fails to write response. So prabably it not a problem at all.

here's the catch..

I have so many users in the database..

this kinda shit happens only to those users who has LARGE transactional data (5-10 entries per day)

I myself as a user only have around 3 transactional data per day, and it almost never occured to me.

Is it because the lengthy processing time?

I'm using tapestry and hibernate, could it be tapestry's problem?

thanks