Refcursor and postgresql how to make it work ?

[David Gagnon]

Hi all,

 I have seen how to map an oracle refcursor here:
 
http://opensource.atlassian.com/confluence/oss/pages/viewpage.action?pageId=5653

I tried to make it works with postgreql 8.1.4 and the latest driver 
without success. 
I know Postgresql complain about jdbcType="cursor" that why I put 
jdbcType="OTHER".  This doesn`t work :-(  I just get an empty list.

More resultMap element is not allowed in the DTD for a parameter 
element... Is that normal?

Any idea how to make it works will be greatly appreciated!

Best Regards
/David


   <resultMap id="transactionRequestResultForItem" 
class="java.util.HashMap">
       <result property="id" columnIndex="1" javaType="java.lang.String"/>
       <result property="companyId" columnIndex="2" 
javaType="java.lang.String"/>
       <result property="requestDate" columnIndex="3" 
javaType="com.davecorp.webos.util.businessType.MultiFieldTimestamp" 
nullValue="set=EmptyDateOnNull"/>
       <result property="source" columnIndex="4"/>
       <result property="quantity" columnIndex="5"/>
       <result property="balanceBefore" columnIndex="6"/>
       <result property="balanceAfter" columnIndex="7"/>
   </resultMap>


<parameterMap id="transactionRequest.getListByItem.output" class="map">
       <parameter property="o" javaType="java.sql.ResultSet" 
jdbcType="OTHER" mode="OUT" esultMap="transactionRequestResultForItem" />
       <parameter property="itemId"  jdbcType="varchar" mode="IN"  />
       <parameter property="warehouseId"  jdbcType="varchar" mode="IN"  />
   </parameterMap>

   <procedure id="transactionRequest.getListByItem" 
parameterMap="transactionRequest.getListByItem.output" >
       { ? = call usp_Catalogue_Inventaire(?, ?, 100) }</procedure>