java insert into,INSERT INTO语句中的Java SQL语法错误

I am trying to insert the data below into a table that has the columns ID[autoNumber], type[text], to[text], from[text], message[text] and attachmentLoc[text]

So the autonumber is generated I insert them supplying the column names. When it runs the console prints out:

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

at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957)

at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)

at sun.jdbc.odbc.JdbcOdbc.SQLExecute(JdbcOdbc.java:3149)

at sun.jdbc.odbc.JdbcOdbcPreparedStatement.execute(JdbcOdbcPreparedStatement.java:216)

at sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeUpdate(JdbcOdbcPreparedStatement.java:138)

at MultiEchoServer.saveMessage(MultiEchoServer.java:147)

at ClientHandler.run(MultiEchoServer.java:409)

The code that is bringing the error is :

try

{

String sql = "INSERT INTO Messages (type, to, from, message, attachmentLoc) VALUES(?,?,?,?,?)";

PreparedStatement stmt = database.prepareStatement(sql);

stmt.setString(1, message.getType());

stmt.setString(2, message.getTo());

stmt.setString(3, message.getFrom());

stmt.setString(4, message.getMessage());

stmt.setString(5, attachmentLoc);

stmt.executeUpdate();

}

catch (SQLException e)

{

System.out.println("Could not perform statement");

e.printStackTrace();

}

Thanks for your help

解决方案

From is a reserved word, after this was changed to messageFrom it allowed the insertion to the database.