Return-Path: 
 <activemq-users-return-3936-apmail-geronimo-activemq-users-archive=geronimo.apache.org@geronimo.apache.org>
Delivered-To: apmail-geronimo-activemq-users-archive@www.apache.org
Received: (qmail 67030 invoked from network); 21 Aug 2006 15:29:37 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 21 Aug 2006 15:29:37 -0000
Received: (qmail 87396 invoked by uid 500); 21 Aug 2006 15:29:36 -0000
Delivered-To: apmail-geronimo-activemq-users-archive@geronimo.apache.org
Received: (qmail 87376 invoked by uid 500); 21 Aug 2006 15:29:36 -0000
Mailing-List: contact activemq-users-help@geronimo.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:activemq-users-help@geronimo.apache.org>
List-Unsubscribe: <mailto:activemq-users-unsubscribe@geronimo.apache.org>
List-Post: <mailto:activemq-users@geronimo.apache.org>
List-Id: <activemq-users.geronimo.apache.org>
Reply-To: activemq-users@geronimo.apache.org
Delivered-To: mailing list activemq-users@geronimo.apache.org
Received: (qmail 87360 invoked by uid 99); 21 Aug 2006 15:29:36 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 21 Aug 2006 08:29:36 -0700
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_HELO_PASS,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: domain of lists@nabble.com designates
 72.21.53.35 as permitted sender)
Received: from [72.21.53.35] (HELO talk.nabble.com) (72.21.53.35)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 21 Aug 2006 08:29:35 -0700
Received: from [72.21.53.38] (helo=jubjub.nabble.com)
	by talk.nabble.com with esmtp (Exim 4.50)
	id 1GFBiF-0006MM-5m
	for activemq-users@geronimo.apache.org; Mon, 21 Aug 2006 08:29:15 -0700
Message-ID: <5909049.post@talk.nabble.com>
Date: Mon, 21 Aug 2006 08:29:15 -0700 (PDT)
From: osian <osian@osian.me.uk>
To: activemq-users@geronimo.apache.org
Subject: Re: Oracle Persistant Journal
In-Reply-To: <ec6e67fd0608210822r264f1590h2c18645032893e0d@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
References: <5908849.post@talk.nabble.com>
 <ec6e67fd0608210822r264f1590h2c18645032893e0d@mail.gmail.com>
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N


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.