[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1936?page=c... ] Andrew Thompson commented on HHH-1936: -------------------------------------- To break the original issue down a bit for clarity: * Sybase *requires* that all auto-increment identity columns be of type numeric: e.g. create table Foo ( foo_id numeric(9,0) identity ) * Sybase's JConnect drvier maps this to BigInteger (well BigDecimal really) in Java code [*] see below * Hibernate won't allow BigInteger as a primary key column for an object, due, I think, to code in IdentityGeneratorFactory which checks explicitly Result - we're caught between the proverbial rock and hard place. So to partially get around this, we do this: <id name="fooNum" column="foo_id" type="com.example.hibernate.usertype.NumericType"> <generator class="identity" /> </id> And NumericType is then a bit ghastly.... public class NumericType extends LongType { public void set(PreparedStatement st, Object value, int index) throws HibernateException, SQLException { st.setBigDecimal( index, new BigDecimal( BigInteger.valueOf(((Long)value).longValue()))); } public int sqlType() { return Types.NUMERIC; } } Basically the field in our class is then a Long and we fake out the mapping from Long to Numeric here. There's a side issue where every time we want to use HQL or criteria queries, we have to be very careful to always remember to call Query.setBigDecimal() and convert the Long to an BigInteger manually. If we don't do that (i.e. we call setLong or let Hibernate figure it out) then the Sybase JConnect driver emits SQL code which causes the database to ignore the index (because the types don't match) and we table scan the table. What we want to do is to change our class to use BigInteger as the id column, because that's really what is needed with Sybase, but the checks in Hibernate won't allow that. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira