Return-Path: 
 <activemq-users-return-4186-apmail-geronimo-activemq-users-archive=geronimo.apache.org@geronimo.apache.org>
Delivered-To: apmail-geronimo-activemq-users-archive@www.apache.org
Received: (qmail 23754 invoked from network); 30 Aug 2006 10:18:25 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 30 Aug 2006 10:18:25 -0000
Received: (qmail 37055 invoked by uid 500); 30 Aug 2006 10:18:25 -0000
Delivered-To: apmail-geronimo-activemq-users-archive@geronimo.apache.org
Received: (qmail 36864 invoked by uid 500); 30 Aug 2006 10:18:24 -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 36855 invoked by uid 99); 30 Aug 2006 10:18:24 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 30 Aug 2006 03:18:24 -0700
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Received: from [64.14.253.182] (HELO mail.exist.com) (64.14.253.182)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 30 Aug 2006 03:18:23 -0700
Received: from [192.168.241.194] ([58.71.13.205])
	(authenticated bits=0)
	by mail.exist.com (8.12.11/8.12.11) with ESMTP id k7UAFX4K029835
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO)
	for <activemq-users@geronimo.apache.org>; Wed, 30 Aug 2006 03:15:40 -0700
Message-ID: <44F565D0.6010401@exist.com>
Date: Wed, 30 Aug 2006 18:17:52 +0800
From: Adrian Co <aco@exist.com>
User-Agent: Thunderbird 1.5.0.5 (Windows/20060719)
MIME-Version: 1.0
To: activemq-users@geronimo.apache.org
Subject: Re: mySQL Too many connections
References: <6046387.post@talk.nabble.com>
In-Reply-To: <6046387.post@talk.nabble.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

Hi,

I wonder if you can submit a JUnit test case for this? :)

F-kris wrote:
> Hi,
>
> I am using ActiveMQ 4.1 and mySQL 5. I use persistence messaging :
>
> <persistenceAdapter>
>    <journaledJDBC journalLogFiles="5" dataDirectory="../activemq-data"
> dataSource="#mysql-ds" useJournal="true">
> <adapter><bytesJDBCAdapter/></adapter>
>    </journaledJDBC>      
> </persistenceAdapter> 
>
> When I want to consume one message with only one consumer, I see hundreds of
> connections to the mySQL server, and an exception is thrown while trying to
> consume messages :
>
> Exception caught: javax.jms.JMSException: java.io.IOException: Failed to
> broker message: ID: xxxx-xxx-xxxx-x:x:x:x:x in container:
> java.io.IOException: Data source rejected establishment of connection, 
> message from server: "Too many connections"
> javax.jms.JMSException: java.io.IOException: Failed to broker message:
> ID:xxxx-xxx-xxxx-x:x:x:x:x in container: java.io.IOException: Data source
> rejected establishment of connection,  message from server: "Too many
> connections"
> 	at
> org.apache.activemq.util.JMSExceptionSupport.create(JMSExceptionSupport.java:45)
> 	at
> org.apache.activemq.ActiveMQConnection.syncSendPacket(ActiveMQConnection.java:1118)
> 	at
> org.apache.activemq.ActiveMQSession.syncSendPacket(ActiveMQSession.java:1667)
> 	at
> org.apache.activemq.ActiveMQMessageConsumer.<init>(ActiveMQMessageConsumer.java:196)
> 	at
> org.apache.activemq.ActiveMQSession.createConsumer(ActiveMQSession.java:840)
> 	at org.apache.
>
> Does anyone know why?
>
>
>
>