cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrus Adamchik <>
Subject Re: Problems with MySql id type with AUTO_INCREMENT
Date Tue, 29 Aug 2006 13:19:35 GMT

On Aug 29, 2006, at 4:16 PM, Tobias SCHOESSLER wrote:

> But still you are right there is a bug in mysql too. If the column  
> type is
> INT and not INT UNSIGNED it should return java.lang.Integer but it  
> returns
> java.lang.Long instead. This was my first observation.

Still probably worth fixing the mapping to follow the docs.

> but why does cayenne need BIGINT mapping set for the column to  
> retrieve it
> as a java.lang.Long? I understand that this is unrelated to the bug  
> in the
> mysql jdbc driver mentioned above.

This is simply a workaround for the bug. BIGINT has a default JDBC  
mapping to java.lang.Long. So this consistently produced a Long  
during select and when reading auto-incremented value via JDBC.


View raw message