Rajasekhar Reddy.R created GERONIMO-6508:
--------------------------------------------
Summary: Connection automatically closed in EJB environment
Key: GERONIMO-6508
URL: https://issues.apache.org/jira/browse/GERONIMO-6508
Project: Geronimo
Issue Type: Bug
Security Level: public (Regular issues)
Components: databases
Affects Versions: 3.0.0
Environment: Windows 7,Java1.7,Geronimo 3.0,Postgresql 9.2
Reporter: Rajasekhar Reddy.R
Fix For: 3.0.0
Based on the requirement we are keeping connections in list in one jvm where we
create prepared statements for those connections.In Ejb environment(another
jvm) we are trying to use those prepared statements later we are closing
connections manually.when i restart the app server it is executing
successfully.But,without restarting the server we are trying to access
connections (previous connections are closed and again creating new
connections) getting below error. any help would be appreciated.
Caused by: org.postgresql.util.PSQLException: This connection has been closed.
at
org.postgresql.jdbc2.AbstractJdbc2Connection.checkClosed(AbstractJdbc2Connection.java:822)
at
org.postgresql.jdbc2.AbstractJdbc2Connection.getAutoCommit(AbstractJdbc2Connection.java:788)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:536)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:302)
--
This message was sent by Atlassian JIRA
(v6.1#6144)