Error message with executeUpdate()
Posted by: Simon Fisher
Date: May 16, 2005 06:11PM


I have upgraded from JDBC Connector/J ver 3.0.14 to ver 3.1.4. The following statement used to work with 3.0.14 but now returns this error message

"SQLException: This command is not supported in the prepared statement protocol yet"

This is the statement I have in my code:

Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/test?user=root");
PreparedStatement UpdateSQL = conn.prepareStatement("UPDATE tbl_btm_security SET Password = ?, PasswordReset = ?, Password_Expiry_Date = ?, DateTimestamp = ?, Locked = ? WHERE UserID = ?");

UpdateSQL.setString(1, getPassword());
UpdateSQL.setString(2, getResetFlag());
UpdateSQL.setString(3, getExpiryDate());
UpdateSQL.setString(4, dateTimeStamp);
UpdateSQL.setString(5, "N");
UpdateSQL.setString(6, uidValue);



Simon Fisher

Options: ReplyQuote

Written By
Error message with executeUpdate()
May 16, 2005 06:11PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.