Jim Newsham wrote:
Hi,
I have a related question.
Is getGeneratedKeys() any more efficient than executing a second query of
"values identity_val_local()"? I'm using the latter everywhere, and wonder
Not when I tested it recently. In fact the second query was slightly
faster! A bit disappoi
d mode.
Thanks,
Jim
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 10, 2007 2:16 AM
> To: Derby Discussion
> Subject: Re: Insert into Table (identity,CLOB) impossible ?? how to ?
>
> Van Vlierberghe, Steven wrote:
> >
Van Vlierberghe, Steven wrote:
Use case:
MyTable (id identity, data CLOB)
insert some bytes into the table and return the id of the record
Problem:
1. I need the generated key (identity), so I cannot use a PreparedStatement
beause with Derby, one can only get the generated key via
Statement
Use case:
MyTable (id identity, data CLOB)
insert some bytes into the table and return the id of the record
Problem:
1. I need the generated key (identity), so I cannot use a
PreparedStatement
beause with Derby, one can only get the generated key via
Statement.execute (sql, RETURN_GENERATED_KE
