db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lothar Krenzien" <lkrenz...@web.de>
Subject error executing multiple insert statements
Date Thu, 16 Jun 2011 18:03:23 GMT
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

Mime
View raw message