Re: not resolved

Fri, 09 Mar 2007 01:11:09 -0800 

ciao Vincenzo,
you posted only the stack trace, in order to diagnose the problem we need the ibatis log with the sql executed along with the parameters. 
here is an example of log4j.properties that enables ibatis sql logging

log4j.logger.com.ibatis=DEBUG, file
log4j.additivity.com.ibatis=false

log4j.logger.java.sql=DEBUG, file
log4j.additivity.java.sql=false

log4j.appender.file.File=D:/tomcat-5.5.20/webapps/gic/WEB-INF/log/application.log
log4j.appender.file.Append = false
log4j.appender.file.layout=org.apache.log4j.PatternLayout
log4j.appender.file.layout.ConversionPattern=%d %c %M %L %p %m %n

Hope it helps,
        Giovanni



hello,

i have a problem in my app
my code RUN OK in jdeveloper (10.1.3.1) and throws an exception in production (oc4j version 9.0.4.1, jdk 1.4.2) 

i write this code:
// 
       EsamiIscrSbf esbf = new EsamiIscrSbf();
       ...
       EsamiIscrSbfDAO esbfDAO = ...;
       esbfDAO.updateByPrimaryKeySelective(esbf);
       //




i have this log:
com.ibatis.dao.client.DaoException: Failed to update - id [SIDA_ESAMI_ISCR_SBF.abatorgenerated_updateByPrimaryKeySelective] - parameterObject [EMAIL PROTECTED] Cause: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in ica2/ibatis/sida/SIDA_ESAMI_ISCR_SBF_SqlMap.xml. --- The error occurred while executing mapped statement. --- Check the SIDA_ESAMI_ISCR_SBF.abatorgenerated_updateByPrimaryKeySelective. --- Check the statement or the result map. --- Cause: java.sql.SQLException: invalid arguments in call 
Caused by: java.sql.SQLException: invalid arguments in call
at com.ibatis.dao.client.template.SqlMapDaoTemplate.update(SqlMapDaoTemplate.java:147) at ica2.ibatis.dao.sida.EsamiIscrSbfDAOImpl.updateByPrimaryKeySelective(EsamiIscrSbfDAOImpl.java:50) 
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 
       at java.lang.reflect.Method.invoke(Method.java:324)
       at com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java:72)
       at $Proxy11.updateByPrimaryKeySelective(Unknown Source)
at ica.cruscotto.service.EsbfCruscService.changeStatoIscrizione(EsbfCruscService.java:57) at ica.cruscotto.servlet.CruscottoCurrServlet.changeStatoIscrizione(CruscottoCurrServlet.java:561) at ica.cruscotto.servlet.CruscottoCurrServlet.processRequest(CruscottoCurrServlet.java:139) at ica.cruscotto.servlet.CruscottoCurrServlet.doPost(CruscottoCurrServlet.java:215) 
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:65) 
       at oracle.security.jazn.oc4j.JAZNFilter.doFilter(Unknown Source)
at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:604) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:317) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:251) at oracle.portal.provider.v2.render.http.AbstractResourceRenderer.renderBody(Unknown Source) at oracle.portal.provider.v2.render.RenderManager.render(Unknown Source) at oracle.portal.provider.v2.DefaultPortletInstance.render(Unknown Source) at oracle.webdb.provider.v2.adapter.soapV1.ProviderAdapter.showPortlet(Unknown Source) at oracle.webdb.provider.v2.adapter.soapV1.ProviderAdapter.handleHttp(Unknown Source) 
       at sun.reflect.GeneratedMethodAccessor726.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 
       at java.lang.reflect.Method.invoke(Method.java:324)
at oracle.webdb.provider.v2.adapter.SOAPServlet.doHTTPCall(Unknown Source) at oracle.webdb.provider.v2.adapter.SOAPServlet.service(Unknown Source) 
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:65) 
       at oracle.security.jazn.oc4j.JAZNFilter.doFilter(Unknown Source)
at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:604) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:317) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:793) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.AJPRequestHandler.run(AJPRequestHandler.java:208) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.AJPRequestHandler.run(AJPRequestHandler.java:125) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192) 
       at java.lang.Thread.run(Thread.java:534)






and  in this code:
      //
      EsamiIscrSbfKey esbfKey = new EsamiIscrSbfKey();
       ...
EsamiIscrSbfDAO esbfDAO = ...; 
       EsamiIscrSbf esbf = esbfDAO.selectByPrimaryKey(esbfKey);
       esbf.setEsbfSlexCodmot(codmot);
esbfDAO.updateByPrimaryKey(esbf); // i have this log :
com.ibatis.dao.client.DaoException: Failed to execute queryForObject - id [SIDA_ESAMI_ISCR_SBF.abatorgenerated_selectByPrimaryKey], parameterObject [EMAIL PROTECTED] Cause: java.sql.SQLException: invalid arguments in call at com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForObject(SqlMapDaoTemplate.java:225) at ica2.ibatis.dao.sida.EsamiIscrSbfDAOImpl.selectByPrimaryKey(EsamiIscrSbfDAOImpl.java:72) 
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 
       at java.lang.reflect.Method.invoke(Method.java:324)
       at com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java:72)
       at $Proxy11.selectByPrimaryKey(Unknown Source)
at ica.cruscotto.service.EsbfCruscService.deleteSbf(EsbfCruscService.java:95) at ica.cruscotto.servlet.CruscottoCurrServlet.deleteSbf(CruscottoCurrServlet.java:595) at ica.cruscotto.servlet.CruscottoCurrServlet.processRequest(CruscottoCurrServlet.java:151) at ica.cruscotto.servlet.CruscottoCurrServlet.doPost(CruscottoCurrServlet.java:215) 
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:65) 
       at oracle.security.jazn.oc4j.JAZNFilter.doFilter(Unknown Source)
at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:604) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:317) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:251) at oracle.portal.provider.v2.render.http.AbstractResourceRenderer.renderBody(Unknown Source) at oracle.portal.provider.v2.render.RenderManager.render(Unknown Source) at oracle.portal.provider.v2.DefaultPortletInstance.render(Unknown Source) at oracle.webdb.provider.v2.adapter.soapV1.ProviderAdapter.showPortlet(Unknown Source) at oracle.webdb.provider.v2.adapter.soapV1.ProviderAdapter.handleHttp(Unknown Source) 
       at sun.reflect.GeneratedMethodAccessor726.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 
       at java.lang.reflect.Method.invoke(Method.java:324)
at oracle.webdb.provider.v2.adapter.SOAPServlet.doHTTPCall(Unknown Source) at oracle.webdb.provider.v2.adapter.SOAPServlet.service(Unknown Source) 
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:65) 
       at oracle.security.jazn.oc4j.JAZNFilter.doFilter(Unknown Source)
at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:604) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:317) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:793) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.AJPRequestHandler.run(AJPRequestHandler.java:208) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.AJPRequestHandler.run(AJPRequestHandler.java:125) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192) 
       at java.lang.Thread.run(Thread.java:534)


can you help me?  it's a library problem?


thanks,
vincenzo



--
Giovanni Cuccu
CUP 2000 Spa
Via del Borgo di S. Pietro, 90/c - 40126 Bologna
e-mail: giovanni.cuccu _at_ cup2000.it
  • not resolved v . viggiani
    • Re: not resolved Giovanni Cuccu - CUP2000

Reply via email to