Re: RES: RES: INSERT without specifying an parameter.

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Wed Feb 02 2005 - 12:42:12 EST

  • Next message: Joel Trunick: "RE: RES: INSERT without specifying an parameter."

    > Hi Andrus,
    > Well, I'm using the PostgreSQL to develop and a Oracle database at
    > production.
    >
    > I need a sequence number like: 1, 2, 3, 4... but Cayenne's sequence is:
    > 200, 220, 240... hehehhe
    >
    > This solution can be used other SQL database.
    >
    > And cayenne donīt work with a PostgreSQL Sequence.
    >
    > Tks, Reinaldo.

    Ok... there is a misunderstanding then, you don't need any of
    that...Cayenne 1.1 will work out of the box. A few points that will
    hopefully answer your questions.

    1. Cayenne PK generation mechanism
    (http://objectstyle.org/cayenne/userguide/design/autopk.html) is an
    *abstraction*. So you can use one DB in dev. and a different one in
    production, regardless of the fact that Cayenne will utilize different PK
    generation approach - the end result is the same. So I don't see why this
    should bother you at all.

    2. A gap of 20 is a sequence cache to improve performance. You can change
    it to 1 if you want to... but you probably don't -
    http://objectstyle.org/cayenne/api/cayenne/org/objectstyle/cayenne/dba/JdbcPkGenerator.html#setPkCacheSize(int)

    Hope this helps.
    Andrus

    This archive was generated by hypermail 2.0.0 : Wed Feb 02 2005 - 12:42:14 EST