jpa 列名无效

[matrix1984]

Caused by: org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access: SQLException for SQL [select m.I_ID as I_ID, m.I_NAME as I_NAME, m.I_PRIOR as I_PRIOR from EISS_TAB_MAIN m]; SQL state [null]; error code [17006]; could not execute query; nested exception is org.hibernate.exception.GenericJDBCException: could not execute query

	at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:642)

	at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:95)

	at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:212)

	at org.springframework.orm.jpa.JpaAccessor.translateIfNecessary(JpaAccessor.java:152)

	at org.springframework.orm.jpa.JpaTemplate.execute(JpaTemplate.java:189)

	at org.springframework.orm.jpa.JpaTemplate.execute(JpaTemplate.java:147)

	at com.rizon.eiss.infolink.service.DbInfoService.findInfosWithoutLink(DbInfoService.java:172)

	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

	at java.lang.reflect.Method.invoke(Method.java:585)

	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)

	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198)

	at $Proxy70.findInfosWithoutLink(Unknown Source)

	at com.rizon.eiss.infolink.servlet.InfoList.handleRequest(InfoList.java:56)

	at com.rizon.eiss.servlet.AbstractKernelServlet.process(AbstractKernelServlet.java:246)

	at com.rizon.apollo.components.pupa.PupaManagerBean$2.invoke(PupaManagerBean.java:173)

	at com.rizon.apollo.reading.PupaNoopReader.setup(PupaNoopReader.java:68)

	... 97 more

打印出来的那句sql我在pssql里头执行没任何问题。

Hibernate: select * from ( select m.I_ID as I_ID, m.I_NAME as I_NAME, m.I_PRIOR as I_PRIOR from EISS_TAB_MAIN m ) where rownum <= ?

[guoquanhua007]

没遇到过这种怪事.

[guoquanhua007]

有的时候,你使用一些所谓的数据库框架会出一些这种问题,如果使用一般的连接池的话.就不会了.

[Z_FEI]

sql语句没发现什么问题，数据库连接、映射文件、配置你都检查一下看有没有问题？

[matrix1984]

有人回答就好啦，原因是@SqlResultSetMapping时，是不能定义部分的字段，必须全部定义。

[matrix1984]

晕，没人回答啊

[matrix1984]

来个人冒泡给分啊，100分浪费了。

[蛋黄车]

我不懂

[knightxc]

那如何解决呢，碰到与楼主相同的问题