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??
|