Hi Cris
as you told me to disable the weblogic's oracle connection pool, but i am getting the following error.
pls if u have any link related to this issue.
and how to to get Cayenne to use the Weblogic connection pool ?
java.sql.SQLException: Cannot obtain connection: driverURL = jdbc:weblogic:pool:EDWD Pool, props = {enableTwoPhaseCommit=false, jdbcTxDataSource=true, connectionPoolID=EDWD Pool, dataSourceName=EDWDDataSource} at weblogic.jdbc.jts.Driver.wrapAndThrowSQLException(Driver.java:390) at weblogic.jdbc.jts.Driver.getNonTxConnection(Driver.java:448) at weblogic.jdbc.jts.Driver.connect(Driver.java:138) at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:305) at org.objectstyle.cayenne..access.DataNode.performQueries(DataNode.java:313) 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)
Thanks
sami
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
>>> cris.danilu..mail.com 05/02/05 11:30AM >>>
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 - 12:18:26 EDT