juhasiltanen schrieb:
> Hi,
>
> I am trying to get the MasterSlave configuration to work properly using JDBC
> persistence with C3P0 Connection pool with my Oracle DataSource.
>   
Do you know that the oracle driver does contain a connection pool by
itself? We were using:

<bean id="oracle-ds" class="oracle.jdbc.pool.OracleDataSource"
destroy-method="close">
          <property name="connectionCachingEnabled" value="true"/>
          <property name="connectionCacheName" value="ActiveMQCache"/>
         
          <property
name="URL"><value>jdbc:oracle:oci:@DATABASE</value></property>
          <property name="user" value="USER"/>
          <property name="password" value="IDONTTELLIT"/>
         
          <property name="connectionCacheProperties">
                  <props>
                          <prop key="MinLimit">2</prop>
                          <prop key="MaxLimit">10</prop>
                          <prop key="InitialLimit">2</prop>
                          <prop key="InactivityTimeout">300</prop>
                          <prop key="ConnectionWaitTimeout">120</prop>
                  </props>
          </property>
  </bean>

without problems :-) (until we switched to kahaDB).

bye,
    Roland

-- 
Roland Thomas Lichti
IT Application Manager

Telefónica o2 Germany GmbH & Co. OHG
Hülshorstweg 30, 33415 Verl
t: +49 5246 80 1121, f: +49 5246 80 2121
m: +49 160 98949570
roland.lic...@telefonica.de
http://www.telefonica.de

Bitte finden Sie hier die
handelsrechtlichen Pflichtangaben: http://www.telefonica.de/pflichtangaben.html


Reply via email to