Return-Path: 
 <activemq-users-return-4164-apmail-geronimo-activemq-users-archive=geronimo.apache.org@geronimo.apache.org>
Delivered-To: apmail-geronimo-activemq-users-archive@www.apache.org
Received: (qmail 52611 invoked from network); 29 Aug 2006 19:53:14 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 29 Aug 2006 19:53:14 -0000
Received: (qmail 91972 invoked by uid 500); 29 Aug 2006 19:53:13 -0000
Delivered-To: apmail-geronimo-activemq-users-archive@geronimo.apache.org
Received: (qmail 91957 invoked by uid 500); 29 Aug 2006 19:53:13 -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 91948 invoked by uid 99); 29 Aug 2006 19:53:13 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 29 Aug 2006 12:53:13 -0700
X-ASF-Spam-Status: No, hits=0.5 required=10.0
	tests=FORGED_HOTMAIL_RCVD2,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; Tue, 29 Aug 2006 12:53:12 -0700
Received: from [72.21.53.38] (helo=jubjub.nabble.com)
	by talk.nabble.com with esmtp (Exim 4.50)
	id 1GI9dj-0005Km-SR
	for activemq-users@geronimo.apache.org; Tue, 29 Aug 2006 12:52:51 -0700
Message-ID: <6046387.post@talk.nabble.com>
Date: Tue, 29 Aug 2006 12:52:51 -0700 (PDT)
From: F-kris <entylop@hotmail.com>
To: activemq-users@geronimo.apache.org
Subject: mySQL Too many connections
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
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 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?



-- 
View this message in context: http://www.nabble.com/mySQL-Too-many-connections-tf2185760.html#a6046387
Sent from the ActiveMQ - User forum at Nabble.com.