Patrice, Bruce,
whilst it is true that I have been working on an improvement for handling parameters
for database connections, this simply would not apply to this case
as Patrice is using the <driver> element whilst I am working on the <data-source>
element.
Patrice, can I ask you a couple of questions about OracleConnectionCacheImpl itself ?
Is this a class that implements the javax.sql.DataSource
interface ? Or even better, can you please point me to online docs ?
Werner
On Wed, 3 Mar 2004 22:20:49 -0700 (MST), Bruce Snyder wrote:
>This one time, at band camp, Patrice Fleurier said:
>
>PF>The Oracle connections pool is not active with Castor !
>PF>
>PF>Without Castor the java code is:
>PF>OracleConnectionCacheImpl ocacheimpl = new OracleConnectionCacheImpl();
>PF>ocacheimpl.setURL("jdbc:oracle:thin:@myServer:1521:myBase");
>PF>ocacheimpl.setUser("user");
>PF>ocacheimpl.setPassword("pwd");
>PF>ocacheimpl.setMinLimit(5);
>PF>ocacheimpl.setMaxLimit(10);
>PF>ocacheimpl.setCacheScheme(OracleConnectionCacheImpl.DYNAMIC_SCHEME);
>PF>
>PF>Connection conn = ocacheimpl.getConnection();
>PF> /* HERE THE POOL IS STRATED WITH 5 ORACLE CONNECTIONS */
>PF> /* MY ORACLE SESSION IS ACTIVE */
>PF> /* IM WORKING */
>PF>conn.close();
>PF>/* MY SESSION IS CLOSED */
>PF>/* THE POOL IS ACTIVE WITH 5 ORACLE CONNECTIONS */
>PF>ocacheimpl.close();
>PF>/* THE POOL IS CLOSE */
>PF>
>PF>
>PF>With Castor the code is:
>PF>
>PF>The xml file:
>PF><?xml version="1.0"?>
>PF><database name="myBase" engine="oracle" >
>PF> <driver url="jdbc:oracle:thin:@myServer:1521:myBase"
>PF> class-name="oracle.jdbc.pool.OracleConnectionCacheImpl">
>PF> <param name="user" value="user" />
>PF> <param name="password" value="pwd" />
>PF> <param name="minLimit" value="5" />
>PF> <param name="maxLimit" value="10" />
>PF> <param name="cacheScheme"
>PF>value="OracleConnectionCacheImpl.DYNAMIC_SCHEME" />
>PF> </driver>
>PF> <mapping href="Mapping.xml" />
>PF></database>
>...
>PF>Conclusion :
>PF>In my Castor sample, the Oracle connections pooling is never active.
>PF>For each begin (Oracle session), there is one Oracle physical
>PF>connection.
>PF>
>PF>Why?
>PF>Where is my error?
>
>Patrice,
>
>The datbase descriptor above will not currently work properly to
>initalize the Oracle JDBC connection pool. The reason for this is
>simple, Castor has no prior knowledge of the variables attempting
>to be set so it just ignores them. Werner was working on a fix for
>this exact problem. I wonder what the status of this is? Werner,
>could you comment on this?
>
>Bruce
>--
>perl -e 'print unpack("u30","<0G)[EMAIL PROTECTED]&5R\"F9E<G)E=\$\!F<FEI+F-O;0\`\`");'
>
>The Castor Project
>http://www.castor.org/
>
>Apache Geronimo
>http://incubator.apache.org/projects/geronimo.html
>
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
