Hi finion

sorry for the late replay ,you r right HQL won't work with a long datatype field ,as u said the problem is with org.hibernate.dialect.DB2Dialect class the following line
registerColumnType( Types.BIGINT, "bigint" );

should be replaced by

registerColumnType( Types.BIGINT, "big_integer" );

as a work around u can add this modified class to your class path and modify hibernate.cfg.xml to use the modified class instead of hibernate DB2Dialect class for example instead of

<property name="dialect">org.hibernate.dialect.DB2Dialect</property>

u should use
<property name="dialect">[package-path].DB2Dialect</property>
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira