Hello, I'd like to execute multiple insert statements over JDBC at once, but can't get it work ;(
Here a small demo: ... insert into POSITIONTEMPLATE (ID,VERSION,NAME,PRINT) values (NEXT VALUE FOR unique_id,0,'abc',1); insert into POSITIONTEMPLATE (ID,VERSION,NAME,PRINT) values (NEXT VALUE FOR unique_id,0,'efg',0); If I execute every statement at once it works fine but if I execute all statements at once I always get the following error: Encountered ";" at line 4 column 9. I know that it means that there is a problem with the ";" sign - but that can't be right or ? Derby 10.8.1.2 Thank you