# Caused by: org.hibernate.query.SemanticException: Cannot compare left expression of type 'java.io.Serializable' with right expression of type 'java.lang.Long'

**URL:** <https://discourse.hibernate.org/t/caused-by-org-hibernate-query-semanticexception-cannot-compare-left-expression-of-type-java-io-serializable-with-right-expression-of-type-java-lang-long/8582>\
**Category:** Hibernate ORM\
**Created:** [November 21, 2023, 8:08am UTC](https://discourse.hibernate.org/t/caused-by-org-hibernate-query-semanticexception-cannot-compare-left-expression-of-type-java-io-serializable-with-right-expression-of-type-java-lang-long/8582 "2023-11-21T08:08:45Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![smallbun](https://yyz1.discourse-cdn.com/flex035/user_avatar/discourse.hibernate.org/smallbun/32/2815_2.png) [@smallbun](https://discourse.hibernate.org/u/smallbun)\
**Post date:** [November 21, 2023, 8:08am UTC](https://discourse.hibernate.org/t/caused-by-org-hibernate-query-semanticexception-cannot-compare-left-expression-of-type-java-io-serializable-with-right-expression-of-type-java-lang-long/8582/1 "2023-11-21T08:08:45Z")

</div>

```auto
Caused by: org.hibernate.query.SemanticException: Cannot compare left expression of type 'java.io.Serializable' with right expression of type 'java.lang.Long'
	at org.hibernate.query.sqm.internal.TypecheckUtil.assertComparable(TypecheckUtil.java:338)
	at org.hibernate.query.sqm.tree.predicate.SqmComparisonPredicate.<init>(SqmComparisonPredicate.java:48)
	at org.hibernate.query.sqm.tree.predicate.SqmComparisonPredicate.<init>(SqmComparisonPredicate.java:34)
	at org.hibernate.query.sqm.internal.SqmCriteriaNodeBuilder.equal(SqmCriteriaNodeBuilder.java:2070)
	at org.hibernate.query.sqm.internal.SqmCriteriaNodeBuilder.equal(SqmCriteriaNodeBuilder.java:189)
	at org.springframework.data.jpa.repository.query.JpaQueryCreator$PredicateBuilder.build(JpaQueryCreator.java:312)
	at org.springframework.data.jpa.repository.query.JpaQueryCreator.toPredicate(JpaQueryCreator.java:210)
	at org.springframework.data.jpa.repository.query.JpaQueryCreator.create(JpaQueryCreator.java:121)
	at org.springframework.data.jpa.repository.query.JpaQueryCreator.create(JpaQueryCreator.java:60)
	at org.springframework.data.repository.query.parser.AbstractQueryCreator.createCriteria(AbstractQueryCreator.java:119)
	at org.springframework.data.repository.query.parser.AbstractQueryCreator.createQuery(AbstractQueryCreator.java:95)
	at org.springframework.data.repository.query.parser.AbstractQueryCreator.createQuery(AbstractQueryCreator.java:81)
	at org.springframework.data.jpa.repository.query.PartTreeJpaQuery$QueryPreparer.<init>(PartTreeJpaQuery.java:218)
	at org.springframework.data.jpa.repository.query.PartTreeJpaQuery$CountQueryPreparer.<init>(PartTreeJpaQuery.java:361)
	at org.springframework.data.jpa.repository.query.PartTreeJpaQuery.<init>(PartTreeJpaQuery.java:102)
	... 54 common frames omitted

```

spring-data-jpa issues: [Caused by: org.hibernate.query.SemanticException: Cannot compare left expression of type 'java.io.Serializable' with right expression of type 'java.lang.Long' · Issue #3235 · spring-projects/spring-data-jpa · GitHub](https://github.com/spring-projects/spring-data-jpa/issues/3235)

Use this example to reproduce:

[https://github.com/spring-projects/spring-data-jpa/files/13422002/issues-3235.zip](https://github.com/spring-projects/spring-data-jpa/files/13422002/issues-3235.zip)

---

<div class="post-metadata">

**Author:** ![mbladel](https://yyz1.discourse-cdn.com/flex035/user_avatar/discourse.hibernate.org/mbladel/32/2128_2.png) [@mbladel](https://discourse.hibernate.org/u/mbladel)\
**Post date:** [November 21, 2023, 1:19pm UTC](https://discourse.hibernate.org/t/caused-by-org-hibernate-query-semanticexception-cannot-compare-left-expression-of-type-java-io-serializable-with-right-expression-of-type-java-lang-long/8582/2 "2023-11-21T13:19:54Z")

</div>

Hello and thank you for reporting this issue here too. I’ve created this Jira ticket [[HHH-17454] - Hibernate JIRA](https://hibernate.atlassian.net/browse/HHH-17454), you can follow that for any updates.

---

<div class="post-metadata">

**Author:** ![smallbun](https://yyz1.discourse-cdn.com/flex035/user_avatar/discourse.hibernate.org/smallbun/32/2815_2.png) [@smallbun](https://discourse.hibernate.org/u/smallbun)\
**Post date:** [November 22, 2023, 1:02am UTC](https://discourse.hibernate.org/t/caused-by-org-hibernate-query-semanticexception-cannot-compare-left-expression-of-type-java-io-serializable-with-right-expression-of-type-java-lang-long/8582/3 "2023-11-22T01:02:43Z")

</div>

Can this version be fixed in version 6.3? Springboot3.2 currently relies on hibernate6.3x.

---

<div class="post-metadata">

**Author:** ![mbladel](https://yyz1.discourse-cdn.com/flex035/user_avatar/discourse.hibernate.org/mbladel/32/2128_2.png) [@mbladel](https://discourse.hibernate.org/u/mbladel)\
**Post date:** [November 22, 2023, 4:53pm UTC](https://discourse.hibernate.org/t/caused-by-org-hibernate-query-semanticexception-cannot-compare-left-expression-of-type-java-io-serializable-with-right-expression-of-type-java-lang-long/8582/4 "2023-11-22T16:53:55Z")

</div>

Please see my reply on the Jira.

---

<div class="post-metadata">

**Author:** ![WagnerCosta](https://yyz1.discourse-cdn.com/flex035/user_avatar/discourse.hibernate.org/wagnercosta/32/2944_2.png) [@WagnerCosta](https://discourse.hibernate.org/u/WagnerCosta)\
**Post date:** [January 22, 2024, 9:43am UTC](https://discourse.hibernate.org/t/caused-by-org-hibernate-query-semanticexception-cannot-compare-left-expression-of-type-java-io-serializable-with-right-expression-of-type-java-lang-long/8582/5 "2024-01-22T09:43:38Z")

</div>

Hi, is there a fix for the problem, I had to rollback from 3.2 to 3.1.8 due to incompatibility

---

<div class="post-metadata">

**Author:** ![amirensit](https://yyz1.discourse-cdn.com/flex035/user_avatar/discourse.hibernate.org/amirensit/32/3039_2.png) [@amirensit](https://discourse.hibernate.org/u/amirensit)\
**Post date:** [February 20, 2024, 6:21am UTC](https://discourse.hibernate.org/t/caused-by-org-hibernate-query-semanticexception-cannot-compare-left-expression-of-type-java-io-serializable-with-right-expression-of-type-java-lang-long/8582/6 "2024-02-20T06:21:34Z")

</div>

I have this problem with spring boot 3.2 and hubernate 6.3  
Even rollback to spring boot 3.1.8 and hibernate 6.1 didn’t solve the problem.

Any help !!