activemq-users mailing list archives

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

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.


Mime
View raw message