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.