Hibernate配置問題： could not execute query

最新推荐文章于 2021-12-19 11:38:29 发布

rockhb

最新推荐文章于 2021-12-19 11:38:29 发布

阅读量1.8k

点赞数

文章标签： hibernate query log4j exception thread system

本文链接：https://blog.csdn.net/rockhb/article/details/4590054

版权

log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
Hibernate: select notice0_.noticeId as noticeId2_, notice0_.noticeTitle as noticeTi2_2_, notice0_.noticeContent as noticeCo3_2_, notice0_.noticeDate as noticeDate2_, notice0_.endDate as endDate2_, notice0_.aempId as aempId2_, notice0_.deptId as deptId2_, notice0_.remark as remark2_ from rock.notice notice0_

Exception in thread "main" org.hibernate.exception.DataException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:77)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2148)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
at org.hibernate.loader.Loader.list(Loader.java:2024)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:308)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:153)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1106)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at test.Test.get(Test.java:17)
at test.Test.main(Test.java:23)

Caused by: java.sql.SQLException: The value supplied cannot be converted to INTEGER.
at net.sourceforge.jtds.jdbc.Support.convert(Support.java:570)
at net.sourceforge.jtds.jdbc.JtdsResultSet.getInt(JtdsResultSet.java:657)
at net.sourceforge.jtds.jdbc.JtdsResultSet.getInt(JtdsResultSet.java:980)
at org.hibernate.type.IntegerType.get(IntegerType.java:28)
at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:113)
at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:102)
at org.hibernate.type.ManyToOneType.hydrate(ManyToOneType.java:95)
at org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:1899)
at org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1372)
at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1300)
at org.hibernate.loader.Loader.getRow(Loader.java:1197)
at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:569)
at org.hibernate.loader.Loader.doQuery(Loader.java:689)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2145)
... 9 more