Hi,

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
line 1

Example:
private static final String PRODUCT_BY_RANGE_LIMIT = "SELECT * FROM
Product LIMIT ?,?";
~~~~cut~~~~~~
prepStmt.setInt(1, index);
prepStmt.setInt(1, range);
~~~~cut~~~~~~



Anybody else came across this problem?

Thanks,

Axel


--
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

Axel,

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

Thanks,
Ken Cochrane
http://PopcornMonsters.com

Axel Muench wrote: