Oracle使用Hibernate的功能 [英] Oracle functions using Hibernate
本文介绍了Oracle使用Hibernate的功能的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如何在不发送SQL查询的情况下从Hibernate 3.6调用Oracle函数?或者,我可以将SQL查询(仅用于函数)与Criteria混合吗?
谢谢。
@Entity
public class A {
@Column(name =a1)
private int a1;
@Column(name =a2)
private int a2;
@Formula(myFunction(a1))
private int a3;
.....
}
并且在标准中:
Criteria cr = getInstanciaCriteria(A.class);
cr.add(Restrictions.eq(a3,1));
How can I call an Oracle function from Hibernate 3.6, without sending a SQL query? Or maybe, can I mix the SQL query (just for the function) with Criteria?
Thank you.
解决方案
After some research, this can be done using Formula annotation:
@Entity
public class A {
@Column(name ="a1")
private int a1;
@Column(name ="a2")
private int a2;
@Formula("myFunction(a1)")
private int a3;
.....
}
And in the Criteria:
Criteria cr = getInstanciaCriteria(A.class);
cr.add(Restrictions.eq("a3", 1));
这篇关于Oracle使用Hibernate的功能的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文