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
The Apache Derby project is pleased to announce a new feature release
of Derby, 10.3.1.4.
Apache Derby is a subproject of the Apache DB project.
Derby is a pure Java relational database engine which conforms to the
ANSI SQL and JDBC standards. Derby aims to be easy for developers
and end-users
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
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,
Bernt,Kathy
Thanks for your replies.. I will do as suggested.
Teja wrote:
If the database doesn't exist, I need to initalize it, create some tables
and stuff... What should I do instead?
Daniel John Debrunner-2 wrote:
Teja wrote:
How do I check if the database exists already? I
Brenty, Kathy
Thanks a lot for your time. I will do as suggested.
Teja wrote:
If the database doesn't exist, I need to initalize it, create some tables
and stuff... What should I do instead?
Daniel John Debrunner-2 wrote:
Teja wrote:
How do I check if the database exists already? I