I know that there is no support for stored procedures yet in 2.1, but I have a object that maps fine to my database except for one column that I need to retrieve using a stored procedure. The data for that column comes from another table, but the logic is too complicated for any join.

What we do now, using regular jdbc, is get the result set and for each row in the result set, pass the parameters to the stored procedure to retrieve the value.

Any ideas, on how this might be accomplished using hibernate?

Not easy. Can you call the stored procedure in a plain select? like "select a, b, procedure() from table"? Then you could use a formula property.

I can call it from a select statement. How do I use this formula property? Can you just point me to the docs?

Thanks

Just make a property in your class where the result should be stored, and then use formula="procedure()" as attribute in the property mapping. Just try it.

Does the property have to be an actual column in the table? Or do I need to create a dummy column? I have the mapping:

<property
name="settlementEntity"
type="java.lang.String"
update="true"
insert="true"
access="property"
column="settlementEntity"
formula="pkgsca.fReturnEnty( partyB, partyA, account, boughtCurrency, soldCurrency)"
/>

But there is no column settlemententity in my table which is obviously why i need to retrieve it externally.

Thanks

just leave the column attribute out. Just try it :)