It's hard to tell what's going on from the trace you pasted. It really
looks like the driver you are using is the Weblogic pool driver
(jdbc:weblogic:pool:EDWD") yet you said you disabled the pool.
Thus you disabled the pool, but are still attempting to retrieve
connections from it. Not quite what I had in mind :) Either disable
the pool and use Cayenne's, or PROPERLY use the weblogic pool with
Cayenne. Doing so requires using a DataSource for your Datanode.
To use the pool properly, you first of all need to have a JDBC
DataSource created in the Weblogic Administration Console (looks like
you do - called EDWD). Then, go to the Datanode in the Cayenne modeler
and select "JNDIDataSourceFactory" as the DataSource Factory. Under
JNDI Location, enter the JNDI name you use to retrieve connections --
again, probably EDWD.
If you want to use your own pool and not the weblogic pool (my guess
is this is NOT what you want to do), then your DB URL in the modeler
should look like this:
jdbc:oracle:thin..ostname:1521:schema
Cris
On 5/2/05, Sami Mohammed <SMOHAMME..ndependenthealth.com> wrote:
> 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)
This archive was generated by hypermail 2.0.0 : Mon May 02 2005 - 16:38:27 EDT