Re: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

Christopher G. Stach II wrote:
>
> It's probably a misconfiguration in your connection pool, if your using
> one.  Use a connection test, and earlier expiration and eviction.  It
> shouldn't be handing out dead connections.  (Couldn't tell where the
> exception was happening in the stack trace you provided.)  A connection
> test on a dead connection would still probably show that exception, so
> you can update your logging levels if things are working properly.
>   
Before handing out a connection we test it with "select now();" and if
that throws an exception we create a new connection instead. This error
occurs in the creation phase and no query is in use yet when this happens.

-- 
Andreas Andersson
Senior Developer

Travelstart <http://www.travelstart.se>

Travelstart Nordic AB
Davidshallsgatan 14
211 45 Malmö

www.travelstart.se <http://www.travelstart.se>
www.travelstart.dk <http://www.travelstart.dk>
	  	Tel +46 (0)40-690 38 83
Mob +46 (0)70-757 23 73
Fax +46 (0)40-611 17 78

www.travelstart.no <http://www.travelstart.no>
www.travelstart.co.za <http://www.travelstart.co.za>


-- 
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe:    http://lists.mysql.com/[email protected]