activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Roland Thomas Lichti <roland.lic...@telefonica.de>
Subject Re: MasterSlave | Spring + Camel + ActiveMQ + C3P0 + Oracle
Date Fri, 05 Mar 2010 14:47:16 GMT
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.lichti@telefonica.de
http://www.telefonica.de

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



Mime
View raw message