db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Peter Ondruška <peter.ondruska+de...@kaibo.eu>
Subject Re: error executing multiple insert statements
Date Thu, 16 Jun 2011 18:31:40 GMT
Run this in ij. That is for running SQL scripts. Or execute each
statement (without ;) separately.

On Thu, Jun 16, 2011 at 8:03 PM, Lothar Krenzien <lkrenzien@web.de> wrote:
> 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