This one time, at band camp, Hinken, Christian said:

HC>I want to use the JDBC Connection pooling of the oracle class. Up to now, my
HC>database definition is the following:
HC>
HC><database name="Fortress" engine="oracle" >
HC>    <data-source class-name="oracle.jdbc.pool.OracleConnectionCacheImpl">
HC>        <params URL="jdbc:oracle:thin:@***********:1521:****"
HC>        user="****" password="*******"/>
HC>    </data-source>
HC>  <mapping href="castor_mapping.xml" />
HC></database>
HC>
HC>Do I have to add some parameters to really enable a connection pooling?
HC>Something like the initial count of connections, the maximum count and the
HC>increment?
HC>
HC>In the examples for the Oracle JDBC driver I found on the web, these
HC>parameters are needed.

Christian,

I've used the following sucessfully: 

<database name="test" engine="oracle" >
    <driver url="jdbc:oracle:thin:@dbsrv3:1521:brnzorc" 
            class-name="oracle.jdbc.pool.OracleConnectionCacheImpl">
      <param name="user" value="bsnyder" />
      <param name="password" value="bsnyder" />
      <param name="minLimit" value="2" />
      <param name="maxLimit" value="10" />
      <param name="cacheScheme" value="OracleConnectionCacheImpl.DYNAMIC_SCHEME" />
      <param name="statementCacheSize" value="5" />
    </driver>
    <mapping href="mapping.xml" />
</database>

Bruce 
-- 
perl -e 'print unpack("u30","<0G)[EMAIL PROTECTED]&5R\"F9E<G)E=\$\!F<FEI+F-O;0\`\`");'

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

Reply via email to