Connector/J 3.1.16 LIMIT Exception - 01-11-2005 , 04:36 AM
Since we upgraded our staging server from Connector/J 3.0.14+ to
Connector/J 3.1.16 ( on mysql 4.1.17) we receive for any SQL
PreparedStatements ending in "LIMIT ?,?" a java.sql.SQLException:
You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near '?,?' at
private static final String PRODUCT_BY_RANGE_LIMIT = "SELECT * FROM
Product LIMIT ?,?";
Anybody else came across this problem?
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe: http://lists.mysql.com/java?unsub=my...ie.nctu.edu.tw
Re: Connector/J 3.1.16 LIMIT Exception - 02-09-2005 , 03:48 PM
I am also getting the error, that you listed. Have you found a solution
to the problem?
Here is the error that I am getting:
"java.sql.SQLException: You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near '?' at line 1"
I am getting the error now that I have switched from MySQL 4.0.x to
4.1.9 and I am using MySQL connector/J 3.1.6 and Tomcat 4.1.31
Axel Muench wrote: