Re: SQLException

From: Sami Mohammed (SMOHAMME..ndependenthealth.com)
Date: Mon May 02 2005 - 12:18:00 EDT

  • Next message: sastan: "RE: How to use Enums"

    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