[jira] [Updated] (GERONIMO-6508) Connection automatically closed in EJB environment

["Rajasekhar Reddy.R (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/GERONIMO-6508?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rajasekhar Reddy.R updated GERONIMO-6508:
-----------------------------------------

    Fix Version/s:     (was: 3.0.0)

> 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
>
> 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)