Hi Andrus,
Sorry, it was our fault, we did not create the sequences correctely, now
we created them correctelly and it works
we did not apply the INCREMENT BY 20 now as we did, it works
martin
>
>>> Hi,
>>> in our project were just switching from mysql to oracle. now we have
>>> the problem: If we try to insert more than 20 entries in a table we
>>> get: java.sql.BatchUpdateException: ORA-00001: unique constraint
>>> (CMUSER_DEV.PK_CM_USER1) violated
>>> I've debugged into the cayenne code and saw that the default key
>>> cache size is 20, could it be that cayenne has a bug creating PK for
>>> oracle? we're using cayenne-1.0b1
>>> for every table we created the according PK_table name sequence in
>>> oracle with cache size 20
>>> thanks for help
>>> martin
>>>
>>
>> Marting,
>>
>> Try upgrading to 1.0b3 - there was a bunch of fixes in this area since
>> than. If the same problem happens on b3, then we will look into that.
>>
>> Andrus
>
> Hi Andrus,
> I've updated to 1.0b3, still the same behaviour, is there something I
> could have overlooked when creating the sequences in oracle?
> by the way oracle version we use is: Oracle9i Enterprise Edition Release
> 9.0.1.3.1
> thanks martin
>
>
> -------------------------------------------
> Be the change you want to see in the world.
-------------------------------------------
Be the change you want to see in the world.
This archive was generated by hypermail 2.0.0 : Wed Jun 11 2003 - 14:21:48 EDT