Return-Path: 
 <users-return-14195-apmail-activemq-users-archive=activemq.apache.org@activemq.apache.org>
Delivered-To: apmail-activemq-users-archive@www.apache.org
Received: (qmail 58986 invoked from network); 20 May 2008 06:28:18 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 20 May 2008 06:28:18 -0000
Received: (qmail 84432 invoked by uid 500); 20 May 2008 06:28:20 -0000
Delivered-To: apmail-activemq-users-archive@activemq.apache.org
Received: (qmail 84069 invoked by uid 500); 20 May 2008 06:28:19 -0000
Mailing-List: contact users-help@activemq.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:users-help@activemq.apache.org>
List-Unsubscribe: <mailto:users-unsubscribe@activemq.apache.org>
List-Post: <mailto:users@activemq.apache.org>
List-Id: <users.activemq.apache.org>
Reply-To: users@activemq.apache.org
Delivered-To: mailing list users@activemq.apache.org
Received: (qmail 84058 invoked by uid 99); 20 May 2008 06:28:19 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 19 May 2008 23:28:19 -0700
X-ASF-Spam-Status: No, hits=-7.8 required=10.0
	tests=RCVD_IN_DNSWL_HI,SPF_PASS,WHOIS_MYPRIVREG
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: local policy)
Received: from [193.254.30.30] (HELO mail01.airplus.com) (193.254.30.30)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 20 May 2008 06:27:25 +0000
X-IronPort-AV: E=Sophos;i="4.27,513,1204498800";
   d="scan'208";a="16917957"
Received: from unknown (HELO ntex-frajx-02.lasg) ([10.100.70.22])
  by mail01-out.airplus.com with ESMTP; 20 May 2008 08:27:46 +0200
Received: from ntex-frajx-01.lasg ([10.100.70.21]) by ntex-frajx-02.lasg with
 Microsoft SMTPSVC(6.0.3790.1830);
	 Tue, 20 May 2008 08:27:45 +0200
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
X-MimeOLE: Produced By Microsoft Exchange V6.5
Subject: AW: ORA-00020: maximum number of processes (150) exceeded
Date: Tue, 20 May 2008 08:27:45 +0200
Message-ID: <9FBCD3154351EC4884B7259EDBB9A85F2521DD6D@ntex-frajx-01.lasg>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: ORA-00020: maximum number of processes (150) exceeded
Thread-Index: Aci2uqTLBccZPoh+QES9hJ9998kAywDhuW7A
From: "Harm, Martin" <MHarm@airplus.com>
To: <users@activemq.apache.org>
X-OriginalArrivalTime: 20 May 2008 06:27:45.0611 (UTC)
 FILETIME=[9DAE41B0:01C8BA42]
X-Virus-Checked: Checked by ClamAV on apache.org

Mayby the same reason as for the bug =
https://issues.apache.org/activemq/browse/AMQ-1702 ??

(Not releasing statements in the DB-Lock. It's fixed in 5.2-SNAP)

martin


-----Urspr=FCngliche Nachricht-----
Von: Filip Hanik - Dev Lists [mailto:devlists@hanik.com]=20
Gesendet: Donnerstag, 15. Mai 2008 20:37
An: users@activemq.apache.org
Betreff: Re: ORA-00020: maximum number of processes (150) exceeded


this might not be related to the pool, but the fact that statements and=20
resultsets are not closed.

the error comes directly from Oracle,

Filip

Hiram Chirino wrote:
> could you try using the C3P0 [1] connection pooling instead of the
> default commons logging pooling.  Some folks have reported better luck
> using it.
>
> Just add the c3p0 jar to the lib dir and add spring bean similar to
> the following (this a mysql example)
>
>   <bean id=3D"mysql-ds"
> class=3D"com.mchange.v2.c3p0.ComboPooledDataSource"
> destroy-method=3D"close">
>     <property name=3D"driverClass" value=3D"com.mysql.jdbc.Driver"/>
>     <property name=3D"jdbcUrl" =
value=3D"jdbc:mysql://localhost/activemq"/>
>     <property name=3D"user" value=3D"user"/>
>     <property name=3D"password" value=3D"password"/>
>     <property name=3D"minPoolSize" value=3D"6"/>
>     <property name=3D"maxPoolSize" value=3D"18"/>
>     <property name=3D"acquireIncrement" value=3D"3"/>
>     <property name=3D"idleConnectionTestPeriod" value=3D"60"/>
>   </bean>
>
> [1] http://sourceforge.net/projects/c3p0
>
>
> On Sun, May 11, 2008 at 10:57 PM, cauchy <fuliu2715@yahoo.com.cn> =
wrote:
>  =20
>> Hi everybody!
>> I used Oracle 9 as persistence storage with out journal.After ran the
>> ProducerAndConsumerTool.java in exmple pakage of ActiveMQ 5.0 for a =
while
>> ,the Exception occured:
>> Caught: javax.jms.JMSException: ORA-00020: maximum number of =
processes (150)
>> exceeded
>>
>> javax.jms.JMSException: ORA-00020: maximum number of processes (150)
>> exceeded
>>
>>        at
>> =
org.apache.activemq.util.JMSExceptionSupport.create(JMSExceptionSupport.j=
ava:49)
>>        at
>> =
org.apache.activemq.ActiveMQConnection.syncSendPacket(ActiveMQConnection.=
java:1178)
>>        at =
org.apache.activemq.ActiveMQSession.send(ActiveMQSession.java:1640)
>>        at
>> =
org.apache.activemq.ActiveMQMessageProducer.send(ActiveMQMessageProducer.=
java:226)
>>        at
>> =
org.apache.activemq.ActiveMQMessageProducerSupport.send(ActiveMQMessagePr=
oducerSupport.java:240)
>>        at test3.ProducerTool.sendLoop(ProducerTool.java:143)
>>        at test3.ProducerTool.run(ProducerTool.java:108)
>>        at =
test3.ProducerAndConsumerTool.main(ProducerAndConsumerTool.java:52)
>> Caused by: java.io.IOException: ORA-00020: maximum number of =
processes (150)
>> exceeded
>>
>>        at
>> =
org.apache.activemq.util.IOExceptionSupport.create(IOExceptionSupport.jav=
a:45)
>>        at
>> =
org.apache.activemq.store.jdbc.TransactionContext.getConnection(Transacti=
onContext.java:61)
>>        at
>> =
org.apache.activemq.store.jdbc.adapter.DefaultJDBCAdapter.doAddMessage(De=
faultJDBCAdapter.java:172)
>>        at
>> =
org.apache.activemq.store.jdbc.JDBCMessageStore.addMessage(JDBCMessageSto=
re.java:69)
>>        at
>> =
org.apache.activemq.store.memory.MemoryTransactionStore.addMessage(Memory=
TransactionStore.java:229)
>>        at
>> =
org.apache.activemq.store.memory.MemoryTransactionStore$2.addMessage(Memo=
ryTransactionStore.java:129)
>>        at =
org.apache.activemq.broker.region.Topic.doMessageSend(Topic.java:400)
>>        at =
org.apache.activemq.broker.region.Topic.send(Topic.java:371)
>>        at
>> =
org.apache.activemq.broker.region.AbstractRegion.send(AbstractRegion.java=
:328)
>>        at
>> =
org.apache.activemq.broker.region.RegionBroker.send(RegionBroker.java:402=
)
>>        at
>> =
org.apache.activemq.broker.TransactionBroker.send(TransactionBroker.java:=
224)
>>        at =
org.apache.activemq.broker.BrokerFilter.send(BrokerFilter.java:125)
>>        at
>> =
org.apache.activemq.broker.CompositeDestinationBroker.send(CompositeDesti=
nationBroker.java:95)
>>        at
>> =
org.apache.activemq.broker.MutableBrokerFilter.send(MutableBrokerFilter.j=
ava:135)
>>        at
>> =
org.apache.activemq.broker.TransportConnection.processMessage(TransportCo=
nnection.java:434)
>>        at
>> =
org.apache.activemq.command.ActiveMQMessage.visit(ActiveMQMessage.java:62=
3)
>>        at
>> =
org.apache.activemq.broker.TransportConnection.service(TransportConnectio=
n.java:281)
>>        at
>> =
org.apache.activemq.broker.TransportConnection$1.onCommand(TransportConne=
ction.java:178)
>>        at
>> =
org.apache.activemq.transport.TransportFilter.onCommand(TransportFilter.j=
ava:67)
>>        at
>> =
org.apache.activemq.transport.WireFormatNegotiator.onCommand(WireFormatNe=
gotiator.java:134)
>>        at
>> =
org.apache.activemq.transport.InactivityMonitor.onCommand(InactivityMonit=
or.java:138)
>>        at
>> =
org.apache.activemq.transport.TransportSupport.doConsume(TransportSupport=
.java:83)
>>        at
>> =
org.apache.activemq.transport.tcp.TcpTransport.doRun(TcpTransport.java:18=
5)
>>        at
>> =
org.apache.activemq.transport.tcp.TcpTransport.run(TcpTransport.java:172)=

>>        at java.lang.Thread.run(Thread.java:619)
>> Caused by: java.sql.SQLException: ORA-00020: maximum number of =
processes
>> (150) exceeded
>>
>>        at =
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
>>        at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
>>        at oracle.jdbc.ttc7.O3log.receive1st(O3log.java:408)
>>        at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:260)
>>        at =
oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:365)
>>        at
>> =
oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:5=
47)
>>        at =
oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:347)
>>        at
>> =
org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverCo=
nnectionFactory.java:37)
>>        at
>> =
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConn=
ectionFactory.java:290)
>>        at
>> =
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObject=
Pool.java:771)
>>        at
>> =
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource=
.java:95)
>>        at
>> =
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.jav=
a:544)
>>        at
>> =
org.apache.activemq.store.jdbc.TransactionContext.getConnection(Transacti=
onContext.java:54)
>>        ... 23 more
>>
>> So what's this prolem and how to fix it?
>>
>> --
>> View this message in context: =
http://www.nabble.com/ORA-00020%3A-maximum-number-of-processes-%28150%29-=
exceeded-tp17180724s2354p17180724.html
>> Sent from the ActiveMQ - User mailing list archive at Nabble.com.
>>
>>
>>    =20
>
>
>
>  =20