Announcement Announcement Module
Collapse
No announcement yet.
Odd PostgreSQL problem Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Odd PostgreSQL problem

    I recently changed my site's db from MySQL to PostgreSQL. Everything went smoothly, except for one thing. If I visit the site for the first time in a while, it'll throw an exception. Any subsequent visits work just fine. Here's the exception I'm getting. Sorry It's so long, but I wasn't sure what was important.


    edit: using PostgreSQL 8 and postgresql-8.0-310.jdbc3 jar

    Code:
    [@APPNAME@] WARN [http-8080-Processor23] JDBCExceptionReporter.logExceptions(38) | SQL Error: 0, SQLState: 08006
    [@APPNAME@] ERROR [http-8080-Processor23] JDBCExceptionReporter.logExceptions(46) | An I/O error occured while sending to the backend.
    [@APPNAME@] WARN [http-8080-Processor23] JDBCExceptionReporter.logExceptions(38) | SQL Error: 0, SQLState: 08006
    [@APPNAME@] ERROR [http-8080-Processor23] JDBCExceptionReporter.logExceptions(46) | An I/O error occured while sending to the backend.
    &#91;@APPNAME@&#93; ERROR &#91;http-8080-Processor23&#93; JDBCException.<init>&#40;38&#41; | Could not execute query
    org.postgresql.util.PSQLException&#58; An I/O error occured while sending to the backend.
    	at org.postgresql.core.v3.QueryExecutorImpl.execute&#40;QueryExecutorImpl.java&#58;201&#41;
    	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute&#40;AbstractJdbc2Statement.java&#58;388&#41;
    	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags&#40;AbstractJdbc2Statement.java&#58;329&#41;
    	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery&#40;AbstractJdbc2Statement.java&#58;239&#41;
    	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery&#40;DelegatingPreparedStatement.java&#58;92&#41;
    	at net.sf.hibernate.impl.BatcherImpl.getResultSet&#40;BatcherImpl.java&#58;87&#41;
    	at net.sf.hibernate.loader.Loader.getResultSet&#40;Loader.java&#58;875&#41;
    	at net.sf.hibernate.loader.Loader.doQuery&#40;Loader.java&#58;269&#41;
    	at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections&#40;Loader.java&#58;133&#41;
    	at net.sf.hibernate.loader.Loader.doList&#40;Loader.java&#58;1033&#41;
    	at net.sf.hibernate.loader.Loader.list&#40;Loader.java&#58;1024&#41;
    	at net.sf.hibernate.hql.QueryTranslator.list&#40;QueryTranslator.java&#58;854&#41;
    	at net.sf.hibernate.impl.SessionImpl.find&#40;SessionImpl.java&#58;1544&#41;
    	at net.sf.hibernate.impl.QueryImpl.list&#40;QueryImpl.java&#58;39&#41;
    	at org.springframework.orm.hibernate.HibernateTemplate$24.doInHibernate&#40;HibernateTemplate.java&#58;620&#41;
    	at org.springframework.orm.hibernate.HibernateTemplate.execute&#40;HibernateTemplate.java&#58;312&#41;
    	at org.springframework.orm.hibernate.HibernateTemplate.find&#40;HibernateTemplate.java&#58;616&#41;
    	at org.appfuse.dao.hibernate.ListingDAOHibernate.getMainListings&#40;ListingDAOHibernate.java&#58;24&#41;
    	at org.appfuse.service.impl.ListingManagerImpl.getMainListings&#40;ListingManagerImpl.java&#58;27&#41;
    	at sun.reflect.GeneratedMethodAccessor141.invoke&#40;Unknown Source&#41;
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke&#40;DelegatingMethodAccessorImpl.java&#58;25&#41;
    	at java.lang.reflect.Method.invoke&#40;Method.java&#58;324&#41;
    	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection&#40;AopUtils.java&#58;282&#41;
    	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint&#40;ReflectiveMethodInvocation.java&#58;155&#41;
    	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed&#40;ReflectiveMethodInvocation.java&#58;122&#41;
    	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke&#40;TransactionInterceptor.java&#58;56&#41;
    	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed&#40;ReflectiveMethodInvocation.java&#58;144&#41;
    	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke&#40;JdkDynamicAopProxy.java&#58;174&#41;
    	at $Proxy10.getMainListings&#40;Unknown Source&#41;
    	at org.appfuse.web.MainController.handleRequest&#40;MainController.java&#58;36&#41;
    	at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle&#40;SimpleControllerHandlerAdapter.java&#58;44&#41;
    	at org.springframework.web.servlet.DispatcherServlet.doDispatch&#40;DispatcherServlet.java&#58;595&#41;
    	at org.springframework.web.servlet.DispatcherServlet.doService&#40;DispatcherServlet.java&#58;543&#41;
    	at org.springframework.web.servlet.FrameworkServlet.serviceWrapper&#40;FrameworkServlet.java&#58;390&#41;
    	at org.springframework.web.servlet.FrameworkServlet.doGet&#40;FrameworkServlet.java&#58;341&#41;
    	at javax.servlet.http.HttpServlet.service&#40;HttpServlet.java&#58;743&#41;
    	at javax.servlet.http.HttpServlet.service&#40;HttpServlet.java&#58;856&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;237&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
    	at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter&#40;PageFilter.java&#58;39&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
    	at org.apache.catalina.core.ApplicationDispatcher.invoke&#40;ApplicationDispatcher.java&#58;704&#41;
    	at org.apache.catalina.core.ApplicationDispatcher.processRequest&#40;ApplicationDispatcher.java&#58;474&#41;
    	at org.apache.catalina.core.ApplicationDispatcher.doForward&#40;ApplicationDispatcher.java&#58;409&#41;
    	at org.apache.catalina.core.ApplicationDispatcher.forward&#40;ApplicationDispatcher.java&#58;312&#41;
    	at org.apache.jasper.runtime.PageContextImpl.doForward&#40;PageContextImpl.java&#58;670&#41;
    	at org.apache.jasper.runtime.PageContextImpl.forward&#40;PageContextImpl.java&#58;637&#41;
    	at org.apache.jsp.index_jsp._jspService&#40;index_jsp.java&#58;43&#41;
    	at org.apache.jasper.runtime.HttpJspBase.service&#40;HttpJspBase.java&#58;94&#41;
    	at javax.servlet.http.HttpServlet.service&#40;HttpServlet.java&#58;856&#41;
    	at org.apache.jasper.servlet.JspServletWrapper.service&#40;JspServletWrapper.java&#58;324&#41;
    	at org.apache.jasper.servlet.JspServlet.serviceJspFile&#40;JspServlet.java&#58;292&#41;
    	at org.apache.jasper.servlet.JspServlet.service&#40;JspServlet.java&#58;236&#41;
    	at javax.servlet.http.HttpServlet.service&#40;HttpServlet.java&#58;856&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;237&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
    	at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage&#40;PageFilter.java&#58;118&#41;
    	at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter&#40;PageFilter.java&#58;52&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
    	at org.appfuse.web.filters.NewMailFilter.doFilter&#40;NewMailFilter.java&#58;41&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
    	at org.appfuse.web.filters.FirstTimeFilter.doFilter&#40;FirstTimeFilter.java&#58;62&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
    	at org.appfuse.web.filters.MessageFilter.doFilter&#40;MessageFilter.java&#58;36&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
    	at net.sf.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke&#40;FilterSecurityInterceptor.java&#58;70&#41;
    	at net.sf.acegisecurity.intercept.web.SecurityEnforcementFilter.doFilter&#40;SecurityEnforcementFilter.java&#58;169&#41;
    	at net.sf.acegisecurity.util.FilterToBeanProxy.doFilter&#40;FilterToBeanProxy.java&#58;105&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
    	at net.sf.acegisecurity.ui.AbstractIntegrationFilter.doFilter&#40;AbstractIntegrationFilter.java&#58;170&#41;
    	at net.sf.acegisecurity.util.FilterToBeanProxy.doFilter&#40;FilterToBeanProxy.java&#58;105&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
    	at net.sf.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter&#40;BasicProcessingFilter.java&#58;199&#41;
    	at net.sf.acegisecurity.util.FilterToBeanProxy.doFilter&#40;FilterToBeanProxy.java&#58;105&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
    	at net.sf.acegisecurity.ui.AbstractProcessingFilter.doFilter&#40;AbstractProcessingFilter.java&#58;333&#41;
    	at net.sf.acegisecurity.util.FilterToBeanProxy.doFilter&#40;FilterToBeanProxy.java&#58;105&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
    	at org.apache.catalina.core.StandardWrapperValve.invoke&#40;StandardWrapperValve.java&#58;214&#41;
    	at org.apache.catalina.core.StandardValveContext.invokeNext&#40;StandardValveContext.java&#58;104&#41;
    	at org.apache.catalina.core.StandardPipeline.invoke&#40;StandardPipeline.java&#58;520&#41;
    	at org.apache.catalina.core.StandardContextValve.invokeInternal&#40;StandardContextValve.java&#58;198&#41;
    	at org.apache.catalina.core.StandardContextValve.invoke&#40;StandardContextValve.java&#58;152&#41;
    	at org.apache.catalina.core.StandardValveContext.invokeNext&#40;StandardValveContext.java&#58;104&#41;
    	at org.apache.catalina.core.StandardPipeline.invoke&#40;StandardPipeline.java&#58;520&#41;
    	at org.apache.catalina.core.StandardHostValve.invoke&#40;StandardHostValve.java&#58;137&#41;
    	at org.apache.catalina.core.StandardValveContext.invokeNext&#40;StandardValveContext.java&#58;104&#41;
    	at org.apache.catalina.valves.ErrorReportValve.invoke&#40;ErrorReportValve.java&#58;117&#41;
    	at org.apache.catalina.core.StandardValveContext.invokeNext&#40;StandardValveContext.java&#58;102&#41;
    	at org.apache.catalina.core.StandardPipeline.invoke&#40;StandardPipeline.java&#58;520&#41;
    	at org.apache.catalina.core.StandardEngineValve.invoke&#40;StandardEngineValve.java&#58;109&#41;
    	at org.apache.catalina.core.StandardValveContext.invokeNext&#40;StandardValveContext.java&#58;104&#41;
    	at org.apache.catalina.core.StandardPipeline.invoke&#40;StandardPipeline.java&#58;520&#41;
    	at org.apache.catalina.core.ContainerBase.invoke&#40;ContainerBase.java&#58;929&#41;
    	at org.apache.coyote.tomcat5.CoyoteAdapter.service&#40;CoyoteAdapter.java&#58;160&#41;
    	at org.apache.coyote.http11.Http11Processor.process&#40;Http11Processor.java&#58;799&#41;
    	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection&#40;Http11Protocol.java&#58;705&#41;
    	at org.apache.tomcat.util.net.TcpWorkerThread.runIt&#40;PoolTcpEndpoint.java&#58;577&#41;
    	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run&#40;ThreadPool.java&#58;683&#41;
    	at java.lang.Thread.run&#40;Thread.java&#58;534&#41;
    Caused by&#58; java.net.SocketException&#58; Broken pipe
    	at java.net.SocketOutputStream.socketWrite0&#40;Native Method&#41;
    	at java.net.SocketOutputStream.socketWrite&#40;SocketOutputStream.java&#58;92&#41;
    	at java.net.SocketOutputStream.write&#40;SocketOutputStream.java&#58;136&#41;
    	at java.io.BufferedOutputStream.flushBuffer&#40;BufferedOutputStream.java&#58;66&#41;
    	at java.io.BufferedOutputStream.flush&#40;BufferedOutputStream.java&#58;124&#41;
    	at org.postgresql.core.PGStream.flush&#40;PGStream.java&#58;494&#41;
    	at org.postgresql.core.v3.QueryExecutorImpl.sendSync&#40;QueryExecutorImpl.java&#58;631&#41;
    	at org.postgresql.core.v3.QueryExecutorImpl.execute&#40;QueryExecutorImpl.java&#58;174&#41;
    	... 108 more
    &#91;@APPNAME@&#93; WARN &#91;http-8080-Processor23&#93; JDBCExceptionReporter.logExceptions&#40;38&#41; | SQL Error&#58; 0, SQLState&#58; null
    &#91;@APPNAME@&#93; ERROR &#91;http-8080-Processor23&#93; JDBCExceptionReporter.logExceptions&#40;46&#41; | Already closed.
    &#91;@APPNAME@&#93; WARN &#91;http-8080-Processor23&#93; JDBCExceptionReporter.logExceptions&#40;38&#41; | SQL Error&#58; 0, SQLState&#58; null
    &#91;@APPNAME@&#93; ERROR &#91;http-8080-Processor23&#93; JDBCExceptionReporter.logExceptions&#40;46&#41; | Already closed.
    &#91;@APPNAME@&#93; ERROR &#91;http-8080-Processor23&#93; JDBCException.<init>&#40;38&#41; | Cannot close connection
    java.sql.SQLException&#58; Already closed.
    	at org.apache.commons.dbcp.PoolableConnection.close&#40;PoolableConnection.java&#58;77&#41;
    	at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close&#40;PoolingDataSource.java&#58;180&#41;
    	at org.springframework.orm.hibernate.LocalDataSourceConnectionProvider.closeConnection&#40;LocalDataSourceConnectionProvider.java&#58;85&#41;
    	at net.sf.hibernate.impl.BatcherImpl.closeConnection&#40;BatcherImpl.java&#58;305&#41;
    	at net.sf.hibernate.impl.SessionImpl.disconnect&#40;SessionImpl.java&#58;3352&#41;
    	at net.sf.hibernate.impl.SessionImpl.close&#40;SessionImpl.java&#58;576&#41;
    	at org.springframework.orm.hibernate.SessionFactoryUtils.doClose&#40;SessionFactoryUtils.java&#58;720&#41;
    	at org.springframework.orm.hibernate.SessionFactoryUtils.closeSessionOrRegisterDeferredClose&#40;SessionFactoryUtils.java&#58;709&#41;
    	at org.springframework.orm.hibernate.SessionFactoryUtils.closeSessionIfNecessary&#40;SessionFactoryUtils.java&#58;690&#41;
    	at org.springframework.orm.hibernate.HibernateTransactionManager.doCleanupAfterCompletion&#40;HibernateTransactionManager.java&#58;552&#41;
    	at org.springframework.transaction.support.AbstractPlatformTransactionManager.cleanupAfterCompletion&#40;AbstractPlatformTransactionManager.java&#58;577&#41;
    	at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback&#40;AbstractPlatformTransactionManager.java&#58;459&#41;
    	at org.springframework.transaction.interceptor.TransactionAspectSupport.doCloseTransactionAfterThrowing&#40;TransactionAspectSupport.java&#58;261&#41;
    	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke&#40;TransactionInterceptor.java&#58;60&#41;
    	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed&#40;ReflectiveMethodInvocation.java&#58;144&#41;
    	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke&#40;JdkDynamicAopProxy.java&#58;174&#41;
    	at $Proxy10.getMainListings&#40;Unknown Source&#41;
    	at org.appfuse.web.MainController.handleRequest&#40;MainController.java&#58;36&#41;
    	at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle&#40;SimpleControllerHandlerAdapter.java&#58;44&#41;
    	at org.springframework.web.servlet.DispatcherServlet.doDispatch&#40;DispatcherServlet.java&#58;595&#41;
    	at org.springframework.web.servlet.DispatcherServlet.doService&#40;DispatcherServlet.java&#58;543&#41;
    	at org.springframework.web.servlet.FrameworkServlet.serviceWrapper&#40;FrameworkServlet.java&#58;390&#41;
    	at org.springframework.web.servlet.FrameworkServlet.doGet&#40;FrameworkServlet.java&#58;341&#41;
    	at javax.servlet.http.HttpServlet.service&#40;HttpServlet.java&#58;743&#41;
    	at javax.servlet.http.HttpServlet.service&#40;HttpServlet.java&#58;856&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;237&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
    	at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter&#40;PageFilter.java&#58;39&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
    	at org.apache.catalina.core.ApplicationDispatcher.invoke&#40;ApplicationDispatcher.java&#58;704&#41;
    	at org.apache.catalina.core.ApplicationDispatcher.processRequest&#40;ApplicationDispatcher.java&#58;474&#41;
    	at org.apache.catalina.core.ApplicationDispatcher.doForward&#40;ApplicationDispatcher.java&#58;409&#41;
    	at org.apache.catalina.core.ApplicationDispatcher.forward&#40;ApplicationDispatcher.java&#58;312&#41;
    	at org.apache.jasper.runtime.PageContextImpl.doForward&#40;PageContextImpl.java&#58;670&#41;
    	at org.apache.jasper.runtime.PageContextImpl.forward&#40;PageContextImpl.java&#58;637&#41;
    	at org.apache.jsp.index_jsp._jspService&#40;index_jsp.java&#58;43&#41;
    	at org.apache.jasper.runtime.HttpJspBase.service&#40;HttpJspBase.java&#58;94&#41;
    	at javax.servlet.http.HttpServlet.service&#40;HttpServlet.java&#58;856&#41;
    	at org.apache.jasper.servlet.JspServletWrapper.service&#40;JspServletWrapper.java&#58;324&#41;
    	at org.apache.jasper.servlet.JspServlet.serviceJspFile&#40;JspServlet.java&#58;292&#41;
    	at org.apache.jasper.servlet.JspServlet.service&#40;JspServlet.java&#58;236&#41;
    	at javax.servlet.http.HttpServlet.service&#40;HttpServlet.java&#58;856&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;237&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
    	at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage&#40;PageFilter.java&#58;118&#41;
    	at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter&#40;PageFilter.java&#58;52&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
    	at org.appfuse.web.filters.NewMailFilter.doFilter&#40;NewMailFilter.java&#58;41&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
    	at org.appfuse.web.filters.FirstTimeFilter.doFilter&#40;FirstTimeFilter.java&#58;62&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
    	at org.appfuse.web.filters.MessageFilter.doFilter&#40;MessageFilter.java&#58;36&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
    	at net.sf.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke&#40;FilterSecurityInterceptor.java&#58;70&#41;
    	at net.sf.acegisecurity.intercept.web.SecurityEnforcementFilter.doFilter&#40;SecurityEnforcementFilter.java&#58;169&#41;
    	at net.sf.acegisecurity.util.FilterToBeanProxy.doFilter&#40;FilterToBeanProxy.java&#58;105&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
    	at net.sf.acegisecurity.ui.AbstractIntegrationFilter.doFilter&#40;AbstractIntegrationFilter.java&#58;170&#41;
    	at net.sf.acegisecurity.util.FilterToBeanProxy.doFilter&#40;FilterToBeanProxy.java&#58;105&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
    	at net.sf.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter&#40;BasicProcessingFilter.java&#58;199&#41;
    	at net.sf.acegisecurity.util.FilterToBeanProxy.doFilter&#40;FilterToBeanProxy.java&#58;105&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
    	at net.sf.acegisecurity.ui.AbstractProcessingFilter.doFilter&#40;AbstractProcessingFilter.java&#58;333&#41;
    	at net.sf.acegisecurity.util.FilterToBeanProxy.doFilter&#40;FilterToBeanProxy.java&#58;105&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
    	at org.apache.catalina.core.StandardWrapperValve.invoke&#40;StandardWrapperValve.java&#58;214&#41;
    	at org.apache.catalina.core.StandardValveContext.invokeNext&#40;StandardValveContext.java&#58;104&#41;
    	at org.apache.catalina.core.StandardPipeline.invoke&#40;StandardPipeline.java&#58;520&#41;
    	at org.apache.catalina.core.StandardContextValve.invokeInternal&#40;StandardContextValve.java&#58;198&#41;
    	at org.apache.catalina.core.StandardContextValve.invoke&#40;StandardContextValve.java&#58;152&#41;
    	at org.apache.catalina.core.StandardValveContext.invokeNext&#40;StandardValveContext.java&#58;104&#41;
    	at org.apache.catalina.core.StandardPipeline.invoke&#40;StandardPipeline.java&#58;520&#41;
    	at org.apache.catalina.core.StandardHostValve.invoke&#40;StandardHostValve.java&#58;137&#41;
    	at org.apache.catalina.core.StandardValveContext.invokeNext&#40;StandardValveContext.java&#58;104&#41;
    	at org.apache.catalina.valves.ErrorReportValve.invoke&#40;ErrorReportValve.java&#58;117&#41;
    	at org.apache.catalina.core.StandardValveContext.invokeNext&#40;StandardValveContext.java&#58;102&#41;
    	at org.apache.catalina.core.StandardPipeline.invoke&#40;StandardPipeline.java&#58;520&#41;
    	at org.apache.catalina.core.StandardEngineValve.invoke&#40;StandardEngineValve.java&#58;109&#41;
    	at org.apache.catalina.core.StandardValveContext.invokeNext&#40;StandardValveContext.java&#58;104&#41;
    	at org.apache.catalina.core.StandardPipeline.invoke&#40;StandardPipeline.java&#58;520&#41;
    	at org.apache.catalina.core.ContainerBase.invoke&#40;ContainerBase.java&#58;929&#41;
    	at org.apache.coyote.tomcat5.CoyoteAdapter.service&#40;CoyoteAdapter.java&#58;160&#41;
    	at org.apache.coyote.http11.Http11Processor.process&#40;Http11Processor.java&#58;799&#41;
    	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection&#40;Http11Protocol.java&#58;705&#41;
    	at org.apache.tomcat.util.net.TcpWorkerThread.runIt&#40;PoolTcpEndpoint.java&#58;577&#41;
    	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run&#40;ThreadPool.java&#58;683&#41;
    	at java.lang.Thread.run&#40;Thread.java&#58;534&#41;
    &#91;@APPNAME@&#93; ERROR &#91;http-8080-Processor23&#93; SessionFactoryUtils.doClose&#40;724&#41; | Could not close Hibernate session
    java.sql.SQLException&#58; Already closed.
    	at org.apache.commons.dbcp.PoolableConnection.close&#40;PoolableConnection.java&#58;77&#41;
    	at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close&#40;PoolingDataSource.java&#58;180&#41;
    	at org.springframework.orm.hibernate.LocalDataSourceConnectionProvider.closeConnection&#40;LocalDataSourceConnectionProvider.java&#58;85&#41;
    	at net.sf.hibernate.impl.BatcherImpl.closeConnection&#40;BatcherImpl.java&#58;305&#41;
    	at net.sf.hibernate.impl.SessionImpl.disconnect&#40;SessionImpl.java&#58;3352&#41;
    	at net.sf.hibernate.impl.SessionImpl.close&#40;SessionImpl.java&#58;576&#41;
    	at org.springframework.orm.hibernate.SessionFactoryUtils.doClose&#40;SessionFactoryUtils.java&#58;720&#41;
    	at org.springframework.orm.hibernate.SessionFactoryUtils.closeSessionOrRegisterDeferredClose&#40;SessionFactoryUtils.java&#58;709&#41;
    	at org.springframework.orm.hibernate.SessionFactoryUtils.closeSessionIfNecessary&#40;SessionFactoryUtils.java&#58;690&#41;
    	at org.springframework.orm.hibernate.HibernateTransactionManager.doCleanupAfterCompletion&#40;HibernateTransactionManager.java&#58;552&#41;
    	at org.springframework.transaction.support.AbstractPlatformTransactionManager.cleanupAfterCompletion&#40;AbstractPlatformTransactionManager.java&#58;577&#41;
    	at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback&#40;AbstractPlatformTransactionManager.java&#58;459&#41;
    	at org.springframework.transaction.interceptor.TransactionAspectSupport.doCloseTransactionAfterThrowing&#40;TransactionAspectSupport.java&#58;261&#41;
    	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke&#40;TransactionInterceptor.java&#58;60&#41;
    	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed&#40;ReflectiveMethodInvocation.java&#58;144&#41;
    	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke&#40;JdkDynamicAopProxy.java&#58;174&#41;
    	at $Proxy10.getMainListings&#40;Unknown Source&#41;
    	at org.appfuse.web.MainController.handleRequest&#40;MainController.java&#58;36&#41;
    	at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle&#40;SimpleControllerHandlerAdapter.java&#58;44&#41;
    	at org.springframework.web.servlet.DispatcherServlet.doDispatch&#40;DispatcherServlet.java&#58;595&#41;
    	at org.springframework.web.servlet.DispatcherServlet.doService&#40;DispatcherServlet.java&#58;543&#41;
    	at org.springframework.web.servlet.FrameworkServlet.serviceWrapper&#40;FrameworkServlet.java&#58;390&#41;
    	at org.springframework.web.servlet.FrameworkServlet.doGet&#40;FrameworkServlet.java&#58;341&#41;
    	at javax.servlet.http.HttpServlet.service&#40;HttpServlet.java&#58;743&#41;
    	at javax.servlet.http.HttpServlet.service&#40;HttpServlet.java&#58;856&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;237&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
    	at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter&#40;PageFilter.java&#58;39&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
    	at org.apache.catalina.core.ApplicationDispatcher.invoke&#40;ApplicationDispatcher.java&#58;704&#41;
    	at org.apache.catalina.core.ApplicationDispatcher.processRequest&#40;ApplicationDispatcher.java&#58;474&#41;
    	at org.apache.catalina.core.ApplicationDispatcher.doForward&#40;ApplicationDispatcher.java&#58;409&#41;
    	at org.apache.catalina.core.ApplicationDispatcher.forward&#40;ApplicationDispatcher.java&#58;312&#41;
    	at org.apache.jasper.runtime.PageContextImpl.doForward&#40;PageContextImpl.java&#58;670&#41;
    	at org.apache.jasper.runtime.PageContextImpl.forward&#40;PageContextImpl.java&#58;637&#41;
    	at org.apache.jsp.index_jsp._jspService&#40;index_jsp.java&#58;43&#41;
    	at org.apache.jasper.runtime.HttpJspBase.service&#40;HttpJspBase.java&#58;94&#41;
    	at javax.servlet.http.HttpServlet.service&#40;HttpServlet.java&#58;856&#41;
    	at org.apache.jasper.servlet.JspServletWrapper.service&#40;JspServletWrapper.java&#58;324&#41;
    	at org.apache.jasper.servlet.JspServlet.serviceJspFile&#40;JspServlet.java&#58;292&#41;
    	at org.apache.jasper.servlet.JspServlet.service&#40;JspServlet.java&#58;236&#41;
    	at javax.servlet.http.HttpServlet.service&#40;HttpServlet.java&#58;856&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;237&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
    	at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage&#40;PageFilter.java&#58;118&#41;
    	at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter&#40;PageFilter.java&#58;52&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
    	at org.appfuse.web.filters.NewMailFilter.doFilter&#40;NewMailFilter.java&#58;41&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
    	at org.appfuse.web.filters.FirstTimeFilter.doFilter&#40;FirstTimeFilter.java&#58;62&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
    	at org.appfuse.web.filters.MessageFilter.doFilter&#40;MessageFilter.java&#58;36&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
    	at net.sf.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke&#40;FilterSecurityInterceptor.java&#58;70&#41;
    	at net.sf.acegisecurity.intercept.web.SecurityEnforcementFilter.doFilter&#40;SecurityEnforcementFilter.java&#58;169&#41;
    	at net.sf.acegisecurity.util.FilterToBeanProxy.doFilter&#40;FilterToBeanProxy.java&#58;105&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
    	at net.sf.acegisecurity.ui.AbstractIntegrationFilter.doFilter&#40;AbstractIntegrationFilter.java&#58;170&#41;
    	at net.sf.acegisecurity.util.FilterToBeanProxy.doFilter&#40;FilterToBeanProxy.java&#58;105&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
    	at net.sf.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter&#40;BasicProcessingFilter.java&#58;199&#41;
    	at net.sf.acegisecurity.util.FilterToBeanProxy.doFilter&#40;FilterToBeanProxy.java&#58;105&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
    	at net.sf.acegisecurity.ui.AbstractProcessingFilter.doFilter&#40;AbstractProcessingFilter.java&#58;333&#41;
    	at net.sf.acegisecurity.util.FilterToBeanProxy.doFilter&#40;FilterToBeanProxy.java&#58;105&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
    	at org.apache.catalina.core.StandardWrapperValve.invoke&#40;StandardWrapperValve.java&#58;214&#41;
    	at org.apache.catalina.core.StandardValveContext.invokeNext&#40;StandardValveContext.java&#58;104&#41;
    	at org.apache.catalina.core.StandardPipeline.invoke&#40;StandardPipeline.java&#58;520&#41;
    	at org.apache.catalina.core.StandardContextValve.invokeInternal&#40;StandardContextValve.java&#58;198&#41;
    	at org.apache.catalina.core.StandardContextValve.invoke&#40;StandardContextValve.java&#58;152&#41;
    	at org.apache.catalina.core.StandardValveContext.invokeNext&#40;StandardValveContext.java&#58;104&#41;
    	at org.apache.catalina.core.StandardPipeline.invoke&#40;StandardPipeline.java&#58;520&#41;
    	at org.apache.catalina.core.StandardHostValve.invoke&#40;StandardHostValve.java&#58;137&#41;
    	at org.apache.catalina.core.StandardValveContext.invokeNext&#40;StandardValveContext.java&#58;104&#41;
    	at org.apache.catalina.valves.ErrorReportValve.invoke&#40;ErrorReportValve.java&#58;117&#41;
    	at org.apache.catalina.core.StandardValveContext.invokeNext&#40;StandardValveContext.java&#58;102&#41;
    	at org.apache.catalina.core.StandardPipeline.invoke&#40;StandardPipeline.java&#58;520&#41;
    	at org.apache.catalina.core.StandardEngineValve.invoke&#40;StandardEngineValve.java&#58;109&#41;
    	at org.apache.catalina.core.StandardValveContext.invokeNext&#40;StandardValveContext.java&#58;104&#41;
    	at org.apache.catalina.core.StandardPipeline.invoke&#40;StandardPipeline.java&#58;520&#41;
    	at org.apache.catalina.core.ContainerBase.invoke&#40;ContainerBase.java&#58;929&#41;
    	at org.apache.coyote.tomcat5.CoyoteAdapter.service&#40;CoyoteAdapter.java&#58;160&#41;
    	at org.apache.coyote.http11.Http11Processor.process&#40;Http11Processor.java&#58;799&#41;
    	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection&#40;Http11Protocol.java&#58;705&#41;
    	at org.apache.tomcat.util.net.TcpWorkerThread.runIt&#40;PoolTcpEndpoint.java&#58;577&#41;
    	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run&#40;ThreadPool.java&#58;683&#41;
    	at java.lang.Thread.run&#40;Thread.java&#58;534&#41;
    &#91;@APPNAME@&#93; WARN &#91;http-8080-Processor23&#93; DispatcherServlet.processHandlerException&#40;791&#41; | Handler execution resulted in exception - forwarding to resolved error view
    org.springframework.jdbc.UncategorizedSQLException&#58; &#40;Hibernate operation&#41;&#58; encountered SQLException &#91;An I/O error occured while sending to the backend.&#93;; nested exception is org.postgresql.util.PSQLException&#58; An I/O error occured while sending to the backend.
    org.postgresql.util.PSQLException&#58; An I/O error occured while sending to the backend.
    	at org.postgresql.core.v3.QueryExecutorImpl.execute&#40;QueryExecutorImpl.java&#58;201&#41;
    	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute&#40;AbstractJdbc2Statement.java&#58;388&#41;
    	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags&#40;AbstractJdbc2Statement.java&#58;329&#41;
    	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery&#40;AbstractJdbc2Statement.java&#58;239&#41;
    	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery&#40;DelegatingPreparedStatement.java&#58;92&#41;
    	at net.sf.hibernate.impl.BatcherImpl.getResultSet&#40;BatcherImpl.java&#58;87&#41;
    	at net.sf.hibernate.loader.Loader.getResultSet&#40;Loader.java&#58;875&#41;
    	at net.sf.hibernate.loader.Loader.doQuery&#40;Loader.java&#58;269&#41;
    	at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections&#40;Loader.java&#58;133&#41;
    	at net.sf.hibernate.loader.Loader.doList&#40;Loader.java&#58;1033&#41;
    	at net.sf.hibernate.loader.Loader.list&#40;Loader.java&#58;1024&#41;
    	at net.sf.hibernate.hql.QueryTranslator.list&#40;QueryTranslator.java&#58;854&#41;
    	at net.sf.hibernate.impl.SessionImpl.find&#40;SessionImpl.java&#58;1544&#41;
    	at net.sf.hibernate.impl.QueryImpl.list&#40;QueryImpl.java&#58;39&#41;
    	at org.springframework.orm.hibernate.HibernateTemplate$24.doInHibernate&#40;HibernateTemplate.java&#58;620&#41;
    	at org.springframework.orm.hibernate.HibernateTemplate.execute&#40;HibernateTemplate.java&#58;312&#41;
    	at org.springframework.orm.hibernate.HibernateTemplate.find&#40;HibernateTemplate.java&#58;616&#41;
    	at org.appfuse.dao.hibernate.ListingDAOHibernate.getMainListings&#40;ListingDAOHibernate.java&#58;24&#41;
    	at org.appfuse.service.impl.ListingManagerImpl.getMainListings&#40;ListingManagerImpl.java&#58;27&#41;
    	at sun.reflect.GeneratedMethodAccessor141.invoke&#40;Unknown Source&#41;
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke&#40;DelegatingMethodAccessorImpl.java&#58;25&#41;
    	at java.lang.reflect.Method.invoke&#40;Method.java&#58;324&#41;
    	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection&#40;AopUtils.java&#58;282&#41;
    	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint&#40;ReflectiveMethodInvocation.java&#58;155&#41;
    	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed&#40;ReflectiveMethodInvocation.java&#58;122&#41;
    	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke&#40;TransactionInterceptor.java&#58;56&#41;
    	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed&#40;ReflectiveMethodInvocation.java&#58;144&#41;
    	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke&#40;JdkDynamicAopProxy.java&#58;174&#41;
    	at $Proxy10.getMainListings&#40;Unknown Source&#41;
    	at org.appfuse.web.MainController.handleRequest&#40;MainController.java&#58;36&#41;
    	at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle&#40;SimpleControllerHandlerAdapter.java&#58;44&#41;
    	at org.springframework.web.servlet.DispatcherServlet.doDispatch&#40;DispatcherServlet.java&#58;595&#41;
    	at org.springframework.web.servlet.DispatcherServlet.doService&#40;DispatcherServlet.java&#58;543&#41;
    	at org.springframework.web.servlet.FrameworkServlet.serviceWrapper&#40;FrameworkServlet.java&#58;390&#41;
    	at org.springframework.web.servlet.FrameworkServlet.doGet&#40;FrameworkServlet.java&#58;341&#41;
    	at javax.servlet.http.HttpServlet.service&#40;HttpServlet.java&#58;743&#41;
    	at javax.servlet.http.HttpServlet.service&#40;HttpServlet.java&#58;856&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;237&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
    	at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter&#40;PageFilter.java&#58;39&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
    	at org.apache.catalina.core.ApplicationDispatcher.invoke&#40;ApplicationDispatcher.java&#58;704&#41;
    	at org.apache.catalina.core.ApplicationDispatcher.processRequest&#40;ApplicationDispatcher.java&#58;474&#41;
    	at org.apache.catalina.core.ApplicationDispatcher.doForward&#40;ApplicationDispatcher.java&#58;409&#41;
    	at org.apache.catalina.core.ApplicationDispatcher.forward&#40;ApplicationDispatcher.java&#58;312&#41;
    	at org.apache.jasper.runtime.PageContextImpl.doForward&#40;PageContextImpl.java&#58;670&#41;
    	at org.apache.jasper.runtime.PageContextImpl.forward&#40;PageContextImpl.java&#58;637&#41;
    	at org.apache.jsp.index_jsp._jspService&#40;index_jsp.java&#58;43&#41;
    	at org.apache.jasper.runtime.HttpJspBase.service&#40;HttpJspBase.java&#58;94&#41;
    	at javax.servlet.http.HttpServlet.service&#40;HttpServlet.java&#58;856&#41;
    	at org.apache.jasper.servlet.JspServletWrapper.service&#40;JspServletWrapper.java&#58;324&#41;
    	at org.apache.jasper.servlet.JspServlet.serviceJspFile&#40;JspServlet.java&#58;292&#41;
    	at org.apache.jasper.servlet.JspServlet.service&#40;JspServlet.java&#58;236&#41;
    	at javax.servlet.http.HttpServlet.service&#40;HttpServlet.java&#58;856&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;237&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
    	at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage&#40;PageFilter.java&#58;118&#41;
    	at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter&#40;PageFilter.java&#58;52&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
    	at org.appfuse.web.filters.NewMailFilter.doFilter&#40;NewMailFilter.java&#58;41&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
    	at org.appfuse.web.filters.FirstTimeFilter.doFilter&#40;FirstTimeFilter.java&#58;62&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
    	at org.appfuse.web.filters.MessageFilter.doFilter&#40;MessageFilter.java&#58;36&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
    	at net.sf.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke&#40;FilterSecurityInterceptor.java&#58;70&#41;
    	at net.sf.acegisecurity.intercept.web.SecurityEnforcementFilter.doFilter&#40;SecurityEnforcementFilter.java&#58;169&#41;
    	at net.sf.acegisecurity.util.FilterToBeanProxy.doFilter&#40;FilterToBeanProxy.java&#58;105&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
    	at net.sf.acegisecurity.ui.AbstractIntegrationFilter.doFilter&#40;AbstractIntegrationFilter.java&#58;170&#41;
    	at net.sf.acegisecurity.util.FilterToBeanProxy.doFilter&#40;FilterToBeanProxy.java&#58;105&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
    	at net.sf.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter&#40;BasicProcessingFilter.java&#58;199&#41;
    	at net.sf.acegisecurity.util.FilterToBeanProxy.doFilter&#40;FilterToBeanProxy.java&#58;105&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
    	at net.sf.acegisecurity.ui.AbstractProcessingFilter.doFilter&#40;AbstractProcessingFilter.java&#58;333&#41;
    	at net.sf.acegisecurity.util.FilterToBeanProxy.doFilter&#40;FilterToBeanProxy.java&#58;105&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
    	at org.apache.catalina.core.StandardWrapperValve.invoke&#40;StandardWrapperValve.java&#58;214&#41;
    	at org.apache.catalina.core.StandardValveContext.invokeNext&#40;StandardValveContext.java&#58;104&#41;
    	at org.apache.catalina.core.StandardPipeline.invoke&#40;StandardPipeline.java&#58;520&#41;
    	at org.apache.catalina.core.StandardContextValve.invokeInternal&#40;StandardContextValve.java&#58;198&#41;
    	at org.apache.catalina.core.StandardContextValve.invoke&#40;StandardContextValve.java&#58;152&#41;
    	at org.apache.catalina.core.StandardValveContext.invokeNext&#40;StandardValveContext.java&#58;104&#41;
    	at org.apache.catalina.core.StandardPipeline.invoke&#40;StandardPipeline.java&#58;520&#41;
    	at org.apache.catalina.core.StandardHostValve.invoke&#40;StandardHostValve.java&#58;137&#41;
    	at org.apache.catalina.core.StandardValveContext.invokeNext&#40;StandardValveContext.java&#58;104&#41;
    	at org.apache.catalina.valves.ErrorReportValve.invoke&#40;ErrorReportValve.java&#58;117&#41;
    	at org.apache.catalina.core.StandardValveContext.invokeNext&#40;StandardValveContext.java&#58;102&#41;
    	at org.apache.catalina.core.StandardPipeline.invoke&#40;StandardPipeline.java&#58;520&#41;
    	at org.apache.catalina.core.StandardEngineValve.invoke&#40;StandardEngineValve.java&#58;109&#41;
    	at org.apache.catalina.core.StandardValveContext.invokeNext&#40;StandardValveContext.java&#58;104&#41;
    	at org.apache.catalina.core.StandardPipeline.invoke&#40;StandardPipeline.java&#58;520&#41;
    	at org.apache.catalina.core.ContainerBase.invoke&#40;ContainerBase.java&#58;929&#41;
    	at org.apache.coyote.tomcat5.CoyoteAdapter.service&#40;CoyoteAdapter.java&#58;160&#41;
    	at org.apache.coyote.http11.Http11Processor.process&#40;Http11Processor.java&#58;799&#41;
    	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection&#40;Http11Protocol.java&#58;705&#41;
    	at org.apache.tomcat.util.net.TcpWorkerThread.runIt&#40;PoolTcpEndpoint.java&#58;577&#41;
    	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run&#40;ThreadPool.java&#58;683&#41;
    	at java.lang.Thread.run&#40;Thread.java&#58;534&#41;
    Caused by&#58; java.net.SocketException&#58; Broken pipe
    	at java.net.SocketOutputStream.socketWrite0&#40;Native Method&#41;
    	at java.net.SocketOutputStream.socketWrite&#40;SocketOutputStream.java&#58;92&#41;
    	at java.net.SocketOutputStream.write&#40;SocketOutputStream.java&#58;136&#41;
    	at java.io.BufferedOutputStream.flushBuffer&#40;BufferedOutputStream.java&#58;66&#41;
    	at java.io.BufferedOutputStream.flush&#40;BufferedOutputStream.java&#58;124&#41;
    	at org.postgresql.core.PGStream.flush&#40;PGStream.java&#58;494&#41;
    	at org.postgresql.core.v3.QueryExecutorImpl.sendSync&#40;QueryExecutorImpl.java&#58;631&#41;
    	at org.postgresql.core.v3.QueryExecutorImpl.execute&#40;QueryExecutorImpl.java&#58;174&#41;
    	... 108 more

  • #2
    Weird. I would say the problem is somewhere at DB level - driver, connection pool or smth like that. Try to search the HB forums and to use c3p0 instead of dbcp. Turn also logging on.

    Comment


    • #3
      I went ahead and switched to the c3p0 driver and everything appears to working okay. Spring really makes switching these pooling jars around with such ease, I love it. Unfortunately, I won't really be able to see if it works until I let the app sit for a while and see if it throws that exception again. Sounds weird, but I don't know really know what's causing it.

      Is there an advantage of using c3p0 instead of common's pooling?

      Comment


      • #4
        I have always used c3p0 simply because my apps rely on HB and the HB team recommends c3p0 and doesn't recommend commons-dbcp. I don't have the thread link right now here but you can take a look on HB forums. Weird errors like you had are the reason behind dropping support for dbcp inside the official HB release (at least that's what I last read on the forums).

        Comment


        • #5
          Well, the fun isn't over yet. Here's the exception I'm getting now:

          Code:
          com.mchange.v2.c3p0.impl.C3P0PooledConnection@4173b9 invalidated by Exception&#58; org.postgresql.util.PSQLException&#58; An I/O error occured while sending to the backend.
                  at org.postgresql.core.v3.QueryExecutorImpl.execute&#40;QueryExecutorImpl.java&#58;201&#41;
                  at org.postgresql.jdbc2.AbstractJdbc2Statement.execute&#40;AbstractJdbc2Statement.java&#58;388&#41;
                  at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags&#40;AbstractJdbc2Statement.java&#58;313&#41;
                  at org.postgresql.jdbc2.AbstractJdbc2Connection.execSQLUpdate&#40;AbstractJdbc2Connection.java&#58;211&#41;
                  at org.postgresql.jdbc2.AbstractJdbc2Connection.setReadOnly&#40;AbstractJdbc2Connection.java&#58;565&#41;
                  at sun.reflect.GeneratedMethodAccessor130.invoke&#40;Unknown Source&#41;
                  at sun.reflect.DelegatingMethodAccessorImpl.invoke&#40;DelegatingMethodAccessorImpl.java&#58;25&#41;
                  at java.lang.reflect.Method.invoke&#40;Method.java&#58;324&#41;
                  at com.mchange.v2.c3p0.impl.C3P0PooledConnection$ProxyConnectionInvocationHandler.invoke&#40;C3P0PooledConnection.java&#58;712&#41;
                  at com.mchange.v2.c3p0.impl.$Proxy6.setReadOnly&#40;Unknown Source&#41;
                  at org.springframework.jdbc.datasource.DataSourceUtils.prepareConnectionForTransaction&#40;DataSourceUtils.java&#58;212&#41;
                  at org.springframework.orm.hibernate.HibernateTransactionManager.doBegin&#40;HibernateTransactionManager.java&#58;389&#41;
                  at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction&#40;AbstractPlatformTransactionManager.java&#58;272&#41;
                  at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary&#40;TransactionAspectSupport.java&#58;202&#41;
                  at org.springframework.transaction.interceptor.TransactionInterceptor.invoke&#40;TransactionInterceptor.java&#58;49&#41;
                  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed&#40;ReflectiveMethodInvocation.java&#58;144&#41;
                  at org.springframework.aop.framework.JdkDynamicAopProxy.invoke&#40;JdkDynamicAopProxy.java&#58;174&#41;
                  at $Proxy11.getMainListings&#40;Unknown Source&#41;
                  at org.appfuse.web.MainController.handleRequest&#40;MainController.java&#58;36&#41;
                  at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle&#40;SimpleControllerHandlerAdapter.java&#58;44&#41;
                  at org.springframework.web.servlet.DispatcherServlet.doDispatch&#40;DispatcherServlet.java&#58;595&#41;
                  at org.springframework.web.servlet.DispatcherServlet.doService&#40;DispatcherServlet.java&#58;543&#41;
                  at org.springframework.web.servlet.FrameworkServlet.serviceWrapper&#40;FrameworkServlet.java&#58;390&#41;
                  at org.springframework.web.servlet.FrameworkServlet.doGet&#40;FrameworkServlet.java&#58;341&#41;
                  at javax.servlet.http.HttpServlet.service&#40;HttpServlet.java&#58;743&#41;
                  at javax.servlet.http.HttpServlet.service&#40;HttpServlet.java&#58;856&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;237&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
                  at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter&#40;PageFilter.java&#58;39&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
                  at org.apache.catalina.core.ApplicationDispatcher.invoke&#40;ApplicationDispatcher.java&#58;704&#41;
                  at org.apache.catalina.core.ApplicationDispatcher.processRequest&#40;ApplicationDispatcher.java&#58;474&#41;
                  at org.apache.catalina.core.ApplicationDispatcher.doForward&#40;ApplicationDispatcher.java&#58;409&#41;
                  at org.apache.catalina.core.ApplicationDispatcher.forward&#40;ApplicationDispatcher.java&#58;312&#41;
                  at org.apache.jasper.runtime.PageContextImpl.doForward&#40;PageContextImpl.java&#58;670&#41;
                  at org.apache.jasper.runtime.PageContextImpl.forward&#40;PageContextImpl.java&#58;637&#41;
                  at org.apache.jsp.index_jsp._jspService&#40;index_jsp.java&#58;43&#41;
                  at org.apache.jasper.runtime.HttpJspBase.service&#40;HttpJspBase.java&#58;94&#41;
                  at javax.servlet.http.HttpServlet.service&#40;HttpServlet.java&#58;856&#41;
                  at org.apache.jasper.servlet.JspServletWrapper.service&#40;JspServletWrapper.java&#58;324&#41;
                  at org.apache.jasper.servlet.JspServlet.serviceJspFile&#40;JspServlet.java&#58;292&#41;
                  at org.apache.jasper.servlet.JspServlet.service&#40;JspServlet.java&#58;236&#41;
                  at javax.servlet.http.HttpServlet.service&#40;HttpServlet.java&#58;856&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;237&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
                  at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage&#40;PageFilter.java&#58;118&#41;
                  at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter&#40;PageFilter.java&#58;52&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
                  at org.appfuse.web.filters.NewMailFilter.doFilter&#40;NewMailFilter.java&#58;41&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
                  at org.appfuse.web.filters.FirstTimeFilter.doFilter&#40;FirstTimeFilter.java&#58;62&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
                  at org.appfuse.web.filters.MessageFilter.doFilter&#40;MessageFilter.java&#58;36&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
                  at net.sf.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke&#40;FilterSecurityInterceptor.java&#58;70&#41;
                  at net.sf.acegisecurity.intercept.web.SecurityEnforcementFilter.doFilter&#40;SecurityEnforcementFilter.java&#58;169&#41;
                  at net.sf.acegisecurity.util.FilterToBeanProxy.doFilter&#40;FilterToBeanProxy.java&#58;105&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
                  at net.sf.acegisecurity.ui.AbstractIntegrationFilter.doFilter&#40;AbstractIntegrationFilter.java&#58;170&#41;
                  at net.sf.acegisecurity.util.FilterToBeanProxy.doFilter&#40;FilterToBeanProxy.java&#58;105&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
                  at net.sf.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter&#40;BasicProcessingFilter.java&#58;199&#41;
                  at net.sf.acegisecurity.util.FilterToBeanProxy.doFilter&#40;FilterToBeanProxy.java&#58;105&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
                  at net.sf.acegisecurity.ui.AbstractProcessingFilter.doFilter&#40;AbstractProcessingFilter.java&#58;333&#41;
                  at net.sf.acegisecurity.util.FilterToBeanProxy.doFilter&#40;FilterToBeanProxy.java&#58;105&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
                  at org.apache.catalina.core.StandardWrapperValve.invoke&#40;StandardWrapperValve.java&#58;214&#41;
                  at org.apache.catalina.core.StandardValveContext.invokeNext&#40;StandardValveContext.java&#58;104&#41;
                  at org.apache.catalina.core.StandardPipeline.invoke&#40;StandardPipeline.java&#58;520&#41;
                  at org.apache.catalina.core.StandardContextValve.invokeInternal&#40;StandardContextValve.java&#58;198&#41;
                  at org.apache.catalina.core.StandardContextValve.invoke&#40;StandardContextValve.java&#58;152&#41;
                  at org.apache.catalina.core.StandardValveContext.invokeNext&#40;StandardValveContext.java&#58;104&#41;
                  at org.apache.catalina.core.StandardPipeline.invoke&#40;StandardPipeline.java&#58;520&#41;
                  at org.apache.catalina.core.StandardHostValve.invoke&#40;StandardHostValve.java&#58;137&#41;
                  at org.apache.catalina.core.StandardValveContext.invokeNext&#40;StandardValveContext.java&#58;104&#41;
                  at org.apache.catalina.valves.ErrorReportValve.invoke&#40;ErrorReportValve.java&#58;117&#41;
                  at org.apache.catalina.core.StandardValveContext.invokeNext&#40;StandardValveContext.java&#58;102&#41;
                  at org.apache.catalina.core.StandardPipeline.invoke&#40;StandardPipeline.java&#58;520&#41;
                  at org.apache.catalina.core.StandardEngineValve.invoke&#40;StandardEngineValve.java&#58;109&#41;
                  at org.apache.catalina.core.StandardValveContext.invokeNext&#40;StandardValveContext.java&#58;104&#41;
                  at org.apache.catalina.core.StandardPipeline.invoke&#40;StandardPipeline.java&#58;520&#41;                                      
                 at org.apache.catalina.core.StandardContextValve.invokeInternal&#40;StandardContextValve.java&#58;198&#41;
                  at org.apache.catalina.core.StandardContextValve.invoke&#40;StandardContextValve.java&#58;152&#41;
                  at org.apache.catalina.core.StandardValveContext.invokeNext&#40;StandardValveContext.java&#58;104&#41;
                  at org.apache.catalina.core.StandardPipeline.invoke&#40;StandardPipeline.java&#58;520&#41;
                  at org.apache.catalina.core.StandardHostValve.invoke&#40;StandardHostValve.java&#58;137&#41;
                  at org.apache.catalina.core.StandardValveContext.invokeNext&#40;StandardValveContext.java&#58;104&#41;
                  at org.apache.catalina.valves.ErrorReportValve.invoke&#40;ErrorReportValve.java&#58;117&#41;
                  at org.apache.catalina.core.StandardValveContext.invokeNext&#40;StandardValveContext.java&#58;102&#41;
                  at org.apache.catalina.core.StandardPipeline.invoke&#40;StandardPipeline.java&#58;520&#41;
                  at org.apache.catalina.core.StandardEngineValve.invoke&#40;StandardEngineValve.java&#58;109&#41;
                  at org.apache.catalina.core.StandardValveContext.invokeNext&#40;StandardValveContext.java&#58;104&#41;
                  at org.apache.catalina.core.StandardPipeline.invoke&#40;StandardPipeline.java&#58;520&#41;
                  at org.apache.catalina.core.ContainerBase.invoke&#40;ContainerBase.java&#58;929&#41;
                  at org.apache.coyote.tomcat5.CoyoteAdapter.service&#40;CoyoteAdapter.java&#58;160&#41;
                  at org.apache.coyote.http11.Http11Processor.process&#40;Http11Processor.java&#58;799&#41;
                  at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection&#40;Http11Protocol.java&#58;705&#41;
                  at org.apache.tomcat.util.net.TcpWorkerThread.runIt&#40;PoolTcpEndpoint.java&#58;577&#41;
                  at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run&#40;ThreadPool.java&#58;683&#41;
                  at java.lang.Thread.run&#40;Thread.java&#58;534&#41;
          Caused by&#58; java.net.SocketException&#58; Connection reset
                  at java.net.SocketInputStream.read&#40;SocketInputStream.java&#58;168&#41;
                  at java.io.BufferedInputStream.fill&#40;BufferedInputStream.java&#58;183&#41;
                  at java.io.BufferedInputStream.read&#40;BufferedInputStream.java&#58;201&#41;
                  at org.postgresql.core.PGStream.ReceiveChar&#40;PGStream.java&#58;241&#41;
                  at org.postgresql.core.v3.QueryExecutorImpl.processResults&#40;QueryExecutorImpl.java&#58;1122&#41;
                  at org.postgresql.core.v3.QueryExecutorImpl.execute&#40;QueryExecutorImpl.java&#58;175&#41;
                  ... 97 more
          CONNECTION ERROR OCCURRED!
          
          &#91;@APPNAME@&#93; ERROR &#91;http-8080-Processor24&#93; JDBCTransaction.begin&#40;48&#41; | Begin failed
          java.sql.SQLException&#58; You can't operate on a closed connection!!!
                  at com.mchange.v2.c3p0.impl.C3P0PooledConnection$ProxyConnectionInvocationHandler.invoke&#40;C3P0PooledConnection.java&#58;724&#41;
                  at com.mchange.v2.c3p0.impl.$Proxy6.getAutoCommit&#40;Unknown Source&#41;
                  at net.sf.hibernate.transaction.JDBCTransaction.begin&#40;JDBCTransaction.java&#58;40&#41;
                  at net.sf.hibernate.transaction.JDBCTransactionFactory.beginTransaction&#40;JDBCTransactionFactory.java&#58;19&#41;
                  at net.sf.hibernate.impl.SessionImpl.beginTransaction&#40;SessionImpl.java&#58;2231&#41;
                  at org.springframework.orm.hibernate.HibernateTransactionManager.doBegin&#40;HibernateTransactionManager.java&#58;407&#41;
                  at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction&#40;AbstractPlatformTransactionManager.java&#58;272&#41;
                  at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary&#40;TransactionAspectSupport.java&#58;202&#41;
                  at org.springframework.transaction.interceptor.TransactionInterceptor.invoke&#40;TransactionInterceptor.java&#58;49&#41;
                  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed&#40;ReflectiveMethodInvocation.java&#58;144&#41;
                  at org.springframework.aop.framework.JdkDynamicAopProxy.invoke&#40;JdkDynamicAopProxy.java&#58;174&#41;
                  at $Proxy11.getMainListings&#40;Unknown Source&#41;
                  at org.appfuse.web.MainController.handleRequest&#40;MainController.java&#58;36&#41;
                  at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle&#40;SimpleControllerHandlerAdapter.java&#58;44&#41;
                  at org.springframework.web.servlet.DispatcherServlet.doDispatch&#40;DispatcherServlet.java&#58;595&#41;
                  at org.springframework.web.servlet.DispatcherServlet.doService&#40;DispatcherServlet.java&#58;543&#41;
                  at org.springframework.web.servlet.FrameworkServlet.serviceWrapper&#40;FrameworkServlet.java&#58;390&#41;
                  at org.springframework.web.servlet.FrameworkServlet.doGet&#40;FrameworkServlet.java&#58;341&#41;
                  at javax.servlet.http.HttpServlet.service&#40;HttpServlet.java&#58;743&#41;
                  at javax.servlet.http.HttpServlet.service&#40;HttpServlet.java&#58;856&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;237&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
                  at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter&#40;PageFilter.java&#58;39&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
                  at org.apache.catalina.core.ApplicationDispatcher.invoke&#40;ApplicationDispatcher.java&#58;704&#41;
                  at org.apache.catalina.core.ApplicationDispatcher.processRequest&#40;ApplicationDispatcher.java&#58;474&#41;
                  at org.apache.catalina.core.ApplicationDispatcher.doForward&#40;ApplicationDispatcher.java&#58;409&#41;
                  at org.apache.catalina.core.ApplicationDispatcher.forward&#40;ApplicationDispatcher.java&#58;312&#41;
                  at org.apache.jasper.runtime.PageContextImpl.doForward&#40;PageContextImpl.java&#58;670&#41;
                  at org.apache.jasper.runtime.PageContextImpl.forward&#40;PageContextImpl.java&#58;637&#41;
                  at org.apache.jsp.index_jsp._jspService&#40;index_jsp.java&#58;43&#41;
                  at org.apache.jasper.runtime.HttpJspBase.service&#40;HttpJspBase.java&#58;94&#41;
                  at javax.servlet.http.HttpServlet.service&#40;HttpServlet.java&#58;856&#41;
                  at org.apache.jasper.servlet.JspServletWrapper.service&#40;JspServletWrapper.java&#58;324&#41;
                  at org.apache.jasper.servlet.JspServlet.serviceJspFile&#40;JspServlet.java&#58;292&#41;
                  at org.apache.jasper.servlet.JspServlet.service&#40;JspServlet.java&#58;236&#41;
                  at javax.servlet.http.HttpServlet.service&#40;HttpServlet.java&#58;856&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;237&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
                  at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage&#40;PageFilter.java&#58;118&#41;
                  at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter&#40;PageFilter.java&#58;52&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
                  at org.appfuse.web.filters.NewMailFilter.doFilter&#40;NewMailFilter.java&#58;41&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
                  at org.appfuse.web.filters.FirstTimeFilter.doFilter&#40;FirstTimeFilter.java&#58;62&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
                  at org.appfuse.web.filters.MessageFilter.doFilter&#40;MessageFilter.java&#58;36&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
                  at net.sf.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke&#40;FilterSecurityInterceptor.java&#58;70&#41;
                  at net.sf.acegisecurity.intercept.web.SecurityEnforcementFilter.doFilter&#40;SecurityEnforcementFilter.java&#58;169&#41;
                  at net.sf.acegisecurity.util.FilterToBeanProxy.doFilter&#40;FilterToBeanProxy.java&#58;105&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
                  at net.sf.acegisecurity.ui.AbstractIntegrationFilter.doFilter&#40;AbstractIntegrationFilter.java&#58;170&#41;
                  at net.sf.acegisecurity.util.FilterToBeanProxy.doFilter&#40;FilterToBeanProxy.java&#58;105&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
                  at net.sf.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter&#40;BasicProcessingFilter.java&#58;199&#41;
                  at net.sf.acegisecurity.util.FilterToBeanProxy.doFilter&#40;FilterToBeanProxy.java&#58;105&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
                  at net.sf.acegisecurity.ui.AbstractProcessingFilter.doFilter&#40;AbstractProcessingFilter.java&#58;333&#41;
                  at net.sf.acegisecurity.util.FilterToBeanProxy.doFilter&#40;FilterToBeanProxy.java&#58;105&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
                  at org.apache.catalina.core.StandardWrapperValve.invoke&#40;StandardWrapperValve.java&#58;214&#41;
                  at org.apache.catalina.core.StandardValveContext.invokeNext&#40;StandardValveContext.java&#58;104&#41;
                  at org.apache.catalina.core.StandardPipeline.invoke&#40;StandardPipeline.java&#58;520&#41;
                  at org.apache.catalina.core.StandardContextValve.invokeInternal&#40;StandardContextValve.java&#58;198&#41;
                  at org.apache.catalina.core.StandardContextValve.invoke&#40;StandardContextValve.java&#58;152&#41;
                  at org.apache.catalina.core.StandardValveContext.invokeNext&#40;StandardValveContext.java&#58;104&#41;
                  at org.apache.catalina.core.StandardPipeline.invoke&#40;StandardPipeline.java&#58;520&#41;
                  at org.apache.catalina.core.StandardHostValve.invoke&#40;StandardHostValve.java&#58;137&#41;
                  at org.apache.catalina.core.StandardValveContext.invokeNext&#40;StandardValveContext.java&#58;104&#41;
                  at org.apache.catalina.valves.ErrorReportValve.invoke&#40;ErrorReportValve.java&#58;117&#41;
                  at org.apache.catalina.core.StandardValveContext.invokeNext&#40;StandardValveContext.java&#58;102&#41;
                  at org.apache.catalina.core.StandardPipeline.invoke&#40;StandardPipeline.java&#58;520&#41;
                  at org.apache.catalina.core.StandardEngineValve.invoke&#40;StandardEngineValve.java&#58;109&#41;
                  at org.apache.catalina.core.StandardValveContext.invokeNext&#40;StandardValveContext.java&#58;104&#41;
                  at org.apache.catalina.core.StandardPipeline.invoke&#40;StandardPipeline.java&#58;520&#41;
                  at org.apache.catalina.core.ContainerBase.invoke&#40;ContainerBase.java&#58;929&#41;
                  at org.apache.coyote.tomcat5.CoyoteAdapter.service&#40;CoyoteAdapter.java&#58;160&#41;
                  at org.apache.coyote.http11.Http11Processor.process&#40;Http11Processor.java&#58;799&#41;
                  at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection&#40;Http11Protocol.java&#58;705&#41;
                  at org.apache.tomcat.util.net.TcpWorkerThread.runIt&#40;PoolTcpEndpoint.java&#58;577&#41;
                  at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run&#40;ThreadPool.java&#58;683&#41;
                  at java.lang.Thread.run&#40;Thread.java&#58;534&#41;                
                                                                    
          @APPNAME@&#93; ERROR &#91;http-8080-Processor24&#93; FrameworkServlet.serviceWrapper&#40;411&#41; | Could not complete request
          org.springframework.transaction.CannotCreateTransactionException&#58; Could not create Hibernate transaction; nested exception is net.sf.hibernate.TransactionException&#58; Begin failed with SQL exception&#58;
          net.sf.hibernate.TransactionException&#58; Begin failed with SQL exception&#58;
                  at net.sf.hibernate.transaction.JDBCTransaction.begin&#40;JDBCTransaction.java&#58;49&#41;
                  at net.sf.hibernate.transaction.JDBCTransactionFactory.beginTransaction&#40;JDBCTransactionFactory.java&#58;19&#41;
                  at net.sf.hibernate.impl.SessionImpl.beginTransaction&#40;SessionImpl.java&#58;2231&#41;
                  at org.springframework.orm.hibernate.HibernateTransactionManager.doBegin&#40;HibernateTransactionManager.java&#58;407&#41;
                  at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction&#40;AbstractPlatformTransactionManager.java&#58;272&#41;
                  at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary&#40;TransactionAspectSupport.java&#58;202&#41;
                  at org.springframework.transaction.interceptor.TransactionInterceptor.invoke&#40;TransactionInterceptor.java&#58;49&#41;
                  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed&#40;ReflectiveMethodInvocation.java&#58;144&#41;
                  at org.springframework.aop.framework.JdkDynamicAopProxy.invoke&#40;JdkDynamicAopProxy.java&#58;174&#41;
                  at $Proxy11.getMainListings&#40;Unknown Source&#41;
                  at org.appfuse.web.MainController.handleRequest&#40;MainController.java&#58;36&#41;
                  at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle&#40;SimpleControllerHandlerAdapter.java&#58;44&#41;
                  at org.springframework.web.servlet.DispatcherServlet.doDispatch&#40;DispatcherServlet.java&#58;595&#41;
                  at org.springframework.web.servlet.DispatcherServlet.doService&#40;DispatcherServlet.java&#58;543&#41;
                  at org.springframework.web.servlet.FrameworkServlet.serviceWrapper&#40;FrameworkServlet.java&#58;390&#41;
                  at org.springframework.web.servlet.FrameworkServlet.doGet&#40;FrameworkServlet.java&#58;341&#41;
                  at javax.servlet.http.HttpServlet.service&#40;HttpServlet.java&#58;743&#41;
                  at javax.servlet.http.HttpServlet.service&#40;HttpServlet.java&#58;856&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;237&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
                  at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter&#40;PageFilter.java&#58;39&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
                  at org.apache.catalina.core.ApplicationDispatcher.invoke&#40;ApplicationDispatcher.java&#58;704&#41;
                  at org.apache.catalina.core.ApplicationDispatcher.processRequest&#40;ApplicationDispatcher.java&#58;474&#41;
                  at org.apache.catalina.core.ApplicationDispatcher.doForward&#40;ApplicationDispatcher.java&#58;409&#41;
                  at org.apache.catalina.core.ApplicationDispatcher.forward&#40;ApplicationDispatcher.java&#58;312&#41;
                  at org.apache.jasper.runtime.PageContextImpl.doForward&#40;PageContextImpl.java&#58;670&#41;
                  at org.apache.jasper.runtime.PageContextImpl.forward&#40;PageContextImpl.java&#58;637&#41;
                  at org.apache.jsp.index_jsp._jspService&#40;index_jsp.java&#58;43&#41;
                  at org.apache.jasper.runtime.HttpJspBase.service&#40;HttpJspBase.java&#58;94&#41;
                  at javax.servlet.http.HttpServlet.service&#40;HttpServlet.java&#58;856&#41;
                  at org.apache.jasper.servlet.JspServletWrapper.service&#40;JspServletWrapper.java&#58;324&#41;
                  at org.apache.jasper.servlet.JspServlet.serviceJspFile&#40;JspServlet.java&#58;292&#41;
                  at org.apache.jasper.servlet.JspServlet.service&#40;JspServlet.java&#58;236&#41;
                  at javax.servlet.http.HttpServlet.service&#40;HttpServlet.java&#58;856&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;237&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
                  at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage&#40;PageFilter.java&#58;118&#41;
                  at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter&#40;PageFilter.java&#58;52&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
                  at org.appfuse.web.filters.NewMailFilter.doFilter&#40;NewMailFilter.java&#58;41&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
                  at org.appfuse.web.filters.FirstTimeFilter.doFilter&#40;FirstTimeFilter.java&#58;62&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
                  at org.appfuse.web.filters.MessageFilter.doFilter&#40;MessageFilter.java&#58;36&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
                  at net.sf.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke&#40;FilterSecurityInterceptor.java&#58;70&#41;
                  at net.sf.acegisecurity.intercept.web.SecurityEnforcementFilter.doFilter&#40;SecurityEnforcementFilter.java&#58;169&#41;
                  at net.sf.acegisecurity.util.FilterToBeanProxy.doFilter&#40;FilterToBeanProxy.java&#58;105&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
                  at net.sf.acegisecurity.ui.AbstractIntegrationFilter.doFilter&#40;AbstractIntegrationFilter.java&#58;170&#41;
                  at net.sf.acegisecurity.util.FilterToBeanProxy.doFilter&#40;FilterToBeanProxy.java&#58;105&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
                  at net.sf.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter&#40;BasicProcessingFilter.java&#58;199&#41;
                  at net.sf.acegisecurity.util.FilterToBeanProxy.doFilter&#40;FilterToBeanProxy.java&#58;105&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
                  at net.sf.acegisecurity.ui.AbstractProcessingFilter.doFilter&#40;AbstractProcessingFilter.java&#58;333&#41;
                  at net.sf.acegisecurity.util.FilterToBeanProxy.doFilter&#40;FilterToBeanProxy.java&#58;105&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;186&#41;
                  at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;157&#41;
                  at org.apache.catalina.core.StandardWrapperValve.invoke&#40;StandardWrapperValve.java&#58;214&#41;
                  at org.apache.catalina.core.StandardValveContext.invokeNext&#40;StandardValveContext.java&#58;104&#41;
                  at org.apache.catalina.core.StandardPipeline.invoke&#40;StandardPipeline.java&#58;520&#41;
                  at org.apache.catalina.core.StandardContextValve.invokeInternal&#40;StandardContextValve.java&#58;198&#41;
                  at org.apache.catalina.core.StandardContextValve.invoke&#40;StandardContextValve.java&#58;152&#41;
                  at org.apache.catalina.core.StandardValveContext.invokeNext&#40;StandardValveContext.java&#58;104&#41;
                  at org.apache.catalina.core.StandardPipeline.invoke&#40;StandardPipeline.java&#58;520&#41;
                  at org.apache.catalina.core.StandardHostValve.invoke&#40;StandardHostValve.java&#58;137&#41;
                  at org.apache.catalina.core.StandardValveContext.invokeNext&#40;StandardValveContext.java&#58;104&#41;
                  at org.apache.catalina.valves.ErrorReportValve.invoke&#40;ErrorReportValve.java&#58;117&#41;
                  at org.apache.catalina.core.StandardValveContext.invokeNext&#40;StandardValveContext.java&#58;102&#41;
                  at org.apache.catalina.core.StandardPipeline.invoke&#40;StandardPipeline.java&#58;520&#41;
                  at org.apache.catalina.core.StandardEngineValve.invoke&#40;StandardEngineValve.java&#58;109&#41;
                  at org.apache.catalina.core.StandardValveContext.invokeNext&#40;StandardValveContext.java&#58;104&#41;
                  at org.apache.catalina.core.StandardPipeline.invoke&#40;StandardPipeline.java&#58;520&#41;
                  at org.apache.catalina.core.ContainerBase.invoke&#40;ContainerBase.java&#58;929&#41;
                  at org.apache.coyote.tomcat5.CoyoteAdapter.service&#40;CoyoteAdapter.java&#58;160&#41;
                  at org.apache.coyote.http11.Http11Processor.process&#40;Http11Processor.java&#58;799&#41;
                  at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection&#40;Http11Protocol.java&#58;705&#41;
                  at org.apache.tomcat.util.net.TcpWorkerThread.runIt&#40;PoolTcpEndpoint.java&#58;577&#41;
                  at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run&#40;ThreadPool.java&#58;683&#41;
                  at java.lang.Thread.run&#40;Thread.java&#58;534&#41;
          Caused by&#58; java.sql.SQLException&#58; You can't operate on a closed connection!!!                                                                          
            at com.mchange.v2.c3p0.impl.C3P0PooledConnection$ProxyConnectionInvocationHandler.invoke&#40;C3P0PooledConnection.java&#58;724&#41;
                  at com.mchange.v2.c3p0.impl.$Proxy6.getAutoCommit&#40;Unknown Source&#41;
                  at net.sf.hibernate.transaction.JDBCTransaction.begin&#40;JDBCTransaction.java&#58;40&#41;
                  ... 89 more

          Comment


          • #6
            Then the error is somewhere in the postgres driver or configuration. Try to see in what context does your error occurs.

            Comment


            • #7
              It could also be a network issue. Sometimes firewalls or other infrastructure components drop inactive connections - they don't know you have an open connection unless there is traffic flowing. If your live connections is idle for too long it might get dropped and the next time you try to use it you get a connection not active error. I know Oracle has configuration options where the network listener will send some traffic on all open connections to prevent this kind of problems. Not sure about Postgres.

              Comment


              • #8
                Originally posted by trisberg
                It could also be a network issue. Sometimes firewalls or other infrastructure components drop inactive connections - they don't know you have an open connection unless there is traffic flowing. If your live connections is idle for too long it might get dropped and the next time you try to use it you get a connection not active error. I know Oracle has configuration options where the network listener will send some traffic on all open connections to prevent this kind of problems. Not sure about Postgres.
                That's very interesting, I have a feeling that this is the problem. Unfortunately, I changed two variables when I moved from MySQL to Postgres. The MySQL db was located on the same machine as Tomcat (for testing), but the Postgres db is located on a different network now (where the site will eventually go). I bet I might still be getting this error if I was using MySQL on the network the Postgres db is running from. Eventually, the site will be put on the same network, but I wonder if even that would fix this problem? I'm kind of wishing now that I didn't piss off the sysadmin of the network that the Postgres db is installed on yesterday...

                edit: The initial pool size is 3 for C3P0, which I believe by no coincidence is why after refreshing the site in the browser 3 times, it loaded properly.

                Comment


                • #9
                  According to the C3P0 documentation:
                  Note that for many applications, high performance is more important than the risk of an occasional database exception. In its default configuration, c3p0 does no Connection testing at all. Setting a fairly long idleConnectionTestPeriod, and not testing on checkout and check-in at all is an excellent, high-performance approach.
                  idleConnectionTestPeriod sounds like somebody I should be setting, but I wonder how long fairly long means?

                  Comment


                  • #10
                    IMO you should first investigate your network configuration and then worry about optimizations. Your user will remember the ugly screen and not that we waited another second to see the page.

                    Comment


                    • #11
                      I talked to the sysadmin and he said the network has a short TCP timeout so there's 2 C3P0 properties I'm looking at to get around this:

                      maxIdleTime & idleConnectionTestPeriod. I could use the maxIdleTime to just say if the connection is idle for 15 minutes, then discard it. I think that would eliminate the problem, but I'd rather not get rid of them in case of a surge of users after some dead time and there's no connections available. So that's why I was looking at the idleConnectionTestPeriod, to test the connections every 10 minutes or so, so they won't break and the Exception won't be thrown. This is all theoretical until I see if the exception happens again or not.

                      Comment


                      • #12
                        In this case adjust idleConnectionTestPeriod to be shorter then the TCP timeout and if it works (it should) start from there increasing the value. After all if you say the scenario is going to be changed I wouldn't worry about optimizing the network configuration at this point.

                        Comment


                        • #13
                          That's basically what I'm doing now. I set the idleConnectionTestPeriod to 10 minutes and haven't gotten the exception since then so I'm happy to have this solved for the interim until the server gets moved.

                          Comment


                          • #14
                            Switching from DBCP to C3P0 worked for us also

                            We were getting mysterious connection closed exceptions from PostgreSQL with our application. Switching from DBCP to C3P0 eliminated them. Thanks for the info in this thread, very helpful.

                            -Walter Gillett

                            Comment

                            Working...
                            X