Is there a better way to create a SQL null value with CriteriaBuilder than
criteriaBuilder.quot(criteriaBuilder.literal(0), criteriaBuilder.literal(0))
?
Asked
Active
Viewed 5,337 times
10
mazatwork
- 1,275
- 1
- 13
- 20
-
3Have you tried with [CriteriaBuilder#nullLiteral](http://docs.oracle.com/javaee/6/api/javax/persistence/criteria/CriteriaBuilder.html#nullLiteral%28java.lang.Class%29)? – perissf Jun 14 '13 at 15:10
-
2`criteriaBuilder.nullLiteral(Integer.class)` works! – mazatwork Jun 17 '13 at 08:38
-
Great. I am going to add the answer. – perissf Jun 17 '13 at 08:45
1 Answers
22
The easiest way is to use the method CriteriaBuilder#nullLiteral() which does exactly that. Since you need a null Integer, use it with Integer Class:
Expression<Integer> expr = criteriaBuilder.nullLiteral(Integer.class);
perissf
- 15,979
- 14
- 80
- 117