我有一张表Incidencia,有一个CHAR(1 Byte)列visiblemovil.此列有两个可能的值:“S”或“N”(是/否,西班牙语为si / no)我希望使用@Convert注释转换为布尔值.这是我的代码:

转换器:

@Converter
public class SiNoToBooleanConverter implements AttributeConverter<Boolean,String> {

    @Override
    public String convertToDatabaseColumn(Boolean aBoolean) {
        return aBoolean ? "S" : "N";
    }

    @Override
    public Boolean convertToEntityAttribute(String s) {
        return "S".equals(s);
    }
}

实体:

@FilterDef(name = "PREGINCIDENCIA_FILTRO_FECHA",parameters = @ParamDef(name = "ultimaFechaSinc",type = "date"))
@Entity
public class Incidencia {

    private List<Incidenciapreguntas> preguntasList;

    private Integer codincidencia;

    private String descripcion;

    private Double horasfinalizacion;

    @Convert(converter = SiNoToBooleanConverter.class)
    private Boolean visiblemovil;

    private boolean tieneDocumentacion;

    @Id
    @Column(name = "CODINCIDENCIA")
    public Integer getCodincidencia() {
        return codincidencia;
    }

    public void setCodincidencia(Integer codincidencia) {
        this.codincidencia = codincidencia;
    }

    @Basic
    @Column(name = "DESCRIPCION")
    public String getDescripcion() {
        return descripcion;
    }

    public void setDescripcion(String descripcion) {
        this.descripcion = descripcion;
    }

    @OnetoMany(mappedBy = "incidencia")
    @Filter(name = "PREGINCIDENCIA_FILTRO_FECHA",condition = "FMODIFICACION > :ultimaFechaSinc OR FMODIFICACION IS NULL")
    public List<Incidenciapreguntas> getPreguntasList() {
        return preguntasList;
    }

    public void setPreguntasList(List<Incidenciapreguntas> preguntasList) {
        this.preguntasList = preguntasList;
    }

    @Transient
    public boolean isTieneDocumentacion() {
        return tieneDocumentacion;
    }

    public void setTieneDocumentacion(boolean tieneDocumentacion) {
        this.tieneDocumentacion = tieneDocumentacion;
    }

    @Override
    public boolean equals(Object o) {
        if (this == o) return true;
        if (o == null || getClass() != o.getClass()) return false;

        Incidencia that = (Incidencia) o;

        if (codincidencia != null ? !codincidencia.equals(that.codincidencia) : that.codincidencia != null)
            return false;
        if (descripcion != null ? !descripcion.equals(that.descripcion) : that.descripcion != null) return false;
        return true;
    }

    @Override
    public int hashCode() {
        int result = codincidencia != null ? codincidencia.hashCode() : 0;
        result = 31 * result + (descripcion != null ? descripcion.hashCode() : 0);
        return result;
    }

    @Basic
    @Column(name = "HORASFINALIZACION")
    public Double getHorasfinalizacion() {
        return horasfinalizacion;
    }

    public void setHorasfinalizacion(Double horasfinalizacion) {
        this.horasfinalizacion = horasfinalizacion;
    }

//    @Basic
    @Column(name = "VISIBLEMOVIL")
    public Boolean getVisiblemovil() {
        return visiblemovil;
    }

    public void setVisiblemovil(Boolean visiblemovil) {
        this.visiblemovil = visiblemovil;
    }
}

当我执行SELECT语句(使用QueryDSL)时,我收到此错误:

org.hibernate.exception.GenericJDBCException: Fail to convert to internal representation
javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Fail to convert to internal representation

库:

@Repository
public class IncidenciasDAO extends BaseDAO {

      public List<Incidencia> getIncidencias() {
        QIncidencia qIncidencia = QIncidencia.incidencia;
        JPAQuery query = new JPAQuery(entityManager);
        List<Incidencia> incidencias = query.from(qIncidencia).list(qIncidencia);
        return incidencias;
    }
}

完整的堆栈跟踪

org.hibernate.exception.GenericJDBCException: Fallo al convertir a representación interna
javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Fallo al convertir a representación interna
    at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1377)
    at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1300)
    at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:266)
    at com.mysema.query.jpa.impl.AbstractJPAQuery.getResultList(AbstractJPAQuery.java:222)
    at com.mysema.query.jpa.impl.AbstractJPAQuery.list(AbstractJPAQuery.java:274)
    at com.grupogimeno.senda.movbrigadas.daos.IncidenciasDAO.getIncidencias_aroundBody0(IncidenciasDAO.java:26)
    at com.grupogimeno.senda.movbrigadas.daos.IncidenciasDAO$Ajcclosure1.run(IncidenciasDAO.java:1)
    at org.springframework.cache.aspectj.AbstractCacheAspect.ajc$around$org_springframework_cache_aspectj_AbstractCacheAspect$1$2bc714b5proceed(AbstractCacheAspect.aj:1)
    at org.springframework.cache.aspectj.AbstractCacheAspect$1.invoke(AbstractCacheAspect.aj:61)
    at org.springframework.cache.interceptor.CacheAspectSupport.execute(CacheAspectSupport.java:180)
    at org.springframework.cache.aspectj.AbstractCacheAspect.ajc$around$org_springframework_cache_aspectj_AbstractCacheAspect$1$2bc714b5(AbstractCacheAspect.aj:65)
    at com.grupogimeno.senda.movbrigadas.daos.IncidenciasDAO.getIncidencias(IncidenciasDAO.java:22)
    at com.grupogimeno.senda.movbrigadas.daos.IncidenciasDAO$$FastClassBycglib$$bd07b3a2.invoke(<generated>)
    at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)
    at org.springframework.aop.framework.cglib2AopProxy$cglibMethodInvocation.invokeJoinpoint(cglib2AopProxy.java:689)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
    at org.springframework.cache.interceptor.CacheInterceptor$1.invoke(CacheInterceptor.java:58)
    at org.springframework.cache.interceptor.CacheAspectSupport.execute(CacheAspectSupport.java:213)
    at org.springframework.cache.interceptor.CacheInterceptor.invoke(CacheInterceptor.java:66)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    at org.springframework.aop.framework.cglib2AopProxy$DynamicAdvisedInterceptor.intercept(cglib2AopProxy.java:622)
    at com.grupogimeno.senda.movbrigadas.daos.IncidenciasDAO$$EnhancerBycglib$$4b7b3a28.getIncidencias(<generated>)
    at com.grupogimeno.senda.movbrigadas.services.IncidenciasService.getIncidencias(IncidenciasService.java:22)
    at com.grupogimeno.senda.movbrigadas.services.rest.IncidenciasResource.getIcidencias(IncidenciasResource.java:30)
    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 com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)2015-03-10 10:53:05,785 WARN  org.hibernate.engine.jdbc.spi.sqlExceptionHelper - sql Error: 17059,sqlState: 99999
2015-03-10 10:53:05,792 ERROR org.hibernate.engine.jdbc.spi.sqlExceptionHelper - Fallo al convertir a representación interna

org.hibernate.exception.GenericJDBCException: Fallo al convertir a representación interna
    at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethoddispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethoddispatchProvider.java:185)
    at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethoddispatcher.dispatch(ResourceJavaMethoddispatcher.java:75)
    at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)
    at com.sun.jersey.server.impl.uri.rules.RightHandpathRule.accept(RightHandpathRule.java:147)
    at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
    at com.sun.jersey.server.impl.uri.rules.RightHandpathRule.accept(RightHandpathRule.java:147)
    at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
    at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1480)
    at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1411)
    at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1360)
    at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1350)
    at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416)
    at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:538)
    at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:716)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
    at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)
    at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1166)
    at com.grupogimeno.senda.commons.filters.BaseBasicAuthLoginFilter.doFilter(BaseBasicAuthLoginFilter.java:64)
    at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
    at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388)
    at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
    at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
    at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
    at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:418)
    at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:230)
    at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
    at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
    at org.mortbay.jetty.Server.handle(Server.java:326)
    at org.mortbay.jetty.httpconnection.handleRequest(httpconnection.java:542)
    at org.mortbay.jetty.httpconnection$RequestHandler.headerComplete(httpconnection.java:923)
    at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:547)
    at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)
    at org.mortbay.jetty.httpconnection.handle(httpconnection.java:404)
    at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409)
    at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)
Caused by: org.hibernate.exception.GenericJDBCException: Fallo al convertir a representación interna
    at org.hibernate.exception.internal.StandardsqlExceptionConverter.convert(StandardsqlExceptionConverter.java:54)
    at org.hibernate.engine.jdbc.spi.sqlExceptionHelper.convert(sqlExceptionHelper.java:125)
    at org.hibernate.engine.jdbc.spi.sqlExceptionHelper.convert(sqlExceptionHelper.java:110)
    at org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler.continueInvocation(AbstractResultSetProxyHandler.java:108)
    at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
    at $Proxy115.getBoolean(UnkNown Source)
    at org.hibernate.type.descriptor.sql.BitTypeDescriptor$2.doExtract(BitTypeDescriptor.java:69)
    at org.hibernate.type.descriptor.sql.BasicExtractor.extract(BasicExtractor.java:65)
    at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:269)
    at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:265)
    at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:238)
    at org.hibernate.type.AbstractStandardBasicType.hydrate(AbstractStandardBasicType.java:357)
    at org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2705)
    at org.hibernate.loader.Loader.loadFromresultSet(Loader.java:1544)
    at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1476)
    at org.hibernate.loader.Loader.getRow(Loader.java:1376)
    at org.hibernate.loader.Loader.getRowFromresultSet(Loader.java:643)
    at org.hibernate.loader.Loader.doQuery(Loader.java:853)
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:292)
    at org.hibernate.loader.Loader.doList(Loader.java:2381)
    at org.hibernate.loader.Loader.doList(Loader.java:2367)
    at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2197)
    at org.hibernate.loader.Loader.list(Loader.java:2192)
    at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:470)
    at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:355)
    at org.hibernate.engine.query.spi.HQLQueryPlan.performlist(HQLQueryPlan.java:195)
    at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1248)
    at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101)
    at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:257)
    ... 61 more
Caused by: java.sql.sqlException: Fallo al convertir a representación interna
    at oracle.jdbc.driver.CharCommonAccessor.getBoolean(CharCommonAccessor.java:185)
    at oracle.jdbc.driver.T4CCharaccessor.getBoolean(T4CCharaccessor.java:697)
    at oracle.jdbc.driver.OracleResultSetImpl.getBoolean(OracleResultSetImpl.java:640)
    at oracle.jdbc.driver.OracleResultSet.getBoolean(OracleResultSet.java:386)
    at com.mchange.v2.c3p0.impl.NewProxyResultSet.getBoolean(NewProxyResultSet.java:2391)
    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.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler.continueInvocation(AbstractResultSetProxyHandler.java:104)
    ... 86 more
javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Fallo al convertir a representación interna
    at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1377)
    at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1300)
    at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:266)
    at com.mysema.query.jpa.impl.AbstractJPAQuery.getResultList(AbstractJPAQuery.java:222)
    at com.mysema.query.jpa.impl.AbstractJPAQuery.list(AbstractJPAQuery.java:274)
    at com.grupogimeno.senda.movbrigadas.daos.IncidenciasDAO.getIncidencias_aroundBody0(IncidenciasDAO.java:26)
    at com.grupogimeno.senda.movbrigadas.daos.IncidenciasDAO$Ajcclosure1.run(IncidenciasDAO.java:1)
    at org.springframework.cache.aspectj.AbstractCacheAspect.ajc$around$org_springframework_cache_aspectj_AbstractCacheAspect$1$2bc714b5proceed(AbstractCacheAspect.aj:1)
    at org.springframework.cache.aspectj.AbstractCacheAspect$1.invoke(AbstractCacheAspect.aj:61)
    at org.springframework.cache.interceptor.CacheAspectSupport.execute(CacheAspectSupport.java:180)
    at org.springframework.cache.aspectj.AbstractCacheAspect.ajc$around$org_springframework_cache_aspectj_AbstractCacheAspect$1$2bc714b5(AbstractCacheAspect.aj:65)
    at com.grupogimeno.senda.movbrigadas.daos.IncidenciasDAO.getIncidencias(IncidenciasDAO.java:22)
    at com.grupogimeno.senda.movbrigadas.daos.IncidenciasDAO$$FastClassBycglib$$bd07b3a2.invoke(<generated>)
    at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)
    at org.springframework.aop.framework.cglib2AopProxy$cglibMethodInvocation.invokeJoinpoint(cglib2AopProxy.java:689)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
    at org.springframework.cache.interceptor.CacheInterceptor$1.invoke(CacheInterceptor.java:58)
    at org.springframework.cache.interceptor.CacheAspectSupport.execute(CacheAspectSupport.java:213)
    at org.springframework.cache.interceptor.CacheInterceptor.invoke(CacheInterceptor.java:66)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    at org.springframework.aop.framework.cglib2AopProxy$DynamicAdvisedInterceptor.intercept(cglib2AopProxy.java:622)
    at com.grupogimeno.senda.movbrigadas.daos.IncidenciasDAO$$EnhancerBycglib$$4b7b3a28.getIncidencias(<generated>)
    at com.grupogimeno.senda.movbrigadas.services.IncidenciasService.getIncidencias(IncidenciasService.java:22)
    at com.grupogimeno.senda.movbrigadas.services.rest.IncidenciasResource.getIcidencias(IncidenciasResource.java:30)
    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 com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
    at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethoddispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethoddispatchProvider.java:185)
    at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethoddispatcher.dispatch(ResourceJavaMethoddispatcher.java:75)
    at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)
    at com.sun.jersey.server.impl.uri.rules.RightHandpathRule.accept(RightHandpathRule.java:147)
    at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
    at com.sun.jersey.server.impl.uri.rules.RightHandpathRule.accept(RightHandpathRule.java:147)
    at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
    at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1480)
    at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1411)
    at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1360)
    at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1350)
    at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416)
    at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:538)
    at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:716)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
    at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)
    at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1166)
    at com.grupogimeno.senda.commons.filters.BaseBasicAuthLoginFilter.doFilter(BaseBasicAuthLoginFilter.java:64)
    at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
    at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388)
    at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
    at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
    at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
    at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:418)
    at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:230)
    at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
    at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
    at org.mortbay.jetty.Server.handle(Server.java:326)
    at org.mortbay.jetty.httpconnection.handleRequest(httpconnection.java:542)
    at org.mortbay.jetty.httpconnection$RequestHandler.headerComplete(httpconnection.java:923)
    at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:547)
    at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)
    at org.mortbay.jetty.httpconnection.handle(httpconnection.java:404)
    at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409)
    at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)
Caused by: org.hibernate.exception.GenericJDBCException: Fallo al convertir a representación interna
    at org.hibernate.exception.internal.StandardsqlExceptionConverter.convert(StandardsqlExceptionConverter.java:54)
    at org.hibernate.engine.jdbc.spi.sqlExceptionHelper.convert(sqlExceptionHelper.java:125)
    at org.hibernate.engine.jdbc.spi.sqlExceptionHelper.convert(sqlExceptionHelper.java:110)
    at org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler.continueInvocation(AbstractResultSetProxyHandler.java:108)
    at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
    at $Proxy115.getBoolean(UnkNown Source)
    at org.hibernate.type.descriptor.sql.BitTypeDescriptor$2.doExtract(BitTypeDescriptor.java:69)
    at org.hibernate.type.descriptor.sql.BasicExtractor.extract(BasicExtractor.java:65)
    at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:269)
    at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:265)
    at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:238)
    at org.hibernate.type.AbstractStandardBasicType.hydrate(AbstractStandardBasicType.java:357)
    at org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2705)
    at org.hibernate.loader.Loader.loadFromresultSet(Loader.java:1544)
    at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1476)
    at org.hibernate.loader.Loader.getRow(Loader.java:1376)
    at org.hibernate.loader.Loader.getRowFromresultSet(Loader.java:643)
    at org.hibernate.loader.Loader.doQuery(Loader.java:853)
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:292)
    at org.hibernate.loader.Loader.doList(Loader.java:2381)
    at org.hibernate.loader.Loader.doList(Loader.java:2367)
    at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2197)
    at org.hibernate.loader.Loader.list(Loader.java:2192)
    at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:470)
    at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:355)
    at org.hibernate.engine.query.spi.HQLQueryPlan.performlist(HQLQueryPlan.java:195)
    at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1248)
    at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101)
    at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:257)
    ... 61 more
Caused by: java.sql.sqlException: Fallo al convertir a representación interna
    at oracle.jdbc.driver.CharCommonAccessor.getBoolean(CharCommonAccessor.java:185)
    at oracle.jdbc.driver.T4CCharaccessor.getBoolean(T4CCharaccessor.java:697)
    at oracle.jdbc.driver.OracleResultSetImpl.getBoolean(OracleResultSetImpl.java:640)
    at oracle.jdbc.driver.OracleResultSet.getBoolean(OracleResultSet.java:386)
    at com.mchange.v2.c3p0.impl.NewProxyResultSet.getBoolean(NewProxyResultSet.java:2391)
    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.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler.continueInvocation(AbstractResultSetProxyHandler.java:104)
    ... 86 more

我究竟做错了什么?

谢谢.

解决方法

您将映射注释放在实体类中映射字段的getter上.
根据 specification的第2.3.1章,这导致了基于财产的访问.

规范声明只应为映射注释getter.但也许这对@Convert注释来说还不够?

您可以尝试注释该字段:

@Entity
public class Incidencia {

    @Column(name = "VISIBLE")
    @Convert(converter = SiNoToBooleanConverter.class)
    private Boolean visible;

    //other fields

    public Boolean getVisible() {
        return visible;
    }

    public void setVisible(Boolean visible) {
        this.visible = visible;
    }

}

(我更正了getter / setter方法中变量/字段的名称.)

java – @Convert不适用于Hibernate和QueryDSL的更多相关文章

  1. cannot convert value of type 'String!' to expected argument type 'inout String'

    }}}}如果是按照上面那样写,会报如题错误。改为如下就可以了vararea_big:String!

  2. Convert Seconds To Hours

    Convertstimeinsecondstohours,minutes,andseconds

  3. 如何从windows 10 pro安装文件获取install.wim

    我目前正在学习Windows10部署.我安装了MicrosoftDeploymentToolkitupdate2013update1.当我尝试导入操作系统时,系统告诉我在windows源代码中找不到install.wim.我做了一些调查发现当前的windows10home/pro安装介质附带install.esd而不是install.wim.有没有人知道从install.esd中提取install

  4. 在php中将UTF-16LE转换为UTF-8

    我使用iconvPHP函数,但有些字符无法正确转换:我也尝试mb_convert_encoding函数,但无法解决我的问题.示例文本文件:9px.ir/utf8-16LE.rariconvsupportstheUTF-16LEencoding.您可以使用它将UTF-16LE的编码转换为UTF-8:见iconvDocs.我只是想知道UTF-16LE中可用的所有代码点是否在UTF-8中可用.但我认为这

  5. php – Imagemagick动画gif大小优化

    我使用此代码来调整大小并保存动画gif:完成后,文件大小非常大.通常比原来大!我用convert$completeMiff-dithernone-matte-depth8-deconstruct-layersoptimizePlus-colors32$optimizedFile_16,文件变得更大???

  6. php – Observer不保存订单

    我构建了一个监听sales_convert_quote_to_order事件的观察者.事件被触发,我只想为订单的属性添加值.该属性已设置–打印在日志中–但magento不保存订单.我做错了什么?Observer.PHPconfig.xml中我通过安装脚本添加了属性customer_languagecustomer_language列存在于sales_flat_order表中.但它没有得到保存.我正

  7. php – mb_convert_case undefined function(Symfony2 FOS / UserBundle)

    我找到了这个:在Windows下,您必须在PHP.ini中使用PHP_mbstring.dll取消注释该行我不知道你是不是在跑窗框.

  8. php – laravel中的查询生成器中的mysql函数

    我想在MySQL中使用像convert这样的函数.如何在Laravel的查询构建器中使用它?我试过–>orderBy,但它不起作用.你需要使用eloquent的Raw函数.在您的情况下,以下查询应该工作:如果要在where语句中使用原始sql,可以使用快捷函数whereRaw()并选择selectRaw()函数.

  9. php – Imagemagick裁剪命令没有给出完美的结果

    我正在使用imagemagick来调整图像大小和裁剪图像.测试图像:我需要重新调整大小为300x320帧为此我首先调整图像大小然后裁剪它我使用以下命令:但它给了我以下图像你可以看到图像不完整…请帮我错误尝试:希望有所帮助

  10. centos g c exception:this most likely means the gm/convert binaries can't be found

    背景:1使用了nodejs版本的gm:https://github.com/aheckmann/gm2系统:centos73报错:CouldnotexecuteGraphicsMagick/ImageMagick:gm"identify""-ping""-format""%wx%h""/mnt/data/static/tmp/upload_54ac1f78f289e1361ebf1263c4fcf

随机推荐

  1. 基于EJB技术的商务预订系统的开发

    用EJB结构开发的应用程序是可伸缩的、事务型的、多用户安全的。总的来说,EJB是一个组件事务监控的标准服务器端的组件模型。基于EJB技术的系统结构模型EJB结构是一个服务端组件结构,是一个层次性结构,其结构模型如图1所示。图2:商务预订系统的构架EntityBean是为了现实世界的对象建造的模型,这些对象通常是数据库的一些持久记录。

  2. Java利用POI实现导入导出Excel表格

    这篇文章主要为大家详细介绍了Java利用POI实现导入导出Excel表格,文中示例代码介绍的非常详细,具有一定的参考价值,感兴趣的小伙伴们可以参考一下

  3. Mybatis分页插件PageHelper手写实现示例

    这篇文章主要为大家介绍了Mybatis分页插件PageHelper手写实现示例,有需要的朋友可以借鉴参考下,希望能够有所帮助,祝大家多多进步,早日升职加薪

  4. (jsp/html)网页上嵌入播放器(常用播放器代码整理)

    网页上嵌入播放器,只要在HTML上添加以上代码就OK了,下面整理了一些常用的播放器代码,总有一款适合你,感兴趣的朋友可以参考下哈,希望对你有所帮助

  5. Java 阻塞队列BlockingQueue详解

    本文详细介绍了BlockingQueue家庭中的所有成员,包括他们各自的功能以及常见使用场景,通过实例代码介绍了Java 阻塞队列BlockingQueue的相关知识,需要的朋友可以参考下

  6. Java异常Exception详细讲解

    异常就是不正常,比如当我们身体出现了异常我们会根据身体情况选择喝开水、吃药、看病、等 异常处理方法。 java异常处理机制是我们java语言使用异常处理机制为程序提供了错误处理的能力,程序出现的错误,程序可以安全的退出,以保证程序正常的运行等

  7. Java Bean 作用域及它的几种类型介绍

    这篇文章主要介绍了Java Bean作用域及它的几种类型介绍,Spring框架作为一个管理Bean的IoC容器,那么Bean自然是Spring中的重要资源了,那Bean的作用域又是什么,接下来我们一起进入文章详细学习吧

  8. 面试突击之跨域问题的解决方案详解

    跨域问题本质是浏览器的一种保护机制,它的初衷是为了保证用户的安全,防止恶意网站窃取数据。那怎么解决这个问题呢?接下来我们一起来看

  9. Mybatis-Plus接口BaseMapper与Services使用详解

    这篇文章主要为大家介绍了Mybatis-Plus接口BaseMapper与Services使用详解,有需要的朋友可以借鉴参考下,希望能够有所帮助,祝大家多多进步,早日升职加薪

  10. mybatis-plus雪花算法增强idworker的实现

    今天聊聊在mybatis-plus中引入分布式ID生成框架idworker,进一步增强实现生成分布式唯一ID,具有一定的参考价值,感兴趣的小伙伴们可以参考一下

返回
顶部