IdentityGenerator doesn't support BigInteger as a valid identity type. ---------------------------------------------------------------------- Key: HHH-1936 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1936 Project: Hibernate3 Type: Bug

Components: core Versions: 3.0.5 Environment: Hibernate 3.0.5, Sybase 12.05, Window/ Unix Reporter: Leonid Shtivelman

Identity generator strategy doesn't support BigInteger as a valid id type. This causes problem with Sybase which requires identity column to be numeric. It would seem an obvious way to get around this problem is to set column mapping to long in hibernate xml and the actual java object. This will solve obvious problem of creating identity, but will cause performance problem on selection. In order for Sybase to use index for parameter query the variable type of the parameter and column index type has to be the same. If ones maps column type to Long, Hibernate will use JDBC method setLong(long) to set value in the prepared statement. This will cause mismatch between parameter type and column index type, and Sybase will not use index to locate index. As you can see this is a big problem for anyone that is using identity columns Sybase and Hibernate