activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From osian <os...@osian.me.uk>
Subject Re: Oracle Persistant Journal
Date Mon, 21 Aug 2006 15:29:15 GMT

Is the JDBC pool something that is set on the BasicDataSource?  

Also, I'm unsure about what you mean by the nr or connections required
depends on the nr of connections I have.

Thanks in advance


James.Strachan wrote:
> 
> Can't you use the JDBC pool to limit the number of connections?
> 
> FWIW the number of connections required depends on how many
> connections you have.
> 
> On 8/21/06, osian <osian@osian.me.uk> wrote:
>>
>> ActiveMQ - 4.0.1
>> Oracle - 9
>> Java - 1.4_06
>>
>> I have been trying to work out the configuration to get ActiveMQ running
>> with Oracle.  We have tried many configurations, but the number of
>> connections that get created runs very high, and not before long, the
>> number
>> of connections has been exceeded, i.e. the default 200.  Is there any
>> reason
>> why activemq needs this many connections? or is there something wrong
>> with
>> my configuration.  The config is as follows:
>>
>>
>>     <persistenceAdapter>
>>         <jdbcPersistenceAdapter dataSource="#oracle-ds"
>> statements="#broker-statements" adapter="#db-adapter">
>>                 cleanupPeriod=6000
>>         </jdbcPersistenceAdapter>
>>     </persistenceAdapter>
>>
>>
>>   <bean id="broker-statements"
>> class="org.apache.activemq.store.jdbc.Statements">
>>         <!--<property name="tablePrefix" value="P1_"/>-->
>>   </bean>
>>
>>   <bean id="db-adapter"
>> class="org.apache.activemq.store.jdbc.adapter.StreamJDBCAdapter">
>>         <property name="batchStatments" value="false"/>
>>   </bean>
>>
>>   <bean id="oracle-ds" class="org.apache.commons.dbcp.BasicDataSource"
>> destroy-method="close">
>>         <property name="driverClassName"
>> value="oracle.jdbc.driver.OracleDriver"/>
>>         <property name="url" value="jdbc:oracle:oci:@rcjlive"/>
>>         <property name="username" value="RCJLIVE"/>
>>         <property name="password" value="RCJLIVE"/>
>>         <property name="poolPreparedStatements" value="true"/>
>>   </bean>
>>
>> --
>> View this message in context:
>> http://www.nabble.com/Oracle-Persistant-Journal-tf2140863.html#a5908849
>> Sent from the ActiveMQ - User forum at Nabble.com.
>>
>>
> 
> 
> -- 
> 
> James
> -------
> http://radio.weblogs.com/0112098/
> 
> 

-- 
View this message in context: http://www.nabble.com/Oracle-Persistant-Journal-tf2140863.html#a5909049
Sent from the ActiveMQ - User forum at Nabble.com.


Mime
View raw message