Hi,

I have just switched (trying to) 4.1, --old-password and I encounter a very strange bug with PreparedStatement:

I put up a test case so that Mark can see exactly what's the pb. I think some king of similar pb have already been submitted to the list but remained unanswered.

1. The Table: MYTABLE

--------------------------------------- my_key INT primary my_col INT

2. The class

------------------ package net.pulsevision.test;

import java.sql.*;

public class testPreparedStatement { public static void main(String[] args) throws ClassNotFoundException, SQLException {

Class.forName("com.mysql.jdbc.Driver"); String connectionOptions =

Connection connection = null; String connectString = "jdbc:mysql://localhost:3306/MYDATABASE" + connectionOptions; System.out.println("Connecting to " + connectString);

connection = DriverManager.getConnection(connectString, "user", "pass");

System.out.println("Driver Version: " + connection.getMetaData().getDriverVersion());

// Do the Test String sql = "INSERT INTO MYTABLE (my_col) values (?)"; PreparedStatement stmt = connection.prepareStatement(sql); stmt.setInt(1, 666); System.out.println("stmt -> " + stmt); stmt.executeUpdate(sql);

ResultSet rs = stmt.getGeneratedKeys(); if (rs.next()) { System.out.println("generated key -> " + rs.getInt(1)); } } }

I tryed that with various versions of the connector J 3.0.12 and 3.1.1-alpha I get always the same bizarre error:

java.sql.SQLException: Syntax error or access violation message from server: "You have an error in your SQL syntax near '?)' at line 1" at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2234) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1412) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1494) at com.mysql.jdbc.Connection.execSQL(Connection.java:1905) at com.mysql.jdbc.Connection.execSQL(Connection.java:1847) at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1280) at

Is this related to the fact that I use --old-password on the database ?

What can I do ? Right now, my project is stuck: I can't switch to new passwords because of code legacy.

Mark, I need your help .