Re: [castor-dev] Weblogic Connection Pool Configuration

[Cesar Ogalde]

Coutts, Danelle escribi�::

I did create the connect pool, testpool, in the weblogic console -

I have used the connection pool using straight sql but am now trying to use
it in castor.

-----Original Message-----
From: Cesar Ogalde [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 10:27 AM
To: [EMAIL PROTECTED]
Subject: Re: [castor-dev] Weblogic Connection Pool Configuration


Coutts, Danelle escribi�::

I am trying to use weblogic connection pool with castor but can't seem
to get the configuration right.


I first got the castor working with direct access to the database my
configuration was

<database name="test" engine="oracle">

<driver class-name="weblogic.jdbc.oci.Driver"
url="jdbc:weblogic:oracle:test">

<param name="user" value="test" />

<param name="password" value="tester" />

</driver>



Then I switched the configuration to point to a weblogic connection pool

<database name="testpool" engine="oracle">

<driver class-name="weblogic.jdbc.pool.Driver"
url="jdbc:weblogic:oracle:testpool">

<param name="user" value="test" />

<param name="password" value="tester" />

</driver>



Now I recieve the following error:

Exception: org.exolab.castor.jdo.PersistenceException: Nested error:
java.sql.SqlException: ORA-24327: need explicit attach before authenticating a user

Any help would be appreciated.

Thanks

add the pool for console in weblogic wizar it easy

The jndi element specifies the JDBC 2.0 DataSource for obtaining new connections to the database server through JNDI lookup. The JNDI environment naming context (ENC) is used to obtain a suitable DataSource..

When running inside a J2EE application server, this is the preferred method for obtaining database connections. It enables the J2EE application server to configure the connection, maintain a connection pool, and manage distributed transactions.

For example, to specify a J2EE DataSource, use:

<jndi name="java:comp/env/jdbc/mydb" />


example:
note: compatible with DataSource


<database name="databaseName" engine="oracle">
<jndi name="standarJndiWeblogic PoolConnection[test]" />
</database>






--
Cesar Ogalde Hernandez

Desarrollador

Exe Ingenier�a & Software Ltda.
Europa 1935, Providencia Santiago - Chile
Tel�fono (562) 2049366
Fax (562) 2040897
www.exe.cl

----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev