[coldbox-3.5.0] criteria query + javacast

i have a list of ID’s that i want to get using a criteria query. the datatype of the column is numeric(10, 1).

the below code is throwing an error:


An unhandled exception has occurred. Please look at the diagnostic information below:
Type org.hibernate.exception.GenericJDBCException
Message could not execute query

Extended Info

Message could not execute query
Tag Context C:\inetpub\Frameworks\coldbox\coldbox_3_5\system\orm\hibernate\BaseORMService.cfc (1096)
C:\inetpub\Frameworks\coldbox\coldbox_3_5\system\orm\hibernate\VirtualEntityService.cfc (201)

oops. this is whats throwing the error:

return criteriaQuery(listCriteria);

ok. THIS is whats throwing the error:


return criteriaQuery(listCriteria);

the list contains ID’s that have decimals points.