Re: mySQL Too many connections

[James Strachan <ja...@gmail.com>]

Could you provide the entire XML? It oculd be the JDBC pool you are
using pre-loading itself with connections. You can limit the number of
connections using your pool

On 8/29/06, F-kris <en...@hotmail.com> 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?
>
>
>
> --
> 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.
>
>


-- 

James
-------
http://radio.weblogs.com/0112098/