Re: oracle PK generation problem?

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Wed Jun 11 2003 - 12:50:16 EDT

  • Next message: Martin Ruff: "Re: oracle PK generation problem?"

    > 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

    This archive was generated by hypermail 2.0.0 : Wed Jun 11 2003 - 12:50:16 EDT