Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 73481 invoked from network); 28 Jun 2006 07:15:29 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 28 Jun 2006 07:15:29 -0000 Received: (qmail 44775 invoked by uid 500); 28 Jun 2006 07:15:23 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 44728 invoked by uid 500); 28 Jun 2006 07:15: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 44694 invoked by uid 99); 28 Jun 2006 07:15:22 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 28 Jun 2006 00:15:22 -0700 X-ASF-Spam-Status: No, hits=0.6 required=10.0 tests=HTML_MESSAGE,NO_REAL_NAME X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.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; Wed, 28 Jun 2006 00:15:21 -0700 Received: from esma_integris2.integris.es ([10.90.31.241]) by hermes.steria.es (8.12.10/8.12.9) with ESMTP id k5S7Ew3l014932 for ; Wed, 28 Jun 2006 09:14:58 +0200 To: user-java@ibatis.apache.org Subject: Re: how to use function in resultMap MIME-Version: 1.0 X-Mailer: Lotus Notes Release 5.0.10 March 22, 2002 Message-ID: From: Esperanza.Echeverria@steria.es Date: Wed, 28 Jun 2006 09:14:27 +0200 X-MIMETrack: Serialize by Router on ESMA_INTEGRIS2/ES/INTEGRIS_EU(Release 5.0.11 |July 24, 2002) at 28/06/2006 09:15:03, Serialize complete at 28/06/2006 09:15:03 Content-Type: multipart/related; boundary="=_related 0028940EC125719B_=" X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Este es un mensaje de varios componentes en formato MIME. --=_related 0028940EC125719B_= Content-Type: multipart/alternative; boundary="=_alternative 0028940EC125719B_=" --=_alternative 0028940EC125719B_= Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable i have made an oraclecursor with alias in the columns and i have no=20 problem... i don=B4t understand.... if you put the select in this way and compile the procedure, what is the=20 error you obtain??=20 select sum(salary) SALARY from employeeInfo;=20 no other ideas, sorry. =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 puneet arya 28/06/2006 09:09 Please respond to user-java =20 To: user-java@ibatis.apache.org cc:=20 Subject: Re: how to use function in resultMap hi, Yes You are right ki should not have name in the resultMap but alias=20 we cant put like that . not only in this case(where i m using sum function)= but in the normal case when we are using resultMap alias can't be used . Regards, Puneet Arya Esperanza.Echeverria@steria.es wrote: but if in yout select you only have the salary column and not the name you = must erase the name column in the resultmap.... =20 =20 =20 and to put the alias "salary" in the pl select.=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 puneet arya =20 28/06/2006 07:39=20 Please respond to user-java=20 =20 To: user-java@ibatis.apache.org=20 cc: =20 Subject: how to use function in resultMap Hi,=20 I am trying to use sum function (Pl/Sql) in my stored procedure as=20 =20 select sum(salary) from employeeInfo;=20 =20 But while defining a result Map i m writing as=20 =20 =20 =20 =20 and in parameterMap=20 =20 =20 =20 =20 =20 =20 =20 { call SP=5FEMPLOYEE(?, ?) }=20 =20 =20 But because i m using the sum function so it is giving error like=20 =20 The error occurred while applying a result map. Check the Employee.spEmployeeInfo. Check the result mapping for the 'salary' property. Cause: java.sql.SQLException: Invalid column name=20 =20 So how to Use the sum function in my case,,please suggest=20 Regards,=20 Puneet Arya=20 Yahoo! India Answers: Share what you know. Learn something new Click here Catch all the FIFA World Cup 2006 action on Yahoo! India Click here=20 Yahoo! India Answers: Share what you know. Learn something new Click here Catch all the FIFA World Cup 2006 action on Yahoo! India Click here --=_alternative 0028940EC125719B_= Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
i have made an oraclecursor with ali= as in the columns and i have no problem... i don=B4t understand....

if you put the select in this way an= d compile the procedure,  what is the error you obtain??

select sum(salary) SALARY from = employeeInfo;

no other ideas, sorry.

 

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

 

 


puneet arya <puneet=5Farya=5Fo= ld@yahoo.co.in>

28/06/2006 09:09
Please respond to user-java

       
        To: &nbs= p;      user-java@ibatis.apache.org
        cc: &nbs= p;      
        Subject:=        Re: how to use function in resultMap


hi,
   Yes You are right = ki  should not have name in the resultMap but alias we cant put like t= hat . not only in this case(where i m using sum function) but in the= normal  case when we are using resultMap alias can't be used .
Regards,
Puneet Arya

Esperanza.Echeverria@steria.es wrote:

but if in yout select you only have the salary column and not the name you = must erase the name column in the resultmap....
<resultMa= p id<= font size=3D2 face=3D"Times New Roman">=3D"spEmployeeInfo" class =3D "employee">=

<result <= /font>property=3D"salary" column =3D "SALARY"/> <= /font>
</resultMap>
and to put the alias "salary" in the pl select.

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
puneet arya <punee= t=5Farya=5Fold@yahoo.co.in>
28/06/2006 07:39
Please respond to user-java = 		        <= /font>
       To:        user-java@ibatis= .apache.org
       cc:         <= br>        Subject:        how to use = function in resultMap




Hi,
  I am trying to use sum function (Pl/Sql) in my stored proced= ure as  
 
select sum(salary) from employeeInfo;
 
But while defining a result Map i m writing as
<resultMa= p id<= font size=3D2 face=3D"Times New Roman">=3D"spEmployeeInfo" class =3D "employee">=
<result <= /font>property=3D"name" column =3D "NAME"/>
<result <= /font>property=3D"salary" column =3D "SALARY"/> <= /font>
</resultMap>
and in parameterMap
 
<paramete= rMap id =3D "inputEmployeeMap" class =3D "employeeMap" >
<paramete= r property=3D"name" jdbcType=3D"VARCHAR2" avaType= =3D"jav= a.lang.String" mode=3D"IN"/>
<paramete= r property=3D"outputname" = jdbcType=3D"ORACLECURSOR" = mode = =3D "OUT" resultMap =3D "spEmployeeInfo" />
</parameterMap>
 
<procedur= e id = =3D "getEmployeeList" parameterMap=3D"inputEmployeeMap" resultMap=3D"spEmployeeInfo">
{ call SP=5FEMPLOYEE(?, ?) }=
</procedu= re>
 
But because i m using the sum function so it is giving error like
 
The error occurred while ap= plying a result map.
Check the Employee.spEmployeeInfo.
Check the result mapping for the 'salary' property.
Cause: java.sql.SQLException: Invalid column name
 
So how to Use the sum function in my case,,please suggest
Regards,
Puneet Arya
Yahoo! India Answers: Share wha= t you know. Learn something new Click here
Catch all the FIFA World Cup 2006 action on Yahoo! India = Click here

 

Yahoo! India Answers: Share wha= t you know. Learn something new Click here
Catch all the FIFA World Cup 2006 action on Yahoo! India = Click here

--=_alternative 0028940EC125719B_=-- --=_related 0028940EC125719B_= Content-Type: image/jpeg Content-ID: <_2_02FC000073680028940EC125719B> 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 0028940EC125719B_= Content-Type: image/jpeg Content-ID: <_2_14A0000043480028940EC125719B> 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 0028940EC125719B_=--