If you look at the stacktrace, you'll see weblogic in there swallowing
your connection with its own wrapper. This is a "feature" of Weblogic
and thus probably nothing that anyone on this list can help you with.
However, my guess is that weblogic is expecting you to request
connections through its pool, and Cayenne is trying to use its own
pool and request connections directly (by default, anyway). It should
be fairly easy to get Cayenne to use the Weblogic connection pool (see
some of the mailing list archive entries on changing the default
connection pool), or to disable weblogic's oracle connection pool.
Cris
On 5/2/05, Sami Mohammed <SMOHAMME..ndependenthealth.com> wrote:
> Hi all,
>
> I am getting the following error, when i test on WSAD 5.1 its work fine, when i deployed same EAR file on Weblogic 8.1 with the same oracle drive and same configuration.
> i am getting error in weblogic server see below.
>
> java.sql.SQLException: Closed Connection at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269) at oracle.jdbc.driver.OracleConnection.privatePrepareStatement(OracleConnection.java:945) at oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:852) at weblogic.jdbc.common.internal..ConnectionEnv.makeStatement(ConnectionEnv.java:1022) at weblogic.jdbc.common.internal.ConnectionEnv.getCachedStatement(ConnectionEnv.java:855) at weblogic.jdbc.common.internal.ConnectionEnv.getCachedStatement(ConnectionEnv.java:794) at weblogic.jdbc.wrapper.Connection.prepareStatement(Connection..java:327) at org.objectstyle.cayenne.dba.oracle.OracleSelectTranslator.createStatement(OracleSelectTranslator.java:132) at org.objectstyle.cayenne.access.DataNode.runSelect(DataNode.java:385) at org.objectstyle.cayenne.access.DataNode.performQueries(DataNode.java:350) at org.objectstyle.cayenne.access.DataDomain.performQueries(DataDomain.java:654) at org.objectstyle.cayenne.access.DataContext.performQueries(DataContext.java:1373) at org.objectstyle.cayenne.access.Transaction.performQueries(Transaction.java:179) at org.objectstyle.cayenne.access.DataContext.performQueries(DataContext.java:1331) at org.objectstyle.cayenne.access.DataContext.performQuery(DataContext.java:1587) at org.objectstyle.cayenne.access.DataContext.performQuery(DataContext.java:1450) at com.independenthealth.edwdma.admin.actions.LoginAction.execute(LoginAction.java:74) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274) at org.apache.struts..action.ActionServlet.process(ActionServlet.java:1482) at org.apache.struts..action.ActionServlet.doPost(ActionServlet.java:525) at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) at javax.servlet.http.HttpServlet..service(HttpServlet.java:853) at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:971) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:402) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:305) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6350) at weblogic.security.acl.internal..AuthenticatedSubject.doAs(AuthenticatedSubject.java:317) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:118) at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3635) at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2585) at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:197) at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:170)
>
> CONFIDENTIALITY NOTICE. This e-mail and attachments, if any, may contain confidential information which is privileged and protected from disclosure by Federal and State
> confidentiality laws rules and regulations. This e-mail and attachments, if any, are intended for the designated addressee only. If you are not the designated addressee, you
> are hereby notified that any disclosure, copying, or distribution of this e-mail and its attachments, if any, may be unlawful and may subject you to legal consequences. If you
> have received this e-mail and attachments in error, please contact Independent Health immediately at (716) 631-3001 and delete the e-mail and its attachments from your
> computer. Thank you for your attention
>
>
This archive was generated by hypermail 2.0.0 : Mon May 02 2005 - 11:30:43 EDT