背景介绍:公司项目,持久化框架用的是Hibernate3
今天使用原生SQL语句查询是出现下面的错误,没有在百度等网站找到解决办法,所以决定记录一下:
Hibernate:
SELECT
fd_frlist_bkordernumber AS 'orderno',
fd_frlist_paymoney AS 'paymoney',
fd_frlist_fcusid AS 'oneid',
fd_frlist_fcusfee AS 'onefenrun',
fd_frlist_tcusid AS 'twoid',
fd_frlist_tcusfee AS 'twofenrun',
fd_frlist_threecusid AS 'threeid',
fd_frlist_threecusfee AS 'threefenrun',
fd_frlist_tfbfenrun AS 'tfbfenrun',
fd_frlist_datetime AS 'datetime'
from
tb_cus_fenrunglist
where
1 = 1 limit ?
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.doList(Loader.java:2536)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
at org.hibernate.loader.Loader.list(Loader.java:2271)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1842)
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:157)
at com.tfbpay.scantrade.dao.BaseDaoImpl.exeSQLList(BaseDaoImpl.java:67)
at com.tfbpay.scantrade.dao.fenrun.impl.TbCusFenrunglistDaoImpl.findFenRunListPage(TbCusFenrunglistDaoImpl.java:106)
... 95 more
Caused by: java.sql.SQLException: Column 'fd_frlist_bkordernumber' not found.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1072)at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:986)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:981)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1144)
at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5616)
at org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:225)
at org.hibernate.type.descriptor.sql.VarcharTypeDescriptor$2.doExtract(VarcharTypeDescriptor.java:61)
at org.hibernate.type.descriptor.sql.BasicExtractor.extract(BasicExtractor.java:64)
at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:253)
at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:249)
at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:234)
at org.hibernate.loader.custom.CustomLoader$ScalarResultColumnProcessor.extract(CustomLoader.java:505)
at org.hibernate.loader.custom.CustomLoader$ResultRowProcessor.buildResultRow(CustomLoader.java:451)
at org.hibernate.loader.custom.CustomLoader.getResultColumnOrRow(CustomLoader.java:348)
at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:639)
at org.hibernate.loader.Loader.doQuery(Loader.java:829)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
at org.hibernate.loader.Loader.doList(Loader.java:2533)
... 103 more
首先感到很神奇,这条SQL语句我在数据库里面执行是没有任何问题的,唯独在项目里面一直报错,说找不到列;
确定了数据库里面可以之后我有用jdbc直接连接测试也是可以的;
仔细对比了以前写的代码发现我这次和以前唯一的区别就是我用as给查询的每个字段取了别名,于是我把别名全部去掉,然后测试就OK啦;
多次测试发现Hibernate3都不能使用别名.........