Hibernate 原声SQL查询（）Column 'fd_frlist_bkordernumber' not found.）

背景介绍：公司项目，持久化框架用的是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都不能使用别名.........