ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sundar Sankar <fatboys...@gmail.com>
Subject Re: Stored Procedure in iBatis
Date Wed, 04 Mar 2009 21:04:45 GMT
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 <fatboysuns@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 <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.
>>
>>
>

Mime
View raw message