query works on mysql but not in java

Question

statement2=Myconn.prepareStatement("SET @rank:=0; update entretien "+
                    " set numero_entretien=@rank:=@rank+1 where vehicule_id=?;");
statement2.setInt(1,1);
statement2.executeUpdate();

This query works on mysql workbench , but it doesn't work in java

I have latest MySQL and JDBC version ,I think that the problem is maybe in the ";" that follow @rank:=0 ?

score 0 · Accepted Answer · edited May 23 '17 at 12:09

0

You're right. By default it is not possible to execute more than one query per statement. But you can enable multiple query support by appending ?allowMultiQueries=true to the jdbc connection string.

You can find more details in this SO answer.

edited May 23 '17 at 12:09

Community

1
1

answered Apr 04 '17 at 00:45

streetturtle

5,472
2
25
43

query works on mysql but not in java

1 Answers1