You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by Paul Woods <pa...@woodsfamily.ws> on 2005/01/04 10:11:37 UTC
update inside stored procedure
I thought I had a similiar problem to what the poster of
http://www.mail-archive.com/ibatis-user-java@incubator.apache.org/msg00135.html had, and I tried the solution that worked for him, but without success. After doing as suggested I am not getting any exceptions, but there are no apparent updates being performed on the database either.
Just to verify, my transactionManager tag now looks like:
<transactionManager type="JDBC" commitRequired="true">
... datasource stuff ...
The procedure inside the sqlMap file is:
<procedure id="increment" parameterMap="incrementMap">
{ call incProc(?, ?) }
</procedure>
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.
Thanks for any help provided. Love ibatis.