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 Es...@steria.es on 2006/10/30 17:19:49 UTC

a question about oraclecursor and parameter with resultMap in dtd

hello, i have a problem...and i need to solve it....
here is all my code .... i obtain this error:


Caused by: java.lang.RuntimeException: No se ha podido inicializar la 
conexión a la base de datos. Causa: com.ibatis.dao.client.DaoException: 
Error while configuring DaoManager.  Cause: 
com.ibatis.common.exception.NestedRuntimeException: Error occurred. Cause: 
com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: 
com.ibatis.common.exception.NestedRuntimeException: Error parsing XPath 
'/sqlMapConfig/sqlMap'.  Cause: com.ibatis.common.xml.NodeletException: 
Error parsing XML.  Cause: org.xml.sax.SAXParseException: <Line 59, Column 
75>: XML-0137: (Error) Attribute 'resultMap' used but not declared.
Caused by: org.xml.sax.SAXParseException: <Line 59, Column 75>: XML-0137: 
(Error) Attribute 'resultMap' used but not declared.


the resultMap is declared as you can see in the code... i think if this is 
something about dtd problem.... please, any help will be very 
appreciated...

<resultMap id="emp" class="A14">
        <result property="ars_codi" column="ARS_CODI" />
        <result property="a14_fech" column="A14_FECH" />
        <result property="a14_fdes" column="A14_FDES" />
        <result property="a14_fhas" column="A14_FHAS" />
        <result property="usi_codi" column="USI_CODI" />
    </resultMap>
 
 
  <parameterMap id="swapParameters" class="java.util.HashMap" >
    <parameter property="usi_codi" jdbcType="VARCHAR" 
javaType="java.lang.String" mode="OUT"/>
    <parameter property="a14" jdbcType="ORACLECURSOR" mode="OUT" 
resultMap="emp"/>
  </parameterMap>
 
  <procedure id="swapEmailAddresses" parameterMap="swapParameters" >
    {call sipj2ee.prueba(?,?)}
  </procedure>
 
 
 and my PL-SQL:
procedure prueba (usicodi out VARCHAR2,mia14 out ref_cursor_t) is
begin
select usi_codi into usicodi from a14 where usi_codi='ADMIN' AND ROWNUM=1;
  open mia14 for
          select ars_codi, a14_fech, a14_fdes, a14_fhas, usi_codi
 from a14 where usi_codi='ADMIN' AND ROWNUM=1;
end;


Thanks in advance..
 
 
 


Esperanza Echeverría de Miguel
Steria España http://www.steria.es
C/Menéndez y Pelayo,3 bis 46010 Valencia
Tel: + 34 96 393 87 50 Fax: +34 96 393 87 51
esperanza.echeverria@steria.es