Return-Path: 
 <user-java-return-16385-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 88140 invoked from network); 4 Mar 2009 20:53:46 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 4 Mar 2009 20:53:46 -0000
Received: (qmail 6546 invoked by uid 500); 4 Mar 2009 20:53:39 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 6530 invoked by uid 500); 4 Mar 2009 20:53:39 -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 6521 invoked by uid 99); 4 Mar 2009 20:53:39 -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:53:39 -0800
X-ASF-Spam-Status: No, hits=4.0 required=10.0
	tests=DNS_FROM_OPENWHOIS,FORGED_YAHOO_RCVD,SPF_HELO_PASS,SPF_PASS,WHOIS_MYPRIVREG
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of lists@nabble.com designates
 216.139.236.158 as permitted sender)
Received: from [216.139.236.158] (HELO kuber.nabble.com) (216.139.236.158)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 04 Mar 2009 20:53:31 +0000
Received: from isper.nabble.com ([192.168.236.156])
	by kuber.nabble.com with esmtp (Exim 4.63)
	(envelope-from <lists@nabble.com>)
	id 1Ley5W-0007mE-UC
	for user-java@ibatis.apache.org; Wed, 04 Mar 2009 12:53:10 -0800
Message-ID: <22339083.post@talk.nabble.com>
Date: Wed, 4 Mar 2009 12:53:10 -0800 (PST)
From: bpamarti <bpamarti@yahoo.com>
To: user-java@ibatis.apache.org
Subject: Re: Stored Procedure  in iBatis
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Nabble-From: bpamarti@yahoo.com
X-Virus-Checked: Checked by ClamAV on apache.org


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.