Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

MySQL query and JDBC using "LIMIT"

 
Walt Hoeltzer
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Walt Hoeltzer
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It appears that this is not a Java or JDBC issue. It's related to the connector/j from MySQL.

Thanks.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic