ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Baldur Norddahl <bbn-iba...@inaphone.com>
Subject Re: update inside stored procedure
Date Wed, 05 Jan 2005 08:30:36 GMT
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


Mime
View raw message