hello,
i have a problem with abator
my code run ok in jdeveloper (10.1.3.1)
and throws an exception in production (oc4j version 9.0.4.1)
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
