Hi,
Sometimes when querying mySQL 4.1.11 on Linux machine I get the error "Lost connection to MySQL server during query". Here are the symptoms 1. When running the query from the server it returns OK 2. When running the query from another machine using the mySQL query browser it returns OK 3. When running the query from another machine from Java using mySQL JDBC it fails with " Lost connection to..." 4. When running the query from another machine using software like EMS it fails with " Lost connection to..." 5. The error is always after 4.7 seconds and only in "heavy" queries (not only SELECT, even DELETES ) The problem is probably not in the communication parameters, like max_allowed_packet or connection_timeout on the server because I increased then .... Does anyone know how can I control those parameters from JDBC? Amir
