Re: How to change the auto pk increment to 1?

From: Tore Halset (halse..vv.ntnu.no)
Date: Sun Jan 01 2006 - 16:18:37 EST

  • Next message: Ahmed Mohombe: "Re: How to change the auto pk increment to 1?"

    On Dec 31, 2005, at 15:13, Ahmed Mohombe wrote:

    > Doing several inserts in the same table with Cayenne (in different
    > transactions), it seems that the PK is incremented by 20. I
    > understood that Cayenne is doing some cache or something, but IMHO in
    > many cases this behavior is not desired at all.
    >
    > Is it possible to configure Cayenne somehow so that for the *same*
    > table the PKs are
    > incremented by *1* not 20? (the same way how Mysql or Access or
    > other autoincremented columns work in those DBs?)

    This has been discussed on the list. Take a look at these messages
    from Andrus:

    http://www.objectstyle.org/cayenne/lists/cayenne-user/2003/01/0032.html
    http://www.objectstyle.org/cayenne/lists/cayenne-user/2005/02/0034.html

    or explore using google:
    http://www.google.com/search?q=setPkCacheSize+site:.objectstyle.org

      - Tore.

    This archive was generated by hypermail 2.0.0 : Sun Jan 01 2006 - 16:18:41 EST