ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Giovanni Cuccu - CUP2000 <giovanni.cu...@cup2000.it>
Subject Re: not resolved
Date Fri, 09 Mar 2007 09:10:47 GMT
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 [ica2.ibatis.model.sida.EsamiIscrSbf@4b61bf].  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 [ica2.ibatis.model.sida.EsamiIscrSbfKey@1b8896f]. 
>  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


Mime
View raw message