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