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

Hi,

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

UpdateSQL.executeUpdate();
UpdateSQL.close();

Thanx

Simon Fisher

Options: ReplyQuote


Subject
Written By
Posted
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.