Java-Error when writing to Access DB

Question

I'm trying to write some data to an MS-Access database but I keep getting "unknown source" error. Stack trace below:

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.SQLExecute(Unknown Source)
    at sun.jdbc.odbc.JdbcOdbcPreparedStatement.execute(Unknown Source)
    at sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeUpdate(Unknown Source)
    at SampleDB.main(SampleDB.java:15)

Code sample below:

import java.sql.*;

public class SampleDB {
    public static void main (String[]args) {
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 
        Connection con = DriverManager.getConnection("jdbc:odbc:sample_db"); 
            PreparedStatement ps = con.prepareStatement("INSERT INTO Data_Sample (FirstName,Surname,Address) (?,?,?)");
            ps.setString(1,"John");
            ps.setString(2,"Smith");
        ps.setString(3,"New York");

            ps.executeUpdate();
            con.close();    
            System.out.println("inserted");
        } catch(Exception e) {
            e.printStackTrace();
        }

    }
}

Would appreciate any help in debugging the above.

SpringLearner · Accepted Answer · 2015-07-06 11:28:42Z

3

your insert query is wrong

INSERT INTO Data_Sample (FirstName,Surname,Address) (?,?,?)

it should be

INSERT INTO Data_Sample(FirstName,Surname,Address) values(?,?,?)

answered Jul 6, 2015 at 11:28

SpringLearner

13.9k20 gold badges82 silver badges117 bronze badges

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

1 Comment

Shaw Over a year ago

Just realised that now. Guess I'm just tired and overlooking these little things.

Jeeppp · Accepted Answer · 2015-07-06 11:33:20Z

0

The issue is the format of the SQL statement is malformed.

should it be like

 PreparedStatement ps = con.prepareStatement("INSERT INTO Data_Sample (FirstName,Surname,Address) VALUES (?,?,?)");

answered Jul 6, 2015 at 11:33

Jeeppp

1,5733 gold badges18 silver badges46 bronze badges

Collectives™ on Stack Overflow

Java-Error when writing to Access DB

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related