You need to include pooled-location="jdbc/OraclePooledDS" and look up
"jdbc/OraclePooledDS" in the EJB or servlet.
>From: Ugur Karakaya <[EMAIL PROTECTED]>
>Reply-To: Orion-Interest <[EMAIL PROTECTED]>
>To: Orion-Interest <[EMAIL PROTECTED]>
>Subject: connection pooling
>Date: Wed, 14 Mar 2001 22:13:57 +0200
>
>
>
> i explained datasource (data-source.xml) for oracle to use
>connection pooling with orion;
>
> <data-source
> name="Oracle"
> location="jdbc/OracleCoreDS"
> xa-location="jdbc/xa/OracleXADS"
> ejb-location="jdbc/OracleDS"
> connection-driver="oracle.jdbc.driver.OracleDriver"
> username="scott"
> password="tiger"
> url="jdbc:oracle:thin:@myserver:1521:mysid"
> inactivity-timeout="30"
> max-connections="10"
> min-connections="5"
> class="com.evermind.sql.DriverManagerDataSource"
> />
>
>
>
> from servlet;
> InitialContext ctx = new InitialContext();
> javax.sql.DataSource ds = (javax.sql.DataSource)
>ctx.lookup("jdbc/OracleDS");
> Connection conn = ds.getConnection();
>
>
>
> but it open only one connection.
>
> what is my wrong ?
>
>
>
> thanks
>
>
>
> ugur
>
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com