真的很奇怪,如果用hibernate3.2.5ga版本
<set name="images"
table="IMAGES"
lazy="true"
order-by="lower(FILENAME) desc">
<key column="CUSTOMER_ID" />
<element column="FILENAME" type="string" not-null="true" />
</set> 生成的sql查询语句就变成了
SELECT images20_.customer_id AS customer1___,
images20_.filename AS filename__
FROM images images20_
WHERE images20_.customer_id = 1
ORDER BY Lower(images20_.filename) DESC 就可以正常的执行了,也是期待的结果
不知道为什么hibernate2.1.7c版本为什么不行!有知道的朋友,帮个忙,小弟实在是很迷惑,先谢谢了
<set name="images"
table="IMAGES"
lazy="true"
order-by="lower(FILENAME) desc">
<key column="CUSTOMER_ID" />
<element column="FILENAME" type="string" not-null="true" />
</set> 生成的sql查询语句就变成了
SELECT images20_.customer_id AS customer1___,
images20_.filename AS filename__
FROM images images20_
WHERE images20_.customer_id = 1
ORDER BY Lower(images20_.filename) DESC 就可以正常的执行了,也是期待的结果
不知道为什么hibernate2.1.7c版本为什么不行!有知道的朋友,帮个忙,小弟实在是很迷惑,先谢谢了
<set name="images"
table="IMAGES"
lazy="true"
order-by="lower(FILENAME) desc">
<key column="CUSTOMER_ID" />
<element column="FILENAME" type="string" not-null="true" />
</set> 生成的sql查询语句就变成了
SELECT images20_.customer_id AS customer1___,
images20_.filename AS filename__
FROM images images20_
WHERE images20_.customer_id = 1
ORDER BY Lower(images20_.filename) DESC 就可以正常的执行了,也是期待的结果
不知道为什么hibernate2.1.7c版本为什么不行!有知道的朋友,帮个忙,小弟实在是很迷惑,先谢谢了