Advertisement
Guest User

Untitled

a guest
Feb 6th, 2017
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.67 KB | None | 0 0
  1. Class.forName("com.mysql.jdbc.Driver");
  2. Connection con1=DriverManager.getConnection("jdbc:mysql://localhost:3309/ikpems","root","system");
  3. Statement st1=con1.createStatement();
  4. st1.execute("insert into energymetersdata values('20_lab5a_daicel_20_kwh','06-02-2017 12:02:13','8422587','1','42772501540.0694')");
  5.  
  6. java.sql.SQLException: Column count doesn't match value count at row 1
  7. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
  8. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
  9. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
  10. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement