org.hibernate.TypeMismatchException：二进制逻辑运算符的左侧和右侧不兼容 [英] org.hibernate.TypeMismatchException: left and right hand sides of a binary logic operator were incompatibile
本文介绍了org.hibernate.TypeMismatchException：二进制逻辑运算符的左侧和右侧不兼容的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
在 Product 之间，由 Hibernate 4.2.0 CR1 （最近升级到Hibernate 4.2.7 final）提供了JPA 2.0中的多对多关系。 c $ c>和 Color 如下。
public class Product implements Serializable
{
private static final long serialVersionUID = 1L ;
@Id
@GeneratedValue（strategy = GenerationType.IDENTITY）
@Basic（可选= false）
@Column（name =prod_id）
私人长期产品;
@JoinTable（name =prod_colour，joinColumns = {
@JoinColumn（name =prod_id，referencedColumnName =prod_id）}，inverseJoinColumns = {
@JoinColumn （name =colour_id，referencedColumnName =colour_id）}）
@ManyToMany（fetch = FetchType.EAGER）
private Set< Color> colourSet;
// Setter和getters。
public class Color实现Serializable
{
private static final long serialVersionUID = 1L;
@Id
@GeneratedValue（strategy = GenerationType.IDENTITY）
@Basic（可选= false）
@Column（name =colour_id）
私人长款colourId;
@ManyToMany（mappedBy =colourSet，fetch = FetchType.EAGER）
private Set< Product> productSet;
// Setter和getters。
$ b 从颜色获取颜色列表基于 prodId 提供的表，它与 prod_colour 表中的颜色不匹配（连接表），我正在执行以下条件查询。
CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder（）;
CriteriaQuery< Color> criteriaQuery = criteriaBuilder.createQuery（Colour.class）;
Metamodel metamodel = entityManager.getMetamodel（）;
EntityType< Color> entityType = metamodel.entity（Colour.class）;
Root< Color> root = criteriaQuery.from（entityType）;
criteriaQuery.select（root）;
子查询< Long> subquery = criteriaQuery.subquery（Long.class）;
Root<产品> subRoot = subquery.from（Product.class）;
subquery.select（root.get（Colour_.colourId））;
谓词paramPredicate = criteriaBuilder.equal（subRoot.get（Product_.prodId），prodId）;
Predicate correlatePredicate = criteriaBuilder.equal（root.get（Colour_.productSet），subRoot）;
subquery.where（criteriaBuilder.and（paramPredicate，correlatePredicate））;
criteriaQuery.where（criteriaBuilder.in（root.get（Colour_.colourId））.value（subquery）.not（））;
criteriaQuery.orderBy（criteriaBuilder.desc（root.get（Colour_.colourId）））;
TypedQuery< Color> typedQuery = entityManager.createQuery（criteriaQuery）;
List< Color> list = typedQuery.getResultList（）;
这个标准查询会引发以下异常。
org.hibernate.TypeMismatchException：
二元逻辑运算符的左侧和右侧不兼容
[java.util.Set（model.Colour.productSet ）：model.Product]
然而，以下JPQL有效。
FROM颜色颜色
WHERE colour.colourId
不在（
SELECT colours.colourId
FROM产品产品
INNER JOIN产品。 colourSet colour
WHERE product.prodId =：id）
ORDER BY colour.colourId DESC
这种例外的原因是什么。如何使这个标准查询工作？相同的标准查询以某种方式在EclipseLink提供的JPA中工作。
堆栈跟踪：
SEVERE：渲染视图[/ admin_side / ProductColour。 xhtml]
javax.el.ELException：/admin_side/ProductColour.xhtml @ 28,121 rendered =＃{not empty productColourManagedBean.colourList}：读取类型为colourList的错误admin.mangedbean.ProductColourManagedBean
at com.sun.faces.facelets.el.TagValueExpression.getValue（TagValueExpression.java:114）在javax.faces.component.ComponentStateHelper.eval上的
（ComponentStateHelper.java:194）在javax.faces上的
。 component.UIComponentBase.isRendered（UIComponentBase.java:457）
在org.primefaces.renderkit.CoreRenderer.renderChild（CoreRenderer.java:63）
在org.primefaces.renderkit.CoreRenderer.renderChildren（CoreRenderer。 java：57）
org.primefaces.component.panel.PanelRenderer.encodeContent（Panel
org.primefaces.component.panel.PanelRenderer.encodeEnd（PanelRenderer.java：Renderer.java:204） 58）
at javax.faces.component.UIComponentBase.encodeEnd（UIComponentBase.java:919）
at javax.faces.component.UIComponent.encodeAll（UIComponent.java:1903）
at javax .faces.render.Renderer.encodeChildren（Renderer.java:176）
at javax.faces.component.UIComponentBase.encodeChildren（UIComponentBase.java:889）
at org.primefaces.renderkit.CoreRenderer.renderChild （CoreRenderer.java:70）
at org.primefaces.renderkit.CoreRenderer.renderChildren（CoreRenderer.java:57）
at org.primefaces.component.layout.LayoutUnitRenderer.encodeEnd（LayoutUnitRenderer.java:51 ）
at javax.faces.component.UIComponentBase.encodeEnd（UIComponentBase.java:919）
at javax.faces.component.UIComponent.encodeAll（UIComponent.java:1903）
at javax。 faces.compon ent.UIComponent.encodeAll（UIComponent.java:1899）
在javax.faces.component.UIComponent.encodeAll（UIComponent.java:1899）
在javax.faces.component.UIComponent.encodeAll（UIComponent。 Java的：在com.sun.faces.application.view.MultiViewHandler.renderView（MultiViewHandler在com.sun.faces.application.view.FaceletViewHandlingStrategy.renderView 1899）
（FaceletViewHandlingStrategy.java:451）
。 java：131）
at com.sun.faces.lifecycle.RenderResponsePhase.execute（RenderResponsePhase.java:120）
at com.sun.faces.lifecycle.Phase.doPhase（Phase.java:101）
at com.sun.faces.lifecycle.LifecycleImpl.render（LifecycleImpl.java:219）
at javax.faces.webapp.FacesServlet.service（FacesServlet.java:647）
at org .apache.catalina.core.ApplicationFilterChain.internalDoFilter（ApplicationFilterChain.java:305）
在org.apache.catalina.core.ApplicationFilterChain.doFilter（ApplicationFilterChain.java:210）
在org.primefaces.webapp .filter.FileUp loadFilter.doFilter（FileUploadFilter.java:70）
在org.apache.catalina.core.ApplicationFilterChain.internalDoFilter（ApplicationFilterChain.java:243）
在org.apache.catalina.core.ApplicationFilterChain.doFilter（ ApplicationFilterChain.java:210）
在filter.NoCacheFilter.doFilter（NoCacheFilter.java:27）
在org.apache.catalina.core.ApplicationFilterChain.internalDoFilter（ApplicationFilterChain.java:243）
在org.apache.catalina.core.ApplicationFilterChain.doFilter（ApplicationFilterChain.java:210）
在org.springframework.security.web.FilterChainProxy $ VirtualFilterChain.doFilter（FilterChainProxy.java:330）
。在组织.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke（FilterSecurityInterceptor.java:118）
在org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter（FilterSecurityInterceptor.java:84）
at org.springframework.security.web.FilterChainProxy $ VirtualFilterChain.doFi滤波器（FilterChainProxy.java:342）
处org.springframework.security.web.FilterChainProxy $ VirtualFilterChain org.springframework.security.web.access.ExceptionTranslationFilter.doFilter（ExceptionTranslationFilter.java:113）
。 doFilter（FilterChainProxy.java:342）
at org.springframework.security.web.session.SessionManagementFilter.doFilter（SessionManagementFilter.java:103）
at org.springframework.security.web.FilterChainProxy $ VirtualFilterChain。的doFilter（FilterChainProxy.java:342）
处org.springframework.security.web.FilterChainProxy $ VirtualFilterChain org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter（AnonymousAuthenticationFilter.java:113）
。 doFilter（FilterChainProxy.java:342）
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter（SecurityContextHolderAwareRequestFilter.java:150）
at org.springframework.security.web.FilterChainProxy $ VirtualFilterCha in.doFilter（FilterChainProxy.java:342）
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter（RequestCacheAwareFilter.java:45）
at org.springframework.security.web.FilterChainProxy $ VirtualFilterChain.doFilter（FilterChainProxy.java:342）
位于org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter（BasicAuthenticationFilter.java:150）
位于org.springframework.security.web。 FilterChainProxy $ VirtualFilterChain.doFilter（FilterChainProxy.java:342）
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter（AbstractAuthenticationProcessingFilter.java:183）
at org.springframework.security.web。 FilterChainProxy $ VirtualFilterChain.doFilter（FilterChainProxy.java:342）
在org.springframework.security.web.authentication.logout.LogoutFilter.doFilter（LogoutFilter.java:105）
在org.springframework.security。 web.FilterChainProxy $ VirtualFilterChain.d在org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal oFilter（FilterChainProxy.java:342）
（WebAsyncManagerIntegrationFilter.java:50）
。在org.springframework.web.filter。 OncePerRequestFilter.doFilter（OncePerRequestFilter.java:107）维持在org.springframework.security.web.session org.springframework.security.web.FilterChainProxy $ VirtualFilterChain.doFilter（FilterChainProxy.java:342）
。 ConcurrentSessionFilter.doFilter（ConcurrentSessionFilter.java:125）维持在org.springframework.security.web.context org.springframework.security.web.FilterChainProxy $ VirtualFilterChain.doFilter（FilterChainProxy.java:342）
。 SecurityContextPersistenceFilter.doFilter（SecurityContextPersistenceFilter.java:87）维持在org.springframework.security.web.access org.springframework.security.web.FilterChainProxy $ VirtualFilterChain.doFilter（FilterChainProxy.java:342）
。 channel.ChannelProcessingFilter.doFilter（C hannelProcessingFilter.java:144）
在org.springframework.security.web.FilterChainProxy $ VirtualFilterChain.doFilter（FilterChainProxy.java:342）
在org.springframework.security.web.FilterChainProxy.doFilterInternal（的FilterChainProxy。 Java的：192），美元，org.springframework.security.web.FilterChainProxy.doFilter（FilterChainProxy.java:160 b $ b）
在org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate（DelegatingFilterProxy.java:346）在org.springframework.web.filter.DelegatingFilterProxy.doFilter（DelegatingFilterProxy.java:259）
在org.apache.catalina.core.ApplicationFilterChain.internalDoFilter（ApplicationFilterChain.java:243）
在org.apache.catalina.core.ApplicationFilterChain.doFilter（ApplicationFilterChain.java:210）
at org.apache.catalina.core.StandardWrapperValve.invoke（StandardWrapperValve.java:222）
at org.apache .catalina.core.StandardContextValve.invoke（StandardContextValve.java:123）
at org.apache.c atalina.authenticator.AuthenticatorBase.invoke（AuthenticatorBase.java:472）
at org.apache.catalina.core.StandardHostValve.invoke（StandardHostValve.java:171）
at org.apache.catalina.valves。 ErrorReportValve.invoke（ErrorReportValve.java:99）
at org.apache.catalina.valves.AccessLogValve.invoke（AccessLogValve.java:936）
at org.apache.catalina.core.StandardEngineValve.invoke（ StandardEngineValve.java:118）
at org.apache.catalina.connector.CoyoteAdapter.service（CoyoteAdapter.java:407）
at org.apache.coyote.http11.AbstractHttp11Processor.process（AbstractHttp11Processor.java： 1004）
at org.apache.coyote.AbstractProtocol $ AbstractConnectionHandler.process（AbstractProtocol.java:589）
at org.apache.tomcat.util.net.AprEndpoint $ SocketProcessor.run（AprEndpoint.java： 1822）
在java.util.concurrent.ThreadPoolExecutor.runWorker（ThreadPoolExecutor.java:1110）
在java.util.concurrent.ThreadPoolExecutor $ Worker.run（ThreadPoolExecuto r.java:603）
在java.lang.Thread.run（Thread.java:722）
导致：javax.el.ELException：读取类型为colourList的错误admin.mangedbean.ProductColourManagedBean
at javax.el.BeanELResolver.getValue（BeanELResolver.java:98）
at com.sun.faces.el.DemuxCompositeELResolver._getValue（DemuxCompositeELResolver.java:176）
at com.sun .faces.el.DemuxCompositeELResolver.getValue（DemuxCompositeELResolver.java:203）
at org.apache.el.parser.AstValue.getValue（AstValue.java:183）
at org.apache.el.parser .AstEmpty.getValue（AstEmpty.java:47）
at org.apache.el.parser.AstNot.getValue（AstNot.java:44）
at org.apache.el.ValueExpressionImpl.getValue（ValueExpressionImpl .java：185）
at com.sun.faces.facelets.el.TagValueExpression.getValue（TagValueExpression.java:109）
... 82 more
由javax.persistence引起。 PersistenceException：org.hibernate.TypeMismatchException：我们的二元逻辑运算符的左侧和右侧re incompatibile [java.util.Set（model.Colour.productSet）：model.Product]
at org.hibernate.ejb.AbstractEntityManagerImpl.convert（AbstractEntityManagerImpl.java:1387）
at org.hibernate。 ejb.AbstractEntityManagerImpl.convert（AbstractEntityManagerImpl.java:1310）
在org.hibernate.ejb.AbstractEntityManagerImpl.createQuery（AbstractEntityManagerImpl.java:470）
在org.hibernate.ejb.criteria.CriteriaQueryCompiler.compile（ CriteriaQueryCompiler.java:221）
at org.hibernate.ejb.AbstractEntityManagerImpl.createQuery（AbstractEntityManagerImpl.java:587）
at sun.reflect.NativeMethodAccessorImpl.invoke0（Native Method）
at sun。 reflect.NativeMethodAccessorImpl.invoke（NativeMethodAccessorImpl.java:57）
在sun.reflect.DelegatingMethodAccessorImpl.invoke（DelegatingMethodAccessorImpl.java:43）
在java.lang.reflect.Method.invoke（Method.java： 601）
在org.springframework.orm.jpa.SharedEntityManagerCreator $ SharedEntityManagerInvocati onHandler.invoke（SharedEntityManagerCreator.java:241）
at $ Proxy98.createQuery（Unknown Source）
at admin.dao.ProductColourDAO.getList（ProductColourDAO.java:143）
at sun.reflect .NativeMethodAccessorImpl.invoke0（本机方法）
在sun.reflect.NativeMethodAccessorImpl.invoke（NativeMethodAccessorImpl.java:57）
在sun.reflect.DelegatingMethodAccessorImpl.invoke（DelegatingMethodAccessorImpl.java:43）
在java.lang.reflect.Method.invoke（Method.java:601）
在org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection（AopUtils.java:317）
在org.springframework.aop .framework.ReflectiveMethodInvocation.invokeJoinpoint（ReflectiveMethodInvocation.java:183）
在org.springframework.aop.framework.ReflectiveMethodInvocation.proceed（ReflectiveMethodInvocation.java:150）
在org.springframework.security.access.intercept .aopalliance.MethodSecurityInterceptor.invoke（MethodSecurityInterceptor.java:64）
at org.s pringframework.aop.framework.ReflectiveMethodInvocation.proceed（ReflectiveMethodInvocation.java:172）
在org.springframework.transaction.interceptor.TransactionInterceptor $ 1.proceedWithInvocation（TransactionInterceptor.java:96）
在org.springframework.transaction .interceptor.TransactionAspectSupport.invokeWithinTransaction（TransactionAspectSupport.java:260）
在org.springframework.transaction.interceptor.TransactionInterceptor.invoke（TransactionInterceptor.java:94）
在org.springframework.aop.framework.ReflectiveMethodInvocation .proceed（ReflectiveMethodInvocation.java:172）
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke（JdkDynamicAopProxy.java:204）
at $ Proxy120.getList（Unknown Source）
at admin.mangedbean.ProductColourManagedBean.getColourList（ProductColourManagedBean.java:61）
at sun.reflect.NativeMethodAccessorImpl.invoke0（Native Method）$ b $ at sun.reflect.NativeMethodAccessorImpl.invoke（NativeMetho
at sun.reflect.DelegatingMethodAccessorImpl.invoke（DelegatingMethodAccessorImpl.java:43）
at java.lang.reflect.Method.invoke（Method.java:601）
在javax.el.BeanELResolver.getValue（BeanELResolver.java:87）
... 89 more
引起：org.hibernate.TypeMismatchException：二进制逻辑运算符的左侧和右侧不兼容[ java.util.Set（model.Colour.productSet）：model.Product]
at org.hibernate.hql.internal.ast.tree.BinaryLogicOperatorNode.mutateRowValueConstructorSyntaxesIfNecessary（BinaryLogicOperatorNode.java:89）
at org .hibernate.hql.internal.ast.tree.BinaryLogicOperatorNode.initialize（BinaryLogicOperatorNode.java:78）
at org.hibernate.hql.internal.ast.HqlSqlWalker.prepareLogicOperator（HqlSqlWalker.java:1224）
在org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.comparisonExpr（HqlSqlBaseWalker.java:4371）
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.logicalExpr（ HqlSqlBaseWalker.java:2076）美元，org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.logicalExpr（HqlSqlBaseWalker.java:2004 B $ B）
在org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.whereClause（ HqlSqlBaseWalker.java:794）
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.query（HqlSqlBaseWalker.java:595）
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.collectionFunctionOrSubselect（ HqlSqlBaseWalker.java:4644）美元，org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.comparisonExpr（HqlSqlBaseWalker.java:4347 b $ b）
在org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.logicalExpr（ HqlSqlBaseWalker.java:2076）美元，org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.logicalExpr（HqlSqlBaseWalker.java:2051 b $ b）
在org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.whereClause（ HqlSqlBaseWalker.java:794）美元，org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.query（HqlSqlBaseWalker.java:595 b $ b）
在org.hibernate.hql.internal.antlr.HqlS qlBaseWalker.selectStatement（HqlSqlBaseWalker.java:299）
处org.hibernate.hql.internal.ast org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.statement（HqlSqlBaseWalker.java:247）
。 QueryTranslatorImpl.analyze（QueryTranslatorImpl.java:248）
处org.hibernate.hql.internal.ast org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile（QueryTranslatorImpl.java:183）
。 QueryTranslatorImpl.compile（QueryTranslatorImpl.java:136）
位于org.hibernate.engine.query.spi.HQLQueryPlan。< init>（HQLQueryPlan.java:105）
位于org.hibernate.engine.query .spi.HQLQueryPlan。< init>（HQLQueryPlan.java:80）
at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan（QueryPlanCache.java:168）
at org.hibernate。 internal.AbstractSessionImpl.getHQLQueryPlan（AbstractSessionImpl.java:221）
。在org.hibernate.internal.AbstractSessionImpl.createQuery（AbstractSessionImpl.java:199）
。在org.hibernate.internal.SessionImpl.createQuery（S
at org.hibernate.ejb.AbstractEntityManagerImpl.createQuery（AbstractEntityManagerImpl.java:452）
... 119 more
标准查询应该从颜色表格中获取颜色列表基于 prodId 提供，它与 prod_colour 表中的颜色不匹配（可能是连接查询，子查询或其他任何东西）。解决方案以下标准查询按预期完美工作。
CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder（）;
CriteriaQuery< Tuple> criteriaQuery = criteriaBuilder.createTupleQuery（）;
Metamodel metamodel = entityManager.getMetamodel（）;
EntityType< Color> entityType = metamodel.entity（Colour.class）;
Root< Color> root = criteriaQuery.from（entityType）;
criteriaQuery.multiselect（root.get（Colour_.colourId），root.get（Colour_.colourName），root.get（Colour_.colourHex））;
子查询< Long> subquery = criteriaQuery.subquery（Long.class）;
Root< Color> subRoot = subquery.from（Colour.class）;
subquery.select（subRoot.get（Colour_.colourId））;
SetJoin< Color，Product> join = subRoot.join（Colour_.productSet，JoinType.INNER）;
ParameterExpression< Long> parameterExpression = criteriaBuilder.parameter（Long.class）;
criteriaQuery.where（criteriaBuilder.in（root.get（Colour_.colourId））.value（subquery）.not（））;
subquery.where（criteriaBuilder.equal（join.get（Product_.prodId），parameterExpression））;
TypedQuery< Tuple> typedQuery = entityManager.createQuery（criteriaQuery）;
List< Tuple> list = typedQuery.setParameter（parameterExpression，1L）.getResultList（）;
导致以下SQL查询。
select
colour0_.colour_id as col_0_0_，
colour0_.colour_name as col_1_0_，
colour0_.colour_hex as col_2_0_
from
social_networking .colour colour0_
其中
colour0_.colour_id不在（
选择
colour1_.colour_id
从
social_networking.colour colour1_
内部连接
prod_colour productset2_
on colour1_.colour_id = productset2_.colour_id
内部连接
social_networking.product product3_
on productset2_.prod_id = product3_.prod_id
其中
product3_.prod_id =？
）
虽然它是 Tuple 查询，可以对实体执行相同的查询。就我而言，只有 Tuple 查询就足够了。
I have a many-to-many relationship in JPA 2.0 provided by Hibernate 4.2.0 CR1 (recently upgraded to Hibernate 4.2.7 final) between Product and Colour as follows.
The Product entity class:
public class Product implements Serializable
{
private static final long serialVersionUID = 1L;
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Basic(optional = false)
@Column(name = "prod_id")
private Long prodId;
@JoinTable(name = "prod_colour", joinColumns = {
@JoinColumn(name = "prod_id", referencedColumnName = "prod_id")}, inverseJoinColumns = {
@JoinColumn(name = "colour_id", referencedColumnName = "colour_id")})
@ManyToMany(fetch = FetchType.EAGER)
private Set<Colour> colourSet;
//Setters and getters.
}
The Colour entity class.
public class Colour implements Serializable
{
private static final long serialVersionUID = 1L;
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Basic(optional = false)
@Column(name = "colour_id")
private Long colourId;
@ManyToMany(mappedBy = "colourSet", fetch = FetchType.EAGER)
private Set<Product> productSet;
//Setters and getters.
}
To fetch a list of colours from the colour table based on prodId supplied which does not match the colours in the prod_colour table (join table), I'm executing the following criteria query.
CriteriaBuilder criteriaBuilder=entityManager.getCriteriaBuilder();
CriteriaQuery<Colour>criteriaQuery=criteriaBuilder.createQuery(Colour.class);
Metamodel metamodel = entityManager.getMetamodel();
EntityType<Colour> entityType = metamodel.entity(Colour.class);
Root<Colour> root = criteriaQuery.from(entityType);
criteriaQuery.select(root);
Subquery<Long>subquery=criteriaQuery.subquery(Long.class);
Root<Product> subRoot = subquery.from(Product.class);
subquery.select(root.get(Colour_.colourId));
Predicate paramPredicate = criteriaBuilder.equal(subRoot.get(Product_.prodId), prodId);
Predicate correlatePredicate = criteriaBuilder.equal(root.get(Colour_.productSet), subRoot);
subquery.where(criteriaBuilder.and(paramPredicate, correlatePredicate));
criteriaQuery.where(criteriaBuilder.in(root.get(Colour_.colourId)).value(subquery).not());
criteriaQuery.orderBy(criteriaBuilder.desc(root.get(Colour_.colourId)));
TypedQuery<Colour> typedQuery = entityManager.createQuery(criteriaQuery);
List<Colour>list=typedQuery.getResultList();
This criteria query causes the following exception to be thrown.
org.hibernate.TypeMismatchException: left and right hand sides of a
binary logic operator were incompatibile
[java.util.Set(model.Colour.productSet) : model.Product]
The following JPQL however works.
FROM Colour colour
WHERE colour.colourId
NOT IN(
SELECT colours.colourId
FROM Product product
INNER JOIN product.colourSet colours
WHERE product.prodId=:id)
ORDER BY colour.colourId DESC
What is the cause of this exception. How to make this criteria query work? This same criteria query somehow works in JPA provided by EclipseLink.
The stacktrace :
SEVERE: Error Rendering View[/admin_side/ProductColour.xhtml]
javax.el.ELException: /admin_side/ProductColour.xhtml @28,121 rendered="#{not empty productColourManagedBean.colourList}": Error reading 'colourList' on type admin.mangedbean.ProductColourManagedBean
at com.sun.faces.facelets.el.TagValueExpression.getValue(TagValueExpression.java:114)
at javax.faces.component.ComponentStateHelper.eval(ComponentStateHelper.java:194)
at javax.faces.component.UIComponentBase.isRendered(UIComponentBase.java:457)
at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:63)
at org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:57)
at org.primefaces.component.panel.PanelRenderer.encodeContent(PanelRenderer.java:204)
at org.primefaces.component.panel.PanelRenderer.encodeMarkup(PanelRenderer.java:121)
at org.primefaces.component.panel.PanelRenderer.encodeEnd(PanelRenderer.java:58)
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:919)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1903)
at javax.faces.render.Renderer.encodeChildren(Renderer.java:176)
at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:889)
at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:70)
at org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:57)
at org.primefaces.component.layout.LayoutUnitRenderer.encodeEnd(LayoutUnitRenderer.java:51)
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:919)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1903)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1899)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1899)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1899)
at com.sun.faces.application.view.FaceletViewHandlingStrategy.renderView(FaceletViewHandlingStrategy.java:451)
at com.sun.faces.application.view.MultiViewHandler.renderView(MultiViewHandler.java:131)
at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:120)
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:219)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:647)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.primefaces.webapp.filter.FileUploadFilter.doFilter(FileUploadFilter.java:70)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at filter.NoCacheFilter.doFilter(NoCacheFilter.java:27)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:150)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:50)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.session.ConcurrentSessionFilter.doFilter(ConcurrentSessionFilter.java:125)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.access.channel.ChannelProcessingFilter.doFilter(ChannelProcessingFilter.java:144)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1822)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)
Caused by: javax.el.ELException: Error reading 'colourList' on type admin.mangedbean.ProductColourManagedBean
at javax.el.BeanELResolver.getValue(BeanELResolver.java:98)
at com.sun.faces.el.DemuxCompositeELResolver._getValue(DemuxCompositeELResolver.java:176)
at com.sun.faces.el.DemuxCompositeELResolver.getValue(DemuxCompositeELResolver.java:203)
at org.apache.el.parser.AstValue.getValue(AstValue.java:183)
at org.apache.el.parser.AstEmpty.getValue(AstEmpty.java:47)
at org.apache.el.parser.AstNot.getValue(AstNot.java:44)
at org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:185)
at com.sun.faces.facelets.el.TagValueExpression.getValue(TagValueExpression.java:109)
... 82 more
Caused by: javax.persistence.PersistenceException: org.hibernate.TypeMismatchException: left and right hand sides of a binary logic operator were incompatibile [java.util.Set(model.Colour.productSet) : model.Product]
at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387)
at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310)
at org.hibernate.ejb.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:470)
at org.hibernate.ejb.criteria.CriteriaQueryCompiler.compile(CriteriaQueryCompiler.java:221)
at org.hibernate.ejb.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:587)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler.invoke(SharedEntityManagerCreator.java:241)
at $Proxy98.createQuery(Unknown Source)
at admin.dao.ProductColourDAO.getList(ProductColourDAO.java:143)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:64)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy120.getList(Unknown Source)
at admin.mangedbean.ProductColourManagedBean.getColourList(ProductColourManagedBean.java:61)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at javax.el.BeanELResolver.getValue(BeanELResolver.java:87)
... 89 more
Caused by: org.hibernate.TypeMismatchException: left and right hand sides of a binary logic operator were incompatibile [java.util.Set(model.Colour.productSet) : model.Product]
at org.hibernate.hql.internal.ast.tree.BinaryLogicOperatorNode.mutateRowValueConstructorSyntaxesIfNecessary(BinaryLogicOperatorNode.java:89)
at org.hibernate.hql.internal.ast.tree.BinaryLogicOperatorNode.initialize(BinaryLogicOperatorNode.java:78)
at org.hibernate.hql.internal.ast.HqlSqlWalker.prepareLogicOperator(HqlSqlWalker.java:1224)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.comparisonExpr(HqlSqlBaseWalker.java:4371)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:2076)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:2004)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.whereClause(HqlSqlBaseWalker.java:794)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:595)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.collectionFunctionOrSubselect(HqlSqlBaseWalker.java:4644)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.comparisonExpr(HqlSqlBaseWalker.java:4347)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:2076)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:2051)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.whereClause(HqlSqlBaseWalker.java:794)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:595)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:299)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:247)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:248)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:183)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:105)
at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:168)
at org.hibernate.internal.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:221)
at org.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:199)
at org.hibernate.internal.SessionImpl.createQuery(SessionImpl.java:1734)
at org.hibernate.ejb.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:452)
... 119 more
Anyway, the criteria query should fetch a list of colours from the colour table based on prodId supplied which does not match the colours in the prod_colour table (It could be a join query, a subquery or anything else).
解决方案 The following criteria query works perfectly as expected.
CriteriaBuilder criteriaBuilder=entityManager.getCriteriaBuilder();
CriteriaQuery<Tuple>criteriaQuery=criteriaBuilder.createTupleQuery();
Metamodel metamodel = entityManager.getMetamodel();
EntityType<Colour> entityType = metamodel.entity(Colour.class);
Root<Colour> root = criteriaQuery.from(entityType);
criteriaQuery.multiselect(root.get(Colour_.colourId), root.get(Colour_.colourName), root.get(Colour_.colourHex));
Subquery<Long>subquery=criteriaQuery.subquery(Long.class);
Root<Colour> subRoot = subquery.from(Colour.class);
subquery.select(subRoot.get(Colour_.colourId));
SetJoin<Colour, Product> join = subRoot.join(Colour_.productSet, JoinType.INNER);
ParameterExpression<Long> parameterExpression=criteriaBuilder.parameter(Long.class);
criteriaQuery.where(criteriaBuilder.in(root.get(Colour_.colourId)).value(subquery).not());
subquery.where(criteriaBuilder.equal(join.get(Product_.prodId), parameterExpression));
TypedQuery<Tuple> typedQuery = entityManager.createQuery(criteriaQuery);
List<Tuple> list = typedQuery.setParameter(parameterExpression, 1L).getResultList();
Resulting in the following SQL query.
select
colour0_.colour_id as col_0_0_,
colour0_.colour_name as col_1_0_,
colour0_.colour_hex as col_2_0_
from
social_networking.colour colour0_
where
colour0_.colour_id not in (
select
colour1_.colour_id
from
social_networking.colour colour1_
inner join
prod_colour productset2_
on colour1_.colour_id=productset2_.colour_id
inner join
social_networking.product product3_
on productset2_.prod_id=product3_.prod_id
where
product3_.prod_id=?
)
Although it is a Tuple query, one may execute the same query on an entity. In my case, only a Tuple query is sufficient.
这篇关于org.hibernate.TypeMismatchException：二进制逻辑运算符的左侧和右侧不兼容的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
