Hi Mark, thanks for your answer. See comments. > > Stefan, > > Something is closing the network connection abrubtly between JDBC and > your MySQL server. Things to check are: > > 1) Connections don't sit longer than 'wait_timeout' on the server. I am actually using connection pooling (the torque system, in case you know this). After I get this error, my app is still running fine, and also doing dtabase queries. Something interesting: When I do a query ... where x like "%y%" the error occurs. Doing where x regexp "y" works fine, even if I do the regular expression query after the like one, without restarting server or similar things. > 2) If the mysql server is on a different machine than your application: Same machine > 2a) There are no network hardware issues > 2b) There isn't a firewall between the server and your application > that times-out connections > 3) MySQL isn't crashing in between queries (see your mysql server error > log) Nothing in the log > > -Mark > > -- > Mark Matthews > MySQL AB, Software Development Manager - Connectivity > www.mysql.com
-- Stefan Kuhn M. A. Cologne University BioInformatics Center (http://www.cubic.uni-koeln.de) Zülpicher Str. 47, 50674 Cologne Tel: +49(0)221-470-7428 Fax: +49 (0) 221-470-7786 My public PGP key is available at http://pgp.mit.edu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]