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