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