SQL query works in phpmyadmin but not when using jdbc and java

Question

This query works when I input it through phpmyadmin.

INSERT INTO conversation (user_id) VALUES (?);
INSERT INTO conversation (conversation_id, user_id)
VALUES ((SELECT LAST_INSERT_ID()), ?)

However when I send that query using jdbc and java I get an error -

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 'INSERT INTO conversation (conversation_id, user_id) VALUES ((SELECT LAST_INSERT_' at line 1"

I am using the exact same query. I checked by calling toString on the PreparedStatement and copying and pasting it into phpmyadmin and executing it and it worked fine. It just doesn't work through java. Any ideas whats wrong?

Justin ᚅᚔᚈᚄᚒᚔ · Accepted Answer · 2012-03-15 19:13:50Z

4

By default, you cannot execute multiple statements in one query through JDBC. Splitting it into two calls will work, as will changing the allowMultiQueries configuration property to True.

JDBC Configuration Properties — allowMultiQueries:

Allow the use of ';' to delimit multiple queries during one statement (true/false), defaults to 'false', and does not affect the addBatch() and executeBatch() methods, which instead rely on rewriteBatchStatements.

Default value: false

answered Mar 15, 2012 at 19:13

Justin ᚅᚔᚈᚄᚒᚔ

15.4k8 gold badges55 silver badges64 bronze badges

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

1 Comment

Mark Rotteveel Over a year ago

Be aware that multiple queries are a non-standard extension of the MySQL Connector/J driver.

Collectives™ on Stack Overflow

SQL query works in phpmyadmin but not when using jdbc and java

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