error executing multiple insert statements

[Lothar Krenzien]

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

Re: error executing multiple insert statements

[Peter Ondruška]

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 lkrenz...@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

Re: error executing multiple insert statements

[Lothar Krenzien]

But shouldn't it works with JDBC too ?

Re: error executing multiple insert statements

[Bryan Pendleton]

On 06/16/2011 11:38 AM, Lothar Krenzien wrote:

But shouldn't it works with JDBC too ?



Perhaps you are looking for the batch facility of JDBC, as in the
addBatch/executeBatch methods on java.sql.Statement:

http://download.oracle.com/javase/1.4.2/docs/api/java/sql/Statement.html#executeBatch()

thanks,

bryan