java.sql.SQLException: Column count doesn't match value count at row 1 [duplicate]

Question

im currently getting this error when i run my programs query,

java.sql.SQLException: Column count doesn't match value count at row 1

but i dont know why , all my values are there and match up. this is the code were i do my sql statement.

c = DriverManager.getConnection( url, username, password );


String selectStatement = "INSERT INTO entry ( id, name, title, note) VALUES (?),(?),(?),(?)";
PreparedStatement prepStmt = (PreparedStatement) c.prepareStatement(selectStatement);
prepStmt.setInt(1, idSeed++);
prepStmt.setString(2, name2);
prepStmt.setString(3, title2);
prepStmt.setString(4, note2);
prepStmt.executeUpdate();

are you getting correct output ? i have doubt in it. i mean other changes need rather than insert query. — Vishal Gajera
– Vishal Gajera, Commented Dec 3, 2015 at 8:09

ThomasThiebaud · Accepted Answer · 2015-12-03 07:43:33Z

3

Your SQL syntax is incorrect. It must be

INSERT INTO entry ( id, name, title, note) VALUES (?,?,?,?)

answered Dec 3, 2015 at 7:43

ThomasThiebaud

12.1k6 gold badges57 silver badges80 bronze badges

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

Comments

Shivam · Accepted Answer · 2015-12-03 09:40:31Z

0

please do the following changes in your existence code,

maintain idSeed's value too.

String selectStatement = "INSERT INTO entry ( id, name, title, note) VALUES (?,?,?,?)";
PreparedStatement prepStmt = (PreparedStatement) c.prepareStatement(selectStatement);
prepStmt.setInt(1, idSeed); // remove ++ from here, do it in last
prepStmt.setString(2, name2);
prepStmt.setString(3, title2);
prepStmt.setString(4, note2);
prepStmt.executeUpdate();

Notes entry = new Notes(idSeed, name2, title2,note2 ); //now you will get exactly what inserted into DB table
entries.add(entry);

idSeed++; // now increment it, which will reflect into next iteration...

edited Dec 3, 2015 at 9:40

Shivam

6392 gold badges8 silver badges20 bronze badges

answered Dec 3, 2015 at 8:14

Vishal Gajera

4,2378 gold badges32 silver badges57 bronze badges

Collectives™ on Stack Overflow

java.sql.SQLException: Column count doesn't match value count at row 1 [duplicate]

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related