Re: A problem with sequences...

>
>
>Before looking into more obscure possibilities, are you using the sequence to
>generate these explicit id's? If not, that's why you're getting duplicates,
>the sequence generator doesn't know you've used these numbers.
>
>
>
Yeah... I understand this.
In this case, the id is *never* specified explicitly. Java app either
knows the id or it does not.
If it knows it, it does the update, otherwise, it does an insert, with
*no* id specified, and gets the new id back from that rule, so that time
it will
know the id and end up doing update...

I was referring to the situation in general when somehow (like data
migration) the id is specified, I just don't want that rule to barf. It
is definitely not what's causing my problem. So, let's get into those
'obscure possibilities' now :-)

Thanks!

Dima.