Return-Path: 
 <user-java-return-16386-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 90191 invoked from network); 4 Mar 2009 20:58:31 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 4 Mar 2009 20:58:31 -0000
Received: (qmail 10767 invoked by uid 500); 4 Mar 2009 20:58:29 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 10751 invoked by uid 500); 4 Mar 2009 20:58:29 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 10742 invoked by uid 99); 4 Mar 2009 20:58:29 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 04 Mar 2009 12:58:29 -0800
X-ASF-Spam-Status: No, hits=2.4 required=10.0
	tests=HTML_MESSAGE,SPF_PASS,WHOIS_MYPRIVREG
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of fatboysuns@gmail.com
 designates 209.85.198.247 as permitted sender)
Received: from [209.85.198.247] (HELO rv-out-0708.google.com) (209.85.198.247)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 04 Mar 2009 20:58:21 +0000
Received: by rv-out-0708.google.com with SMTP id b17so3349526rvf.36
        for <user-java@ibatis.apache.org>;
 Wed, 04 Mar 2009 12:58:00 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=gamma;
        h=domainkey-signature:mime-version:received:in-reply-to:references
         :date:message-id:subject:from:to:content-type;
        bh=BFumn4L74lENdeEOtl+KhjiFp9dlYAhW/lE2zR2vLJc=;
        b=nA370dOPPVXwBlQ/QeDqRt3kjmzrpDl6EFprbLnt9YFWMvT3wCP9JwpKvXJJEbvtNR
         nG919NYu9UYZHP+y2g4DnZ4UyFwK+RqqgR9j+jZNK6mZjXUQB691Ht6kBLIp7aiMx8iS
         CtVWsL8N86yyuw5bBmEL74NEDCttoLM8CNzgY=
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type;
        b=L7BDCtC3eAmInIMzCuNAoXFXvb7GvLeJBEF4zXvVSYrS5dNyFLiIej43MTkjJLpeCS
         ieagNxPI7BUuVxzRLdQNsfSJrtuSgPf0NzEYY8Dzb5TXr84KWvmC3N2OD8EZz5G2iJYn
         Qv46Iq42cxnd6Qgqpp7NHGVjxeXS2yhyKxf+M=
MIME-Version: 1.0
Received: by 10.114.148.2 with SMTP id v2mr156237wad.169.1236200280811; Wed,
	04 Mar 2009 12:58:00 -0800 (PST)
In-Reply-To: <22339083.post@talk.nabble.com>
References: <22339083.post@talk.nabble.com>
Date: Wed, 4 Mar 2009 13:58:00 -0700
Message-ID: <d4ebe7ab0903041258q53b76d99x9663048eb25b62c0@mail.gmail.com>
Subject: Re: Stored Procedure in iBatis
From: Sundar Sankar <fatboysuns@gmail.com>
To: user-java@ibatis.apache.org
Content-Type: multipart/alternative; boundary=0016e64f80909be91a0464514ef1
X-Virus-Checked: Checked by ClamAV on apache.org

--0016e64f80909be91a0464514ef1
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

My guess is u will have to define the full path of the projectParam class.
The error seems to be class not found.. The id and class variables have been
interchanged.



On Wed, Mar 4, 2009 at 1:53 PM, bpamarti <bpamarti@yahoo.com> wrote:

>
> Hi Gurus:
> Can anyone of you please tell me what am I doing wrong here...spent hours
> and couldnt figure out..
>
> <sqlMap namespace="UpdateProject">
>
> <typeAlias alias="projectDetails"
> type="xxx.xxxxxx.xxx.projtracker.beans.ProjectDetailsVO" />
>
> <parameterMap id="projectParam" class="projectDetails"><parameter
> property="project_name" /><parameter property="description" /><parameter
> property="username" /><parameter property="requester_name" /><parameter
> property="department" /></parameterMap>
>
> <!-- Update list of projects -->
> <procedure id="updateProject" parameterClass="projectParam" >{call
> ProjT_UpdateProjectDetails(?,?,?,?,?) }</procedure>
> </sqlMap>
>
>
> These are the errors I am seeing in the log file ------------------->
>
> 3/4/09 14:09:19:731 CST] 00000043 SystemErr     R Caused by:
> com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause:
> java.lang.RuntimeException: Error parsing XPath '/sqlMap/procedure'.
>  Cause:
> com.ibatis.sqlmap.client.SqlMapException: Error.  Could not set parameter
> class.  Cause: java.lang.ClassNotFoundException: projectParam
> [3/4/09 14:09:19:731 CST] 00000043 SystemErr     R      at
> com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:53)
> [3/4/09 14:09:19:731 CST] 00000043 SystemErr     R      at
>
> com.ibatis.sqlmap.engine.builder.xml.SqlMapParser.parse(SqlMapParser.java:51)
> [3/4/09 14:09:19:731 CST] 00000043 SystemErr     R      at
>
> com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser$11.process(SqlMapConfigParser.java:410)
> [3/4/09 14:09:19:731 CST] 00000043 SystemErr     R      at
> com.ibatis.common.xml.NodeletParser.processNodelet(NodeletParser.java:121)
> [3/4/09 14:09:19:731 CST] 00000043 SystemErr     R      ... 29 more
> [3/4/09 14:09:19:731 CST] 00000043 SystemErr     R Caused by:
> java.lang.RuntimeException: Error parsing XPath '/sqlMap/procedure'.
>  Cause:
> com.ibatis.sqlmap.client.SqlMapException: Error.  Could not set parameter
> class.  Cause: java.lang.ClassNotFoundException: projectParam
> [3/4/09 14:09:19:731 CST] 00000043 SystemErr     R      at
> com.ibatis.common.xml.NodeletParser.processNodelet(NodeletParser.java:123)
> [3/4/09 14:09:19:731 CST] 00000043 SystemErr     R      at
> com.ibatis.common.xml.NodeletParser.process(NodeletParser.java:84)
> [3/4/09 14:09:19:731 CST] 00000043 SystemErr     R      at
> com.ibatis.common.xml.NodeletParser.process(NodeletParser.java:102)
> [3/4/09 14:09:19:731 CST] 00000043 SystemErr     R      at
> com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:72)
> [3/4/09 14:09:19:731 CST] 00000043 SystemErr     R      at
> com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:51)
> [3/4/09 14:09:19:731 CST] 00000043 SystemErr     R      ... 32 more
> [3/4/09 14:09:19:731 CST] 00000043 SystemErr     R Caused by:
> com.ibatis.sqlmap.client.SqlMapException: Error.  Could not set parameter
> class.  Cause: java.lang.ClassNotFoundException: projectParam
> [3/4/09 14:09:19:731 CST] 00000043 SystemErr     R      at
>
> com.ibatis.sqlmap.engine.builder.xml.SqlStatementParser.parseGeneralStatement(SqlStatementParser.java:112)
> [3/4/09 14:09:19:731 CST] 00000043 SystemErr     R      at
>
> com.ibatis.sqlmap.engine.builder.xml.SqlMapParser$23.process(SqlMapParser.java:587)
> [3/4/09 14:09:19:731 CST] 00000043 SystemErr     R      at
> com.ibatis.common.xml.NodeletParser.processNodelet(NodeletParser.java:121)
> [3/4/09 14:09:19:731 CST] 00000043 SystemErr     R      ... 36 more
> [3/4/09 14:09:19:731 CST] 00000043 SystemErr     R Caused by:
> java.lang.ClassNotFoundException: projectParam
> [3/4/09 14:09:19:731 CST] 00000043 SystemErr     R      at
>
> com.ibm.ws.classloader.CompoundClassLoader.findClass(CompoundClassLoader.java(Compiled
> Code))
> [3/4/09 14:09:19:731 CST] 00000043 SystemErr     R      at
>
> com.ibm.ws.classloader.CompoundClassLoader.loadClass(CompoundClassLoader.java(Compiled
> Code))
> [3/4/09 14:09:19:731 CST] 00000043 SystemErr     R      at
> java.lang.ClassLoader.loadClass(ClassLoader.java(Compiled Code))
> [3/4/09 14:09:19:731 CST] 00000043 SystemErr     R      at
> java.lang.Class.forName1(Native Method)
> [3/4/09 14:09:19:731 CST] 00000043 SystemErr     R      at
> java.lang.Class.forName(Class.java(Compiled Code))
> [3/4/09 14:09:19:731 CST] 00000043 SystemErr     R      at
> com.ibatis.common.resources.Resources.classForName(Resources.java:265)
> [3/4/09 14:09:19:731 CST] 00000043 SystemErr     R      at
>
> com.ibatis.sqlmap.engine.builder.xml.SqlStatementParser.parseGeneralStatement(SqlStatementParser.java:108)
> [3/4/09 14:09:19:731 CST] 00000043 SystemErr     R      ... 38 more
> [3/4/09 14:12:02:891 CST] 00000034 SystemErr     R
> java.lang.RuntimeException: Error occurred.  Cause:
> com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause:
> java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.
> Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause:
> java.lang.RuntimeException: Error parsing XPath '/sqlMap/procedure'.
>  Cause:
> com.ibatis.sqlmap.client.SqlMapException: Error.  Could not set parameter
> class.  Cause: java.lang.ClassNotFoundException: projectParam
>        at
>
> com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser.parse(SqlMapConfigParser.java:89)
>        at
>
> com.ibatis.sqlmap.client.SqlMapClientBuilder.buildSqlMapClient(SqlMapClientBuilder.java:63)
> .....
> --
> View this message in context:
> http://www.nabble.com/Re%3A-Stored-Procedure--in-iBatis-tp22339083p22339083.html
> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>
>

--0016e64f80909be91a0464514ef1
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

My guess is u will have to define the full path of the projectParam class. =
The error seems to be class not found.. The id and class variables have bee=
n interchanged.<br><br><br><br><div class=3D"gmail_quote">On Wed, Mar 4, 20=
09 at 1:53 PM, bpamarti <span dir=3D"ltr">&lt;<a href=3D"mailto:bpamarti@ya=
hoo.com">bpamarti@yahoo.com</a>&gt;</span> wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204, =
204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div><div></div><=
div class=3D"h5"><br>
Hi Gurus:<br>
Can anyone of you please tell me what am I doing wrong here...spent hours<b=
r>
and couldnt figure out..<br>
<br>
&lt;sqlMap namespace=3D&quot;UpdateProject&quot;&gt;<br>
<br>
&lt;typeAlias alias=3D&quot;projectDetails&quot;<br>
type=3D&quot;xxx.xxxxxx.xxx.projtracker.beans.ProjectDetailsVO&quot; /&gt;<=
br>
<br>
&lt;parameterMap id=3D&quot;projectParam&quot; class=3D&quot;projectDetails=
&quot;&gt;&lt;parameter<br>
property=3D&quot;project_name&quot; /&gt;&lt;parameter property=3D&quot;des=
cription&quot; /&gt;&lt;parameter<br>
property=3D&quot;username&quot; /&gt;&lt;parameter property=3D&quot;request=
er_name&quot; /&gt;&lt;parameter<br>
property=3D&quot;department&quot; /&gt;&lt;/parameterMap&gt;<br>
<br>
&lt;!-- Update list of projects --&gt;<br>
&lt;procedure id=3D&quot;updateProject&quot; parameterClass=3D&quot;project=
Param&quot; &gt;{call<br>
ProjT_UpdateProjectDetails(?,?,?,?,?) }&lt;/procedure&gt;<br>
&lt;/sqlMap&gt;<br>
<br>
<br>
</div></div>These are the errors I am seeing in the log file --------------=
-----&gt;<br>
<br>
3/4/09 14:09:19:731 CST] 00000043 SystemErr =A0 =A0 R Caused by:<br>
com.ibatis.common.xml.NodeletException: Error parsing XML. =A0Cause:<br>
java.lang.RuntimeException: Error parsing XPath &#39;/sqlMap/procedure&#39;=
. =A0Cause:<br>
com.ibatis.sqlmap.client.SqlMapException: Error. =A0Could not set parameter=
<br>
class. =A0Cause: java.lang.ClassNotFoundException: projectParam<br>
[3/4/09 14:09:19:731 CST] 00000043 SystemErr =A0 =A0 R =A0 =A0 =A0at<br>
com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:53)<br>
[3/4/09 14:09:19:731 CST] 00000043 SystemErr =A0 =A0 R =A0 =A0 =A0at<br>
com.ibatis.sqlmap.engine.builder.xml.SqlMapParser.parse(SqlMapParser.java:5=
1)<br>
[3/4/09 14:09:19:731 CST] 00000043 SystemErr =A0 =A0 R =A0 =A0 =A0at<br>
com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser$11.process(SqlMapCo=
nfigParser.java:410)<br>
[3/4/09 14:09:19:731 CST] 00000043 SystemErr =A0 =A0 R =A0 =A0 =A0at<br>
com.ibatis.common.xml.NodeletParser.processNodelet(NodeletParser.java:121)<=
br>
[3/4/09 14:09:19:731 CST] 00000043 SystemErr =A0 =A0 R =A0 =A0 =A0... 29 mo=
re<br>
[3/4/09 14:09:19:731 CST] 00000043 SystemErr =A0 =A0 R Caused by:<br>
java.lang.RuntimeException: Error parsing XPath &#39;/sqlMap/procedure&#39;=
. =A0Cause:<br>
com.ibatis.sqlmap.client.SqlMapException: Error. =A0Could not set parameter=
<br>
class. =A0Cause: java.lang.ClassNotFoundException: projectParam<br>
[3/4/09 14:09:19:731 CST] 00000043 SystemErr =A0 =A0 R =A0 =A0 =A0at<br>
com.ibatis.common.xml.NodeletParser.processNodelet(NodeletParser.java:123)<=
br>
[3/4/09 14:09:19:731 CST] 00000043 SystemErr =A0 =A0 R =A0 =A0 =A0at<br>
com.ibatis.common.xml.NodeletParser.process(NodeletParser.java:84)<br>
[3/4/09 14:09:19:731 CST] 00000043 SystemErr =A0 =A0 R =A0 =A0 =A0at<br>
com.ibatis.common.xml.NodeletParser.process(NodeletParser.java:102)<br>
[3/4/09 14:09:19:731 CST] 00000043 SystemErr =A0 =A0 R =A0 =A0 =A0at<br>
com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:72)<br>
[3/4/09 14:09:19:731 CST] 00000043 SystemErr =A0 =A0 R =A0 =A0 =A0at<br>
com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:51)<br>
[3/4/09 14:09:19:731 CST] 00000043 SystemErr =A0 =A0 R =A0 =A0 =A0... 32 mo=
re<br>
[3/4/09 14:09:19:731 CST] 00000043 SystemErr =A0 =A0 R Caused by:<br>
com.ibatis.sqlmap.client.SqlMapException: Error. =A0Could not set parameter=
<br>
class. =A0Cause: java.lang.ClassNotFoundException: projectParam<br>
[3/4/09 14:09:19:731 CST] 00000043 SystemErr =A0 =A0 R =A0 =A0 =A0at<br>
com.ibatis.sqlmap.engine.builder.xml.SqlStatementParser.parseGeneralStateme=
nt(SqlStatementParser.java:112)<br>
[3/4/09 14:09:19:731 CST] 00000043 SystemErr =A0 =A0 R =A0 =A0 =A0at<br>
com.ibatis.sqlmap.engine.builder.xml.SqlMapParser$23.process(SqlMapParser.j=
ava:587)<br>
[3/4/09 14:09:19:731 CST] 00000043 SystemErr =A0 =A0 R =A0 =A0 =A0at<br>
com.ibatis.common.xml.NodeletParser.processNodelet(NodeletParser.java:121)<=
br>
[3/4/09 14:09:19:731 CST] 00000043 SystemErr =A0 =A0 R =A0 =A0 =A0... 36 mo=
re<br>
[3/4/09 14:09:19:731 CST] 00000043 SystemErr =A0 =A0 R Caused by:<br>
java.lang.ClassNotFoundException: projectParam<br>
[3/4/09 14:09:19:731 CST] 00000043 SystemErr =A0 =A0 R =A0 =A0 =A0at<br>
com.ibm.ws.classloader.CompoundClassLoader.findClass(CompoundClassLoader.ja=
va(Compiled<br>
Code))<br>
[3/4/09 14:09:19:731 CST] 00000043 SystemErr =A0 =A0 R =A0 =A0 =A0at<br>
com.ibm.ws.classloader.CompoundClassLoader.loadClass(CompoundClassLoader.ja=
va(Compiled<br>
Code))<br>
[3/4/09 14:09:19:731 CST] 00000043 SystemErr =A0 =A0 R =A0 =A0 =A0at<br>
java.lang.ClassLoader.loadClass(ClassLoader.java(Compiled Code))<br>
[3/4/09 14:09:19:731 CST] 00000043 SystemErr =A0 =A0 R =A0 =A0 =A0at<br>
java.lang.Class.forName1(Native Method)<br>
[3/4/09 14:09:19:731 CST] 00000043 SystemErr =A0 =A0 R =A0 =A0 =A0at<br>
java.lang.Class.forName(Class.java(Compiled Code))<br>
[3/4/09 14:09:19:731 CST] 00000043 SystemErr =A0 =A0 R =A0 =A0 =A0at<br>
com.ibatis.common.resources.Resources.classForName(Resources.java:265)<br>
[3/4/09 14:09:19:731 CST] 00000043 SystemErr =A0 =A0 R =A0 =A0 =A0at<br>
com.ibatis.sqlmap.engine.builder.xml.SqlStatementParser.parseGeneralStateme=
nt(SqlStatementParser.java:108)<br>
[3/4/09 14:09:19:731 CST] 00000043 SystemErr =A0 =A0 R =A0 =A0 =A0... 38 mo=
re<br>
[3/4/09 14:12:02:891 CST] 00000034 SystemErr =A0 =A0 R<br>
java.lang.RuntimeException: Error occurred. =A0Cause:<br>
com.ibatis.common.xml.NodeletException: Error parsing XML. =A0Cause:<br>
java.lang.RuntimeException: Error parsing XPath &#39;/sqlMapConfig/sqlMap&#=
39;.<br>
Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. =A0Cause:=
<br>
java.lang.RuntimeException: Error parsing XPath &#39;/sqlMap/procedure&#39;=
. =A0Cause:<br>
com.ibatis.sqlmap.client.SqlMapException: Error. =A0Could not set parameter=
<br>
class. =A0Cause: java.lang.ClassNotFoundException: projectParam<br>
 =A0 =A0 =A0 =A0at<br>
com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser.parse(SqlMapConfigP=
arser.java:89)<br>
 =A0 =A0 =A0 =A0at<br>
com.ibatis.sqlmap.client.SqlMapClientBuilder.buildSqlMapClient(SqlMapClient=
Builder.java:63)<br>
.....<br>
<font color=3D"#888888">--<br>
View this message in context: <a href=3D"http://www.nabble.com/Re%3A-Stored=
-Procedure--in-iBatis-tp22339083p22339083.html" target=3D"_blank">http://ww=
w.nabble.com/Re%3A-Stored-Procedure--in-iBatis-tp22339083p22339083.html</a>=
<br>

Sent from the iBATIS - User - Java mailing list archive at Nabble.com.<br>
<br>
</font></blockquote></div><br>

--0016e64f80909be91a0464514ef1--