[coldbox-3.5.0] criteria query + javacast

Communities ColdBox HMVC
1

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:

arrayAppend(criteria,restrictions.in(“controlNum”,JavaCast(“java.lang.Double[]”,[2.1,5.1,9.3])));

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

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)

2

oops. this is whats throwing the error:

return criteriaQuery(listCriteria);

3

ok. THIS is whats throwing the error:

arrayAppend(listCriteria,restrictions.in(“controlNum”,JavaCast(“java.lang.Double[]”,listToArray(valueList(result.controlNum)))));

return criteriaQuery(listCriteria);

the list contains ID’s that have decimals points.