Re: oracle PK generation problem?

From: Martin Ruff (mruf..imeon.ch)
Date: Wed Jun 11 2003 - 14:07:38 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

    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.



    This archive was generated by hypermail 2.0.0 : Wed Jun 11 2003 - 14:06:08 EDT