ibatis-user-cs mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ron Grabowski <rongrabow...@yahoo.com>
Subject Re: c# ibatis:procedure
Date Sun, 19 Feb 2006 17:59:18 GMT
According to this snippet from SqlMap.xsd:

 <xs:element name="sqlMap">
  <xs:complexType>
   <xs:sequence>
    <xs:element ref="alias" minOccurs="0"/>
    <xs:element ref="cacheModels" minOccurs="0"/>
    <xs:element ref="resultMaps" minOccurs="0"/>
    <xs:element ref="statements" minOccurs="0" />
    <xs:element ref="parameterMaps" minOccurs="0"/>
   </xs:sequence>
   <xs:attribute name="namespace" type="xs:string" use="required"/>
  </xs:complexType>
 </xs:element>

try putting your parameterMaps node after the statements node.

--- zhlu@umich.edu wrote:

> Here is another example of procedure call failed:
> 
> - The error occurred while loading SqlMap.
> - loading procedure tag
> - The error occurred in <sqlMap embedded="Resources.assocarray.xml, 
> AssocArray"
> xmlns="http://ibatis.apache.org/dataMapper" />.
> - Check the call_ps_swap_email_address.
>    at 
> IBatisNet.DataMapper.Configuration.DomSqlMapBuilder.Build(XmlDocument
> 
> docu
> ment, DataSource dataSource, Boolean useConfigFileWatcher, Boolean 
> isCallFromDao
> )
>    at 
> IBatisNet.DataMapper.Configuration.DomSqlMapBuilder.Configure(String 
> resou
> rce)
>    at AssocArray.Call_procedure.go()
> 
> Unhandled Exception: System.NullReferenceException: Object reference 
> not set to
> an instance of an object.
>    at AssocArray.Call_procedure.go()
>    at AssocArray.Call_procedure.Main(String[] args)
> Press any key to continue
> ...........
> 
> --------------------------------------------------
> 
> Heare is the oracle procedure:
> 
> create or replace procedure
> ps_swap_email_address (inout_email_1 in out varchar2, inout_email_2
> in 
> out varchar2)
> is
>   tmp_e varchar2(120);
> begin
>   tmp_e := inout_email_1;
>   inout_email_1 := inout_email_2;
>   inout_email_2 := tmp_e;
> end
> 
> ----------------------------------------------------
> here is the sqlmap.xml file
> 
> <?xml version="1.0" encoding="UTF-8" ?>
> <sqlMap namespace="assocarray"
> xmlns="http://ibatis.apache.org/mapping" 
>         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
> 
> <parameterMap id="swap_result">
> <parameter property="email_1"  direction="InputOutput" 
> column="inout_email_1" />
> <parameter property="email_2"
>   direction="InputOutput" column="inout_email_2" />
> </parameterMap> <statements>
> 
> <procedure id="call_ps_swap_email_address"
> parameterMap="swap_result">
> ps_swap_email_address
> </procedure>
> 
> </statements>
> </sqlMap>
> 
> Could you tell me how to configure the <procedure> tags in the 
> sqlmap.xml file?
> 
> -Henry
> 


Mime
View raw message