Re: [castor-dev] Problem with connections pooling for Oracle

[Patrice Fleurier]

Werner, You can acces to the Oracle Online Doc at : SQLJ & JDBC The PDF Format : http://download-uk.oracle.com/docs/cd/A91202_01/901_doc/java.901/a90211.pdf     For your question : oracle.jdbc.pool.OracleConnectionCacheImpl implements ����� oracle.jdbc.pool.OracleConnectionCache AND oracle.jdbc.pool.OracleConnectionCache implements ����� sql.javax.DataSource   Patrice     -----Message d'origine----- De : Werner Guttmann [mailto:[EMAIL PROTECTED] Envoy� : jeudi 4 mars 2004 09:51 � : Bruce Snyder; [EMAIL PROTECTED] Objet : Re: [castor-dev] Problem with connections pooling for Oracle     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=""> >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="" /> >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   --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.610 / Virus Database: 390 - Release Date: 03/03/2004 � --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.610 / Virus Database: 390 - Release Date: 03/03/2004