Geronimo
  1. Geronimo
  2. GERONIMO-6508

Connection automatically closed in EJB environment

    Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: 3.0.0
    • Fix Version/s: None
    • Component/s: databases
    • Security Level: public (Regular issues)
    • Labels:
      None
    • Environment:

      Windows 7,Java1.7,Geronimo 3.0,Postgresql 9.2

      Description

      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)

        Activity

        There are no comments yet on this issue.

          People

          • Assignee:
            Unassigned
            Reporter:
            Rajasekhar Reddy.R
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:

              Development