Hi guys,

I have an entity which has a field on it which is of type Long e.g.:


I then use the JPA Criteria API to generate a query to find MyEntity's by myLongField e.g.


What I am seeing is that Hibernate generates an SQL query with the long value with an "L" appended onto the end of it, e.g.:

This obviously causes an exception to be thrown:


I am using Hibernate-3.5.6-Final and MySQL 5.1

Any ideas on how to stop the "L" being appended onto the end of the long value?

Thanks,
Mark

I'll answer my own question here incase any one has a similar issue...

The CriteriaBuilder.equal method will use a LiteralExpression when the second argument to the equal method is an Object. The LiteralExpression uses a LongValueHandler to render the Long value and it is this handler that adds the "L" to the value (it will add F for floats, D for decimals, etc.).

The solutions I used are to either use a ParameterExpression for the long value or write your own NumericExpression which will render a Number value without adding "L', "F", "D", etc. Then pass this Expression object as being the second argument to the CriteriaBuilder.equal method

-Mark