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)

Reply via email to