Most of the Hibernate extensions like criteria builders and even some dynamic finders and counters will have to rely on the underlying Java types in order to work. You do this in ColdFusion by using the javaCast() function available to you. So if you are using a primary key that is an Integer you might have to do the following in order to match your variable to the underlying Java type:

criteria.eq( "id", javaCast( "int", arguments.id ) );

If you do not type it, then ColdFusion assumes it is a string and passes a string to Hibernate which will throw an exception as it is supposed to be an integer.

Auto Types

We have created two methods available to you in the base orm service, virtual service, criteria builders, active entity, etc to help you with these translations by automatically casting the values for you:

nullValue()

Produce a null value that can be used anywhere you like!

autoCast( entity, propertyName, value )

This method allows you to cast any value to the appropriate type in Java for the property passed in. The entity argument can be the entity name or an entity object.

idCast( entity, id )

This method allows you to cast the identifier value to the appropriate type in Java. The entity argument can be the entity name or an entity object.

Example

So instead of casting it manually you can just let us do the work:

criteria.eq( "id", criteria.idCast( arguments.id ) );