hibernate+MYSQL ÕÒ²»µ½ÁÐÎÊÌâ

ÓõÄÊÇ Hibernate µÄ±¾µØ²éѯ createsqlquery

SQL code:

select flight.status status1,oper.status status2
from APY_FLIGHTINFO flight
left join APY_OPERATIONLIST oper on flight.recordid=oper.recordid
where flight.recordid='5' order by flight.recordid




[09/15 14:15:49] [DEBUG] Loader: result row:
[09/15 14:15:49] [INFO] CharacterType: could not read column value from result set: STATUS; Column 'STATUS' not found.
[09/15 14:15:49] [DEBUG] JDBCExceptionReporter: could not read next row of results [select flight.status status1,oper.status status2 from APY_FLIGHTINFO flight left join APY_OPERATIONLIST oper on flight.recordid=oper.recordid where flight.recordid='5' order by flight.recordid]
java.sql.SQLException: Column 'STATUS' not found.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1093)
at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5488)
at org.hibernate.type.CharacterType.get(CharacterType.java:24)
at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:163)
at org.hibernate.type.