jdbc returns mySQL syntax error exception for a valid query

Question

I user the java.sql.Statement.excecuteUpdate method to create a table and insert some values into the database through JDBC. However, it gives me MySQL syntax exceptions for no reason. I copied and pasted the same code into command prompt. it worked.

I'm wondering why it's doing that??

Can you provide the query and code you're using?

atfergs
– atfergs

2009-06-16 20:24:58 +00:00
Commented Jun 16, 2009 at 20:24 — atfergs
– atfergs, Commented Jun 16, 2009 at 20:24

dfa · Accepted Answer · 2009-06-16 20:26:10Z

2

Guessing

You cannot do a query like: insert ...; insert ... ; only one query per method call

answered Jun 16, 2009 at 20:26

dfa

117k32 gold badges193 silver badges229 bronze badges

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

1 Comment

Progress Programmer Over a year ago

is there an easy way to do a bunch of insert?

Collectives™ on Stack Overflow

jdbc returns mySQL syntax error exception for a valid query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related