dev@glassfish.java.net

Re: SQLAnyhwhere: Is it OK to "fake" a sequence?

From: Tom Ware <tom.ware_at_oracle.com>
Date: Tue, 09 Jan 2007 11:49:17 -0500

Hi Markus,

  Can you point me to the code that is "faking" a sequence in your platform.

-Tom

Lance J. Andersen wrote:

>Hi Markus,
>
>Perhaps i missed it, can u explain why you feel you need to fake this?
>
>If the Database does not support SEQUENCE, i would not fake it.
>
>Having support for IDENTITY is enough.
>
>Once/IF ASA implements SEQUENCE then it is worth adding to ASA support
>in Toplink Essentials. Until then i would avoid adding this feature.
>
>regards
>Lance
>
>-lance
>
>
>Markus KARG wrote:
>
>
>>Tom,
>>
>>another open question: As you know, I have "faked" support for SQL
>>sequences by using IDENTITY columns. Actually, for JPA a SEQUENCE is
>>not the same than an IDENTITY column. At least the @GeneratedValue
>>annotation lets the user decide whether SEQUENCE or IDENTITY shall be
>>used. So is my decision wrong? Shall I remove the fake (then it should
>>be removed from the SybasePlatform, too)? What is the "political
>>decision" for "faking features"?
>>
>>Thanks
>>Markus
>>
>>
>
>
>

-- 
Tom Ware
Principal Software Engineer
Oracle Canada Inc.
Direct: (613) 783-4598
Email: tom.ware_at_oracle.com