Hi All,I my GWT-based application, the INSERT statement inserts a record into the database. It, however, throws the error in red below when hitting the UPDATE statement (in bold and at the bottom). Please help.
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 '? WHERE UserId = ?' at line 1 connection = cadaoDb.getConnection(); connection.setAutoCommit(false); sql = "INSERT INTO User (First, Middle, Last, ID) " + "VALUES (?, ?, ?, ?)"; ps = connection.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS); ps.setString(1, mem.getFirst()); ps.setString(2, mem.getMiddle()); ps.setString(3, mem.getLast()); ps.setString(4, ""); ps.executeUpdate(); int userId = cadaoDb.getGeneratedId(ps.getGeneratedKeys()); id = generateId(userId); sql = "UPDATE User SET ID = ? WHERE UserId = ?"; ps = connection.prepareStatement(sql); ps.setString(1, id);//I checked, id = non-empty string ps.setInt(2, userId);//I checked, userId = 1 ps.executeUpdate(sql); It, however, works when I replace question marks in the update sql statement with real value like this: id = generateId(userId); sql = "UPDATE User SET ID = 'abc' WHERE UserId = 1"; ps = connection.prepareStatement(sql); ps.executeUpdate(sql); --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Web Toolkit" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Google-Web-Toolkit?hl=en -~----------~----~----~----~------~----~------~--~---
