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 bpamarti <bp...@yahoo.com> on 2009/03/04 21:53:10 UTC
Re: Stored Procedure in iBatis
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.
Re: Stored Procedure in iBatis
Posted by Sundar Sankar <fa...@gmail.com>.
I have just used the parameterMap way of things and it works absolutely
fine. The implementation of using Parameter map is given in the
documentation on page 21
-Sundar
On Wed, Mar 4, 2009 at 1:58 PM, Sundar Sankar <fa...@gmail.com> wrote:
> 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 <bp...@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.
>>
>>
>
Re: Stored Procedure in iBatis
Posted by bpamarti <bp...@yahoo.com>.
have changed parameterClass attribute to parameterMap and this worked.
Thanks!
bpamarti wrote:
>
> Could you pls be more specific. projectParam is not a class its an id.
>
> Sundar Sankar wrote:
>>
>> 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 <bp...@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.
>>>
>>>
>>
>>
>
>
--
View this message in context: http://www.nabble.com/Re%3A-Stored-Procedure--in-iBatis-tp22339083p22339555.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
Re: Stored Procedure in iBatis
Posted by bpamarti <bp...@yahoo.com>.
Could you pls be more specific. projectParam is not a class its an id.
Sundar Sankar wrote:
>
> 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 <bp...@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.
>>
>>
>
>
--
View this message in context: http://www.nabble.com/Re%3A-Stored-Procedure--in-iBatis-tp22339083p22339329.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
Re: Stored Procedure in iBatis
Posted by Sundar Sankar <fa...@gmail.com>.
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 <bp...@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.
>
>