ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tommy Kristiansen <to...@commfides.com>
Subject Re: where with multiple where conditions.. ERROR
Date Mon, 11 Dec 2006 11:06:06 GMT

Thanks for a fast replay, but now I get this error...

2006-12-11 11:55:40,578 DEBUG
[com.commfides.servlets.RequestCertficateServlet] Cert wizard 1::: IDENTIFY
fnr=03127634725 partnerCode=1
2006-12-11 11:55:41,079 ERROR
[org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/DWeb].[RequestCertficateServlet]]
Servlet.service() for servlet RequestCertficateServlet threw exception
java.lang.ExceptionInInitializerError
        at
com.commfides.dao.PinOrderDAOiBatis.getLastPinOrder(PinOrderDAOiBatis.java:43)
        at
com.commfides.servlets.RequestCertficateServlet.doWork(RequestCertficateServlet.java:73)
        at
com.commfides.servlets.RequestCertficateServlet.doPost(RequestCertficateServlet.java:386)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
        at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
        at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
        at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
        at
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
        at
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
        at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
        at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
        at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
        at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
        at
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199)
        at
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282)
        at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:754)
        at
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:684)
        at
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:876)
        at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
        at java.lang.Thread.run(Thread.java:595)
Caused by: java.lang.RuntimeException: Error initializing DBConfig class.
Cause: com.ibatis.common.exception.NestedRuntimeException: Error occurred. 
Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause:
com.ibatis.common.exception.NestedRuntimeException: Error parsing XPath
'/sqlMapConfig/sqlMap'.  Cause: com.ibatis.common.xml.NodeletException:
Error parsing XML.  Cause:
com.ibatis.common.exception.NestedRuntimeException: Error parsing XPath
'/sqlMap/select'.  Cause: com.ibatis.sqlmap.client.SqlMapException: Error. 
Could not set parameter class.  Cause: java.lang.ClassNotFoundException:
Bean
Caused by: java.lang.ClassNotFoundException: Bean






Graeme J Sweeney wrote:
> 
> On Mon, 11 Dec 2006, Tommy Kristiansen wrote:
> 
> <snip/>
> 
>>            PinOrder pinorder =  (PinOrder)
>> sqlMap.queryForObject("getLastPinOrder",fnr,partnerCode);
> 
> The signature for this is
> 
> queryForObject(String id,Object parameterObject, Object resultObject)
> 
> You appear to be passing 2 parameters. You need to modify your select to 
> access the parameters e.g.
> 
>>      <select id="getLastPinOrder"
>> resultClass="com.commfides.dao.PinOrder">
> 
> <select id="getLastPinOrder" resultClass="com.commfides.dao.PinOrder" 
> parameterClass="Bean">
> 
>>                  WHERE FNR = #fnr#
>>                  AND ID_PARTNER = #partnerCode#
> 
> where Bean has set/getFnr and set/getPartnerCode
> 
> 
> -- 
> Graeme -
> 
> 

-- 
View this message in context: http://www.nabble.com/where-with-multiple-where-conditions..-ERROR-tf2792846.html#a7792848
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.


Mime
View raw message