Re: Problems with MySql id type with AUTO_INCREMENT

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Tue Aug 29 2006 - 05:00:30 EDT

  • Next message: Andrus Adamchik: "Re: Detecting when outer joins are needed"

    How is the column mapped in the Modeler? Have you tried mapping it as
    BIGINT?

    Andrus

    On Aug 28, 2006, at 1:22 PM, Tobias SCHOESSLER wrote:

    >
    > I use cayenne 1.2, MySql. AUTO_INCREMENT ids
    >
    > the type of the id field in the mysql schema is set to
    >
    > INT NOT NULL AUTO_INCREMENT UNIQUE
    >
    > I create an object of this table with cayenne and commit. I see the
    > row
    > inserted ok. When accessing the Id of the object via
    >
    > getObjectId().getIdSnapshot().get(this.FOLDER_UID_PK_COLUMN)
    >
    > in the same DataContext the type of the Object retruned is a Long.
    > (Though
    > I would have expected it to be an Integer from the MySql jdbc
    > documentation)
    >
    > When I use a fresh DataContext and retrieve the same row the id object
    > returned by
    >
    > getObjectId().getIdSnapshot().get(this.FOLDER_UID_PK_COLUMN)
    >
    > seems to be an Integer ?
    >
    >
    >
    > I tried to set the type to
    >
    > INT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE
    >
    > which is supposed to be of Long type from the jdbc type
    > documentation of
    > MySql.
    >
    > to force the id object always to be a Long but cayenne still
    > returns an
    > Integer when reading from the db.
    >
    > any ideas?
    >
    > thanks
    >
    >
    >
    >



    This archive was generated by hypermail 2.0.0 : Tue Aug 29 2006 - 05:01:23 EDT