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 <[EMAIL PROTECTED]> 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.
