The following bug has been logged on the website:
Bug reference: 10545
Logged by: Suraj Sunar
Email address: surbhu06@gmail.com
PostgreSQL version: 9.1.13
Operating system: Window/linux
Description:
Dear Team,
We are migrating database from oracle to postgres and its all done by now.
But we are facing problem after multiple logins.
All transaction is working fine but suddenly the connection get closed.
Kindly help in the matter.
17:11:40,424 ERROR
[org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/bvm].[faces]]
Servlet.service() for servlet faces threw exception:
org.postgresql.util.PSQLException: This connection has been closed.
at
org.postgresql.jdbc2.AbstractJdbc2Connection.checkClosed(AbstractJdbc2Connection.java:714)
[:]
at
org.postgresql.jdbc3.AbstractJdbc3Connection.prepareStatement(AbstractJdbc3Connection.java:274)
[:]
at
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.doPrepareStatement(BaseWrapperManagedConnection.java:467)
[:6.1.0.Final]
at
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:462)
[:6.1.0.Final]
at
org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:253)
[:6.1.0.Final]
at
com.ultimatix.framework.jsf.util.UserProfile.registerProfile(UserProfile.java:55)
[:]
at
com.ultimatix.framework.jsf.util.UserBean.validateLoginPage(UserBean.java:560)
[:]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [:1.6.0_22]
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) [:1.6.0_22]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
[:1.6.0_22]
at java.lang.reflect.Method.invoke(Unknown Source) [:1.6.0_22]
at
org.apache.myfaces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:132)
[:1.1.5]
at
org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:61)
[:1.1.5]
at javax.faces.component.UICommand.broadcast(UICommand.java:109) [:1.1.5]
at
org.ajax4jsf.framework.ajax.AjaxViewRoot.processEvents(AjaxViewRoot.java:180)
[:1.1.1]
at
org.ajax4jsf.framework.ajax.AjaxViewRoot.broadcastEvents(AjaxViewRoot.java:158)
[:1.1.1]
at
org.ajax4jsf.framework.ajax.AjaxViewRoot.processApplication(AjaxViewRoot.java:346)
[:1.1.1]