Paul Woods wrote:
The procedure inside the sqlMap file is:
<procedure id="increment" parameterMap="incrementMap">
{ call incProc(?, ?) }
</procedure>
Try the <select> tag instead:
<select id="increment" parameterMap="incrementMap"> select incProc(?,?) </select>
I'm calling it with (update/insert threw exceptions for me): sqlMap.queryForObject("increment", map);
I'm using postgresql 7.3, the stored procedure works fine when called
from psql. I tried ibatis 2.0.8 w/o luck, and just saw and tried 2.0.9
w/ the same results.
Postgresql does not really have stored procedures, only user defined functions that are invoked with select.
Baldur
