No, I think this adds value, though I am not ready to jump on it right away:
1. It does save a trip to the database (well, depending on how this is done
in the driver, but I am sure there will be performance increase in most
cases).
2. It allows to avoid extra objects in the schema generated purely for the
PK generation sake.
3. It caters to people who have existing databases used by other
applications.
Andrus
Dirk Olmes writes:
>
>>> Don't most of the drivers have some way of retrieving this data? In
>>> mysql you have the last_insert_id function, in Oracle you have the
>>> curr_value of the sequence on the particular connection (I *think* this
>>> is threadsafe. We did an experiment where several of us were inserting
>>> via SQLPlus and inserts outside our own connections were not affecting
>>> our own curr_value).
>>
>> I am too spoiled by using WebObjects/EOF, and now Cayenne :-). I rarely
>> had to use driver-specific tricks. But if at least some drivers have
>> their own mechanism for reading back generated values, I am all for
>> adding this feature to Cayenne.
>
> I just can't help but adding my 0.01 EUR here again ... What's the use of
> that feature (apart from feature-completeness)?
>
> This will only complicate things on the adaptor layer of cayenne. If it
> were to save round-trips to the database I'd be happy but this isn't the
> case here. So what's the use?
>
> Maybe I'm too puristic here? :-)
>
> -dirk
>
This archive was generated by hypermail 2.0.0 : Mon Jan 06 2003 - 16:01:54 EST