Batch insert error mysql and java

Question

I'm trying to do a batch insert with java in a test database for my college project, but I'm getting an error and I could not figure out why.. selects statements are working but the insert will just not work. thanks in advance.

Error: Exception in thread "main" java.sql.BatchUpdateException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:1193) at test.main(test.java:29)

    public static void main(String[] args) throws Exception
    {
            Class.forName("com.mysql.jdbc.Driver");
            Connection con = DriverManager.getConnection ("jdbc:mysql://myserverIP:3306/databaseName","root", "");

            Statement statement = con.createStatement();

            String [] queries = {
                "insert into name (first,last) values ('Joao', 'Silva')",
                "insert into name (first,last) values ('Jose', 'Santos')",
                "insert into name (first,last) values ('Lucas', 'Maluco')",
                "insert into name (first,last) values ('Cesar', 'Pereira')",

            };

            for (String query: queries) {
            statement.addBatch(query);
            statement.executeBatch();
            }
            statement.close();
            con.close();
    }

Forgot to mention that I'm not getting any errors while compiling the code, but only when I run it. — user3344414
– user3344414, Commented Mar 2, 2014 at 21:20

Reimeus · Accepted Answer · 2014-03-02 21:50:21Z

2

Execute the batch after all the queries has been added to the Statement rather than per individual query

for (String query: queries) {
   statement.addBatch(query);
}
statement.executeBatch();

edited Mar 2, 2014 at 21:50

answered Mar 2, 2014 at 21:23

Reimeus

160k16 gold badges225 silver badges282 bronze badges

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

Collectives™ on Stack Overflow

Batch insert error mysql and java

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related