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