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
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 wrote:
> Hello,
>
> I'd like to execute multiple insert statements over JDBC at once, but can't
> get it work ;(
>
> Here a small demo:
>
> ...
>
>
But shouldn't it works with JDBC too ?
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(