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
[email protected]
http://www.telefonica.de
Bitte finden Sie hier die
handelsrechtlichen Pflichtangaben: http://www.telefonica.de/pflichtangaben.html
