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 <[email protected]> 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 <[email protected]> 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. >> >> >
