Hibernate Transformers.aliasToBean找不到属性方法

 

还原现场：在mysql环境下，以下代码，在mysql下运行正常，但是切换到oralce，报出找不到STUDENTNAME属性的错误。

 

1	List resultWithAliasedBean = s.createSQLQuery(

2	"SELECT st.name as studentName, co.description as courseDescription " +

3	"FROM Enrolment e " +

4	"INNER JOIN Student st on e.studentId=st.studentId " +

5	"INNER JOIN Course co on e.courseCode=co.courseCode")

6	.setResultTransformer( Transformers.aliasToBean(StudentDTO.class))

7

.list();

 

分析：原来是oracle自动将列映射的studentName转换为大写的STUDENTNAME，所以不能映射，报类找不到STUDENTNAME的set方法。
解决办法：添加addScalar方法，代码如下：

 

01	List resultWithAliasedBean = s.createSQLQuery(

02	"SELECT st.name as studentName, co.description as courseDescription " +

03	"FROM Enrolment e " +

04	"INNER JOIN Student st on e.studentId=st.studentId " +

05	"INNER JOIN Course co on e.courseCode=co.courseCode")

06	.addScalar("studentName")

07	.addScalar("courseDescription")

08	.setResultTransformer( Transformers.aliasToBean(StudentDTO.class))

09

.list();

 

10

Tip: the addScalar() calls were required on HSQLDB to make it match a property name since it returns column names in all uppercase (e.g. "STUDENTNAME"). This could also be solved with a custom transformer that search the property names instead of using exact match - maybe we should provide a fuzzyAliasToBean() method ;

 

还有一种方式解决，就是使用双引号将别名包裹起来，感觉不是很优雅。像这样

 

1	String sql = "select id as \"id\",iata as \"iata\",flight as \"flight\",dest as \"dest\",domint as \"domint\" " +

2	" ,sdt as \"sdt\",task_nature as \"taskNature\",est_date as \"estDate\",act_date as \"actDate\",remark as \"remark\" " +

3	" from FIDS_DEPF";