java.sql.SQLSyntaxErrorException: ORA-00971: missing SET keyword

[Stephen Douglas]

Please help on this :confused:

i am receiving such an error
[COLOR="Red"]java.sql.SQLSyntaxErrorException: ORA-00971: missing SET keyword


my code is ::

if (column == 1) {
                        preparedStatement = connection.prepareStatement("update rms_accountstore customer_name = ? where customer_name like ?");
                        preparedStatement.setString(1, data.toString());
                        preparedStatement.setString(2, resultset.getObject(column + 1).toString());
                        [COLOR="red"]preparedStatement.executeUpdate();[/COLOR]
                    } else if (column == 2) {
                        preparedStatement = connection.prepareStatement("update rms_accountstore customer_address = ? where customer_address like ?");
                        preparedStatement.setString(1, data.toString());
                        preparedStatement.setString(2, resultset.getObject(column + 1).toString());
                        preparedStatement.executeUpdate();
                    } else if (column == 3) {
                        preparedStatement = connection.prepareStatement("update rms_accountstore tin_number = ? where tin_number like ?");
                        preparedStatement.setString(1, data.toString());
                        preparedStatement.setString(2, resultset.getObject(column + 1).toString());
                        preparedStatement.executeUpdate();
                    }

i am getting error directed to the colored portion of my code..
plz suggest. thnx

[porchrat]

I think your update syntax is incorrect. This is how an update needs to work:

UPDATE <table> SET foo=bar, foo2=bar2 WHERE <conditions>;

Yours is missing "set":

preparedStatement = connection.prepareStatement("update rms_accountstore [b]set[/b] customer_name = ? where customer_name like ?");

[Stephen Douglas]

Ooooh such a stupid mistake.. i have been looking for the mistake elsewhere for so long.. thank you !

[porchrat]

Ooooh such a stupid mistake.. i have been looking for the mistake elsewhere for so long.. thank you !

No worries mate. Happy to help.

Please remember to mark the thread [SOLVED]