Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 26932 invoked from network); 30 Oct 2006 16:22:33 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 30 Oct 2006 16:22:33 -0000 Received: (qmail 88992 invoked by uid 500); 30 Oct 2006 16:22:24 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 88910 invoked by uid 500); 30 Oct 2006 16:22:23 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 88825 invoked by uid 99); 30 Oct 2006 16:22:23 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 30 Oct 2006 08:22:23 -0800 X-ASF-Spam-Status: No, hits=2.5 required=10.0 tests=HTML_MESSAGE,NO_REAL_NAME X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: local policy) Received: from [62.37.229.68] (HELO hermes.steria.es) (62.37.229.68) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 30 Oct 2006 08:22:09 -0800 Received: from esma_integris2.integris.es ([10.90.31.241]) by hermes.steria.es (8.12.10/8.12.9) with ESMTP id k9UGLk7L025678 for ; Mon, 30 Oct 2006 17:21:46 +0100 To: user-java@ibatis.apache.org Subject: a question about oraclecursor and parameter with resultMap in dtd MIME-Version: 1.0 X-Mailer: Lotus Notes Release 5.0.10 March 22, 2002 Message-ID: From: Esperanza.Echeverria@steria.es Date: Mon, 30 Oct 2006 17:19:49 +0100 X-MIMETrack: Serialize by Router on ESMA_INTEGRIS2/ES/INTEGRIS_EU(Release 5.0.13a |April 8, 2004) at 30/10/2006 17:25:59, Serialize complete at 30/10/2006 17:25:59 Content-Type: multipart/related; boundary="=_related 0059E01FC1257217_=" X-Virus-Checked: Checked by ClamAV on apache.org Este es un mensaje de varios componentes en formato MIME. --=_related 0059E01FC1257217_= Content-Type: multipart/alternative; boundary="=_alternative 0059E01FC1257217_=" --=_alternative 0059E01FC1257217_= Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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=20 conexi=F3n a la base de datos. Causa: com.ibatis.dao.client.DaoException:=20 Error while configuring DaoManager. Cause:=20 com.ibatis.common.exception.NestedRuntimeException: Error occurred. Cause: = com.ibatis.common.xml.NodeletException: Error parsing XML. Cause:=20 com.ibatis.common.exception.NestedRuntimeException: Error parsing XPath=20 '/sqlMapConfig/sqlMap'. Cause: com.ibatis.common.xml.NodeletException:=20 Error parsing XML. Cause: org.xml.sax.SAXParseException: : XML-0137: (Error) Attribute 'resultMap' used but not declared. Caused by: org.xml.sax.SAXParseException: : XML-0137:=20 (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=20 appreciated... =20 =20 =20 {call sipj2ee.prueba(?,?)} =20 =20 and my PL-SQL: procedure prueba (usicodi out VARCHAR2,mia14 out ref=5Fcursor=5Ft) is begin select usi=5Fcodi into usicodi from a14 where usi=5Fcodi=3D'ADMIN' AND ROWN= UM=3D1; open mia14 for select ars=5Fcodi, a14=5Ffech, a14=5Ffdes, a14=5Ffhas, usi=5Fcodi from a14 where usi=5Fcodi=3D'ADMIN' AND ROWNUM=3D1; end; Thanks in advance.. =20 =20 =20 Esperanza Echeverr=EDa de Miguel Steria Espa=F1a http://www.steria.es C/Men=E9ndez y Pelayo,3 bis 46010 Valencia Tel: + 34 96 393 87 50 Fax: +34 96 393 87 51 esperanza.echeverria@steria.es =20 =20 --=_alternative 0059E01FC1257217_= Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

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

Caused by: java.lang.RuntimeException: No se ha podido inicializar la conex= i=F3n a la base de datos. Causa: com.ibatis.dao.client.DaoException: Error = while configuring DaoManager. Cause: com.ibatis.common.exception.Nest= edRuntimeException: Error occurred. Cause: com.ibatis.common.xml.Node= letException: Error parsing XML. Cause: com.ibatis.common.exception.N= estedRuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'. Ca= use: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause= : org.xml.sax.SAXParseException: <Line 59, Column 75>: XML-0137: (Err= or) Attribute 'resultMap' used but not declared.
Caused by: org.xml.sax.SAXParseException: <Line 59, Column 75>: XML-0= 137: (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.... plea= se, any help will be very appreciated...

<resultMap id=3D"emp" c= lass=3D"A14">
<resu= lt property=3D"ars=5Fcodi" column=3D"ARS=5FCODI" /><= /font>
<resu= lt property=3D"a14=5Ffech" column=3D"A14=5FFECH" /><= /font>
<resu= lt property=3D"a14=5Ffdes" column=3D"A14=5FFDES" /><= /font>
<resu= lt property=3D"a14=5Ffhas" column=3D"A14=5FFHAS" /><= /font>
<resu= lt property=3D"usi=5Fcodi" column=3D"USI=5FCODI" /><= /font>
</resultMap>

<parameterMap id=3D"s= wapParameters" class=3D"java.util.HashMap" >
<parameter property= =3D"usi=5Fcodi" jdbcType=3D"VARCHAR" javaType=3D"j= ava.lang.String" mode=3D"OUT"/>
<parameter property= =3D"a14" jdbcType=3D"ORACLECURSOR" mode=3D"OUT&quo= t; resultMap=3D"emp"/>
</parameterMap>

<procedure id=3D"swap= EmailAddresses" parameterMap=3D"swapParameters" >
{call sipj2ee.prueba(?= ,?)}
</procedure>

and my PL-SQL:
procedure prueba (usicodi out VARCHAR2,mia14 out ref= =5Fcursor=5Ft) is
begin
select usi=5Fcodi into usicodi from a14 where usi=5F= codi=3D'ADMIN' AND ROWNUM=3D1;
open mia14 for
select ars=5Fcodi= , a14=5Ffech, a14=5Ffdes, a14=5Ffhas, usi=5Fcodi
from a14 where usi=5Fcodi=3D'ADMIN' AND ROWNUM= =3D1;
end;

Thanks in advance..

Esperanza Echeverr=EDa de Mi= guel
Steria Espa=F1a http://www.steria.es
C/Men=E9ndez y Pelayo,3 bis 46010 Valencia
Tel: + 34 96 393 87 50 Fax: +34 96 393 87 51
esperanza.echeverria@steria.es

--=_alternative 0059E01FC1257217_=-- --=_related 0059E01FC1257217_= Content-Type: image/jpeg Content-ID: <_2_1EE000002FC40059E01FC1257217> Content-Transfer-Encoding: base64 /9j/4AAQSkZJRgABAQEAYABgAAD//gAcU29mdHdhcmU6IE1pY3Jvc29mdCBPZmZpY2X/2wBDAAoH BwgHBgoICAgLCgoLDhgQDg0NDh0VFhEYIx8lJCIfIiEmKzcvJik0KSEiMEExNDk7Pj4+JS5ESUM8 SDc9Pjv/2wBDAQoLCw4NDhwQEBw7KCIoOzs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7 Ozs7Ozs7Ozs7Ozs7Ozs7Ozv/wAARCABbAKIDASIAAhEBAxEB/8QAGwABAAIDAQEAAAAAAAAAAAAA AAQGAwUHAQL/xAA6EAABBAECAwUGAwUJAAAAAAABAAIDBAUGERIhMRNBUXGhBxRhYoGxFSKRIzIz ctE0NUJSY3OCweH/xAAaAQEAAwEBAQAAAAAAAAAAAAAAAQMFBAIG/8QALBEAAgEDAwEFCQEAAAAA AAAAAAECAxESBAUhMRNBYYGhFTJRcZGxwdHw4f/dAAQAKP/aAAwDAQACEQMRAD8A7MiIgCIiAIiI AiLwEEkAgkdUB6iIgCIiAIvF6gCIiAIiIAiIgCIiAIiIAiIgMc8zK8Ek8h2ZG0vcfgBuVUKGr89n oDbwmnYpanEWtksXGsc7b5QOSt88jIq8kkjS5jGFzgBuSAOfLvXM53ezuaV0zIcjQkdzIgini5+Q Gy6KMU07q/8AeRDLzi7ednrWXZPFwVZmD9gyOxxiQ7HqduXPZUPTd7UkeqtQSVMPXntPlabEL7XC 2I7nkDtz71M0tJeOq4W4OfLz4Psz7wciDwg7HbgLufXb1X1SybNKa3z0uVq22Q35Gvgljgc9rhz7 x5q5RxySSd108wWHJ6tfjX08c3HPt5q1GHe5wPG0fiS89B1/RYJc5q6nE6zZ0xBLCwbuZWuB0gHk Rz+i0mtNPPOpos/Jj7ORx0sQZYirPLZY9hycNuZH/qgtb7PNt3R5hju9rhY3CiNODimlf++YLhLr agdIS6iqRPnji2a6Enhc124Gx8OqiVc/rG9XjtV9MVWwStD2dpdAJaeYPRQtTafx2F9neSixEEoj sGOQtLnPJPE3x59Fa9PgjTuNBBBFWPcH+UKt4RjklfnvBocTZrv9pOVgFN0dltVhfN27nB3JnLg6 Dz+CnZPJ6nrXZW0sLTmqNI4JpbgjLuXPcbcua0dNlpvtN1C+sw9qaA7Fzm/lL9m7c/NaHHOwLmOf rVmWmyoce1ZYZKYxz5cIby22VmCbv14Xj+QWqDXFqtlauPzWMirm2/s4pq1pszQ7psQOY6hXFclt xYK9nMK3S2FsR9jca+xK2o9o4dx1J8Oa60qq0Yxs0rBBERc5IREQBERAedOZVZv+0LT1C17u6xJM Q7Z74WcTW/Xv+m6sxAI2PMLQ3ND6cvSF8uMjaSdz2TiwH6A7L1HHvOnTvT3fbX8LWNm3L414BbkK xB/1W/1WRl6m/wDctwO8pAV9itA1jWCFnC0AAcI5BfDsfSf+/Tgd5xg/9JwcxnDg4btII+CKE7C4 xx39xhafFjeH7Lz8HrtG0UtqH+Sw/wCxJCcAnooHuNyP+DlJtvCaNjx6AH1Tiy8XWOpZHyudEf0O 49Ut4gnotf8Aioi/tdOzW26uLONv6t39dlKr2q9tnHXnjlb4scDsoaaBmREUAjxzvdkJq5A4I42O B79yXb/YKQoUP982v9iL7vXxm77sbiprEe3aDZrN/E8lFSShFyfRI9Qi5yUV1ZP6ICD0O65dPbs2 Xl89iWRx73OKxiSRp3bI8eTisV7ur8Q9f8NdbU7cz9DqyLmcOWyNf+Fdnb8C8keq2MGs8hVaXWey mjaN3Fw4SB5hXQ3WlJ2kmvUqntlVe60y9otXp3OR6hxLMhFXkgY5zmhsnfseoPeFtFqmbOEoScZd UEREPIREQBERAEREAREQBRLGMp2X9o+ENl7pYyWPH/Ic1LRSm10BrizJUucTxfiH+CTZso8ndD9d vNYa2Sv5AO93r167mHZ8c8hMjPNoHL9Vt1Eu0Y7O0weYLEY/Zzt6t+B8R4gqVJd4IzKuVbakse8U +KRjWFvYu2G2/wA3zKHnquUs4mZkhqvawcZ7Nrg7lz5bkrYVMrFIwstPjinjdwvAd+Vx8WnwPp0U 5j2Ss4mOa9p5bg7hUzlCtGVNNPi3BZBypyU7dD//0JyKzZnSVls5mxbGSsedzE5/CWeRPctbFo/U Vl2zvc6TP8znmV30AAHqvlvZ2oyxx8z6mOroSjlkkaeexDViMs8gYwd5UvC6XvapkZPdZJTxAO4Y eUlj+g+KtWJ0Ji8fM21cc/I228xJY24Wn5W9B6qzrX0u3wovKXL+xw6jclbGj9f0Y69eGrXjr142 xxRtDWMaNg0DuWREWkYjdwiIgCIiAIiIAiIgCIiAIiIAot+k29B2bnFpB3aR4qUi8VKcasHCaumT GTi7oqFuhYpu2lZ+XueOhX3ped7c/eqtO8ToWSub3B++3qPsrWQHAggEHuKxQU61Z8j4II4nSHd5 Y0Au81j6XaFptT2tOXHwOuWqzpuMlyZkRFtnGEREAREQBERAEREAREQBERAEREAREQBERAEREARE QBERAEREAREQH//Z --=_related 0059E01FC1257217_=--