Update Statement - Syntax error in UPDATE statement (Java & MS Access)

Question

I am trying to update a MS Access database. I have searched this and I have tried everything I have found but I am still getting the following error.

java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.

Any help would be very helpful. My code is below...;

    String sqlStatement = "UPDATE ProductCatalogue"
            + "SET [StockLevel] = ?"
            + "WHERE [ProductID] = ?;";

    PreparedStatement prepStatement = connection.prepareStatement(sqlStatement);
    prepStatement.setInt(1, quantity);
    prepStatement.setInt(2, productID);

    //= "UPDATE ProductCatalogue"
    //+ "SET StockLevel = " + quantity
    //+ "WHERE ProductID = " + productID + ";";

    try {
        //myStatement.executeUpdate(sqlStatement);
        prepStatement.executeUpdate();
    } catch (SQLException sqle) {
        System.out.println("Oopss...." + sqle);
    }
    connection.close();
    prepStatement.close();

Paolo Falabella · Accepted Answer · 2013-11-18 14:22:05Z

3

you may need a few whitespaces. Try:

String sqlStatement = "UPDATE ProductCatalogue "
            + "SET [StockLevel] = ? "
            + "WHERE [ProductID] = ?;";

(note the space after ProductCatalogue and the first ?)

answered Nov 18, 2013 at 14:22

Paolo Falabella

26k3 gold badges78 silver badges91 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Update Statement - Syntax error in UPDATE statement (Java & MS Access)

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related