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

by

The problem is not the id column.

From the statement it looks like you have quotes around all columns. Therefore it seems to the SQL, that you have only one column 

'"title","url","age"'

What you might want to have is 

"insert into table(title, url, age) values ('" + title + "','" + url + "'," + age + ")"

or even better yet, since it is a prepared statement 

"insert into table(title, url, age) values (?, ?, ?)"

More Related Contents:

  1. java.sql.SQLException: No suitable driver found for jdbc:microsoft:sqlserver
  2. ResultSet.getString(1) throws java.sql.SQLException: Invalid operation at current cursor position
  3. java.sql.SQLException: No database selected – why?
  4. PreparedStatement with list of parameters in a IN clause [duplicate]
  5. Using setDate in PreparedStatement
  6. java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver Exception occurring. Why?
  7. java.lang.ClassNotFoundException: com.mysql.jdbc.Driver in Eclipse
  8. ResultSet exception – before start of result set
  9. What does Statement.setFetchSize(nSize) method really do in SQL Server JDBC driver?
  10. Handling MySQL datetimes and timestamps in Java
  11. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:Communications link failure [duplicate]
  12. When to close Connection, Statement, PreparedStatement and ResultSet in JDBC
  13. java.util.stream with ResultSet
  14. handling DATETIME values 0000-00-00 00:00:00 in JDBC
  15. JDBC ResultSet get columns with table alias
  16. How to start a transaction in JDBC?
  17. Getting an exception ORA-00942: table or view does not exist – when inserting into an existing table
  18. Driver JDBC PostgreSQL with Android [duplicate]
  19. ‘0000-00-00 00:00:00’ can not be represented as java.sql.Timestamp error
  20. Populating jTable using database data
  21. How to simulate a DB for testing (Java)?
  22. is there a standard way to define a JDBC Datasource for Java EE containers?
  23. I’m getting a java.lang.classnotfoundexception: com.mysql.jdbc.Driver
  24. How to get *everything* back from a stored procedure using JDBC
  25. Using a prepared statement and variable bind Order By in Java with JDBC driver
  26. Java 7 Automatic Resource Management JDBC (try-with-resources statement)
  27. UCanAccess Initializer Error (compile/run without IDE)
  28. Why do we use a DataSource instead of a DriverManager?
  29. Do I need to close ‘PreparedStatement’? [closed]
  30. Database independence through JDBC in java

Leave a Comment