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 <[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. >>> >>> >> >> > > -- 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.
