Thread: [c3p0-users] java.sql.SQLException: System or internal error java.net.SocketException: Software cau
Status: Beta
Brought to you by:
swaldman
From: smcardle <smc...@sp...> - 2008-02-07 11:17:40
|
Hi, I have configured c3p0 to work as a pool for Informix 10 connections. This all works OK until the DB is taken down for maintenance at night. After the DB is available again all my connections are dead and I cannot access the DB without restarting my server. I am using Spring to configure a data source and have set options for c3p0 to check the connections. Here is my Spring configuration <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd"> <beans> <bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"> <property name="location"> <value>classpath:conf/ctmd/ctmd.properties</value> </property> </bean> <bean id="informixDataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close"> <property name="driverClass" value="${standalone.dataSource.driverClassName}"/> <property name="jdbcUrl" value="${standalone.dataSource.url}"/> <property name="user" value="${standalone.dataSource.username}"/> <property name="password" value="${standalone.dataSource.password}"/> <property name="minPoolSize" value="10"/> <property name="acquireIncrement" value="5"/> <property name="maxPoolSize" value="50"/> <property name="maxStatementsPerConnection" value="12"/> <property name="testConnectionsOnCheckin" value="true"/> <property name="preferredTestQuery" value="SELECT COUNT(*) FROM wls_heartbeat"/> <property name="idleConnectionTestPeriod" value="10"/> </bean> </beans> And here is the stack trace when accessing the next day ####<Feb 7, 2008 11:45:29 AM CET> <Error> <ServletContext-/trademark> <oasv399> <devctm_s01> <[ACTIVE] ExecuteThread: '17' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <> <1202381129888> <000000> <ctmd: System or internal error java.net.SocketException: Software caused connection abort: socket write error java.sql.SQLException: System or internal error java.net.SocketException: Software caused connection abort: socket write error at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:448) at com.informix.jdbc.IfxSqli.flip(IfxSqli.java:2491) at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2262) at com.informix.jdbc.IfxSqli.executeClose(IfxSqli.java:1851) at com.informix.jdbc.IfxResultSet.close(IfxResultSet.java:1589) at com.informix.jdbc.IfxPreparedStatement.executeQuery(IfxPreparedStatement.java:365) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76) at eu.ohim.ctmd.persistence.MarkDAO.findByPK(MarkDAO.java:34) at eu.ohim.ctmd.business.CtmdService.getTradeMarkVo(CtmdService.java:79) at eu.ohim.ctmd.business.CtmdService.getSingleMarkXml(CtmdService.java:54) at eu.ohim.ctmd.ui.CtmdController.getMark(CtmdController.java:94) at eu.ohim.ctmd.ui.CtmdController.service(CtmdController.java:58) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:225) at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:127) at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:283) at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:175) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3214) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121) at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:1983) at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:1890) at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1344) at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209) at weblogic.work.ExecuteThread.run(ExecuteThread.java:181) > I thought maybe even if I cycled around the connections by making multiple requests they would eventualy leave the pool and be recreated as good connections, but even after 50 attemps this error still persists until I restart the server. Any help with resolving this would be great. Regards Steven McArdle -- View this message in context: http://www.nabble.com/java.sql.SQLException%3A-System-or-internal-error-java.net.SocketException%3A-Software-caused-connection-abort%3A-socket-write-error-tp15331769p15331769.html Sent from the c3p0 - users mailing list archive at Nabble.com. |