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
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 to
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
if there's anything to be gained from changing to the former. Using
embedded mode.
Thanks,
Jim
> -Original
Hi
My system is : Windows XP
Java Standard Edition 6.0 (or 1.6)
and Sun's FileSystemContextProvider (for Jndi)
The Problem is,that i can not store the ClientDataSource and
ClientConnectionPoolDataSource
in the jndi context. A simple code fragment is
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
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
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
David Leader wrote:
Does it take that long to start if you use ij as well? Does it make a
difference wether you run embedded or not?
Using ij it certainly doesn't take as long, but there is a perceptable
lag before the database connection is made, and the first time a query
is made it is perc