java.sql.SQLException
My program is compiling correctly with out any errors. when i try to run it this error occurred :
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in
INSERT INTO statement.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.executeUpdate(Unknown Source)
at DataManipulation.main(DataManipulation.java:16)
sample:
class example1
{
public static void main(String args[])
{
String url="jdbc dbc:mysource";
String query="SELECT sname,fname,lname FROM emp";
.......
......
........
myStatement.executeUpdate("insert into student" + "VALUES('aa','marvin','bon',56)");
........
.......

