I'm not sure if this is in the correct category, but I have a problem from a combination of things that are going on and I'm not sure where the problem actually exists. I was hoping for some insight. We are using Tomcat to call a servlet that uses JDBC to connect to a MySql database. The problem is in the query. When I submit the following, I get an error: SELECT * FROM table WHERE col1 = "A1" LIMIT 0,1 The error is: HTTP/1.1 400 Communication link failure, message from server: "Unknown command" However, when I changed the query and removed the "LIMIT 0,1" I don't get the error. SELECT * FROM table WHERE COL1 = "A1" LIMIT is specific to MySQL and I was wondering if anyone else had run across this issue and how they got around it. I need to extract a specific row from within the result set and I was hoping to do this through the query. The error seems to be directly related to the query and the LIMIT, but I can't understand why. I've tried other clauses (ORDER BY and HAVING) with no problems.
Any ideas about how to get around this or why this is happening? Is this a JDBC issue? Is this a MySQL issue? Or is this a Tomcat issue? Thanks in advance.
posted 11 years ago
It appears that this is not a Java or JDBC issue. It's related to the connector/j from MySQL.