Hi, all. I'm new to hibernate, and I'm having a hard time finding examples on
how to define a mapping for a stored procedure. I'm mainly confused on the
"call" portion.
<sql-query name="GETFUNDINGTYPES" callable="true">
<return alias= "getFundingTypes" class="FundingType">
<return-property name="code" column="CODE"/>
<return-property name="description" column="DESCRIPTION"/>
<return-property name="createTS" column="CREATE_TS"/>
</return>
{? = call GETFUNDINGTYPES ()}
</sql-query>
It may sound silly, but I need to understand the relevance of the "?" 's. I'm
returning all the columns in the table, so I've listed all three as return
properties. (CODE, DESCRIPTION, CREATE_TS)
1. What goes in the method call parens? Is it the number of input/output
that the DB2 stored procedure has defined? Or is it the number of return
properties, ie GETFUNDINGTYPES(?,?,?); one '?' for each return property listed.
Or do I leave it empty as I have done above since I've already listed the
return properties?
2. What does the '?' to the left of the '=' mean? Is it the number of actual
results? If that is true, then is it always one '?' to signify one result set?
Any help that anyone can provide is greatly appreciated.
Thank you,
Paula
Private and confidential as detailed here:
http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the
link, please e-mail sender.
_______________________________________________
hibernate-dev mailing list
hibernate-dev@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/hibernate-dev
