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> /* I�M 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
