public List selectTradeStatus(Byte status,Byte tradetype)
{
try{
String sql = "SELECT trade_number,packager,price FROM trade_info WHERE status="+status+ "  AND trade_type="+tradetype ;
Session session = getHibernateTemplate().getSessionFactory().openSession();
List result = session.createSQLQuery(sql).addEntity(TradeInfo.class).list();
        session.close();         
return result;
} catch (RuntimeException re) {
log.error("find by property name failed", re);
throw re;
}这样查询为什么总是不对呀?Hibernate: 
    SELECT
        trade_number,
        packager,
        price 
    FROM
        trade_info 
    WHERE
        status=8  
        AND trade_type=2
[INFO] could not read column value from result set: ID; 列名无效
[WARN] SQL Error: 17006, SQLState: 99999
[ERROR] 列名无效
[ERROR] find by property name failed
org.hibernate.exception.GenericJDBCException: could not execute query
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.doList(Loader.java:2235)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129)
at org.hibernate.loader.Loader.list(Loader.java:2124)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:312)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1723)
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:175)
at com.bxx.dao.TradeInfoDAO.selectTradeStatus(TradeInfoDAO.java:229)
at com.bxx.service.TradeInfoService.selectTradeStatust(TradeInfoService.java:106)
at com.bxx.GUIActions.AdminInfoAction.selectStatusAndDatetype(AdminInfoAction.java:592)
at com.bxx.GUIActions.AdminInfoAction.Admin(AdminInfoAction.java:1608)
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:597)哪位高手解决一下,谢谢。