View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3821680#3821680

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3821680

I had a work around though it is not a solution to the problem ,but atleast your 
connections dont get exhausted.Dont give your idle time out in minutes just give it 3 
seconds,So if the connection pool is idle for 3 seconds it will return the connection 
to the pool. Atleast you done have to restart the server

<?xml version="1.0" encoding="UTF-8"?>



    <local-tx-datasource>

       <jndi-name>jdbc/expressionsDS</jndi-name>

        <connection-url>jdbc:mysql://localhost:3306/expressions</connection-url>

        <driver-class>org.gjt.mm.mysql.Driver</driver-class>

        <user-name>expressions</user-name>

        expressions

         <min-pool-size>5</min-pool-size>

         <max-pool-size>50</max-pool-size>

        <idle-timeout-millis>3000</idle-timeout-millis>         

    </local-tx-datasource>



Adrian Can you suggest a solution. 







Thanks 






-------------------------------------------------------
SF.Net is sponsored by: Speed Start Your Linux Apps Now.
Build and deploy apps & Web services for Linux with
a free DVD software kit from IBM. Click Now!
http://ads.osdn.com/?ad_id=1356&alloc_id=3438&op=click
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to