ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kezerashvili, Denis" <Denis.Kezerashv...@gs.com>
Subject iBATIS with DB2 stored procedure call problem
Date Thu, 13 Dec 2007 18:41:31 GMT

> We are using iBATIS as a persistence layer running on top of DB2.
> We've ran into a problem executing stored procedure.
> 
> The following works:
> <procedure id="user.deleteById" parameterClass="DaoUserId">		
> 		{call PERMIT.PERMIT_DELETE_USER_BY_ID_SP(#id#,
> #updateId#)} 
> </procedure>
> 
> But this does not:
> <procedure id="user.deleteById" parameterClass="DaoUserId">		
> 		{call PERMIT_DELETE_USER_BY_ID_SP(#id#, #updateId#)} 
> </procedure>
> 
> The error reported is that stored procedure named
> PERMIT_DELETE_USER_BY_ID_SP cannot be found.
> 
> Basically we are forced to specify the schema name for the stored
> procedure. The schema name is set up in the config file and we do not
> have to specify it for any regular <insert>, <update>, <delete>
> elements.
> 
> Have anyone seen this problem and knows how to solve it? We have
> multiple schemas used by different developers, so hard coding it is
> not an option.
> 
> Thank you in advance. 

Mime
View raw message