[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-java
Subject:    Re: connection error in a stress load env
From:       Dennis T <dennis10_t () mac ! com>
Date:       2003-10-20 17:33:56
[Download RAW message or body]

Hi David,
My Connection Pool Mgr was designed to have a min set of connections and
could grow up to fixed level. I was also closing connections if the 
connections
are released to the pool & if it exceeded the min level. In a high 
stress load there
could be shunting of opening and closing connections and subsequently 
run out
of descriptors.

I have got rid of releasing connections & I do not get the "Address 
already in use"
exception anymore.

When do find the time I may add some more logic of setting create time 
for each
of the connection obj, and release it if its lying idle in the pool for 
a while.

Thanks,
Dennis


On Oct 20, 2003, at 3:32 AM, David Chott wrote:

> Hi Dennis,
>
> I'm having the same problem you described on 
> mailing.database.mysql-java:
>
> ---
> java.sql.SQLException: Unable to connect to any hosts due to exception:
>   java.net.SocketException: Address already in use
>          at com.mysql.jdbc.Connection.createNewIO(Connection.java:1622)
>          ...
> ---
>
> I found your postings and the responses you got in a Google search, 
> but I
> didn't see any ultimate resolution to the issue.  Have you been able to
> resolve this problem in your environment and, if so, could you please
> share with me the details of your solution?
>
> Much obliged,
> David
>


-- 
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe:    http://lists.mysql.com/java?unsub=mysql-java@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]