Hibernate配置問題: could not execute query

来源:互联网 发布:电脑 防护 软件 编辑:程序博客网 时间:2024/04/30 21:25

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

原创粉丝点击