hibernate如何调用oracle中自己定义的函数

[YYcool]

将调用sql写在配置文件中，函数是无参的

[V-revenger]

我们可以在hbm.xml中调用,例如:

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!--
Mapping file autogenerated by MyEclipse Persistence Tools
-->
<hibernate-mapping>
<class name="com.test" table="TEST">
<id name="id" type="java.lang.String">
<column name="ID" length="12" />
<generator class="assigned" />
</id>

<!--以下是通过SQL来实现的-->
<property name="rs" type="java.lang.Long"
formula="(select count(*) from Xs0101 xs where xs.bjbh = bjbh)" />

</class>

<!--以下是通过自定义函数来实现的-->
<property name="data" type="java.lang.String"
formula="(pckfunction.findSubString(class,'args1','args2','args3'))" />

</class>
</hibernate-mapping>

在oracle的packages中可以自定义自己提供的函数:

create or replace package pckFunction is
TYPE myrctype IS REF CURSOR;
function getSubTable(tblname in varchar2,
returnColname in varchar2,
findColname in varchar2,
findValue in varchar2) return myrctype;

function findSubString(tblname in varchar2,
returnColname in varchar2,
findColname in varchar2,
findValue in varchar2) return varchar2;

end pckFunction;


本文来自CSDN博客，转载请标明出处：http://blog.csdn.net/lyddite_luo/archive/2008/11/21/3344169.aspx