Your problem is not with abator, but rather with the statements you try to execute (as stated by the exceptions). Anyway, check your map for illegal characters in field and table names as well as for correct syntax.
Chris ________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 07, 2007 8:14 AM To: user-java@ibatis.apache.org Subject: In: abator problem Importance: High 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(SqlMapDaoTemplat e.java:147) at ica2.ibatis.dao.sida.EsamiIscrSbfDAOImpl.updateByPrimaryKeySelective(Esa miIscrSbfDAOImpl.java:50) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav a:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor Impl.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(EsbfCruscSe rvice.java:57) at ica.cruscotto.servlet.CruscottoCurrServlet.changeStatoIscrizione(Cruscot toCurrServlet.java:561) at ica.cruscotto.servlet.CruscottoCurrServlet.processRequest(CruscottoCurrS ervlet.java:139) at ica.cruscotto.servlet.CruscottoCurrServlet.doPost(CruscottoCurrServlet.j ava: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(ResourceFilterChai n.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(ServletRequestD ispatcher.java:604) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.ServletRequestDispatcher.forwardInternal(Servle tRequestDispatcher.java:317) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.ServletRequestDispatcher.forward(ServletRequest Dispatcher.java:251) at oracle.portal.provider.v2.render.http.AbstractResourceRenderer.renderBod y(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(Unkn own Source) at oracle.webdb.provider.v2.adapter.soapV1.ProviderAdapter.handleHttp(Unkno wn Source) at sun.reflect.GeneratedMethodAccessor726.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor Impl.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(ResourceFilterChai n.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(ServletRequestD ispatcher.java:604) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.ServletRequestDispatcher.forwardInternal(Servle tRequestDispatcher.java:317) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.HttpRequestHandler.processRequest(HttpRequestHa ndler.java:793) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.AJPRequestHandler.run(AJPRequestHandler.java:20 8) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.AJPRequestHandler.run(AJPRequestHandler.java:12 5) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].util.ReleasableResourcePooledExecutor$MyWorker.run(Releasab leResourcePooledExecutor.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(SqlMapDa oTemplate.java:225) at ica2.ibatis.dao.sida.EsamiIscrSbfDAOImpl.selectByPrimaryKey(EsamiIscrSbf DAOImpl.java:72) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav a:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor Impl.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:9 5) at ica.cruscotto.servlet.CruscottoCurrServlet.deleteSbf(CruscottoCurrServle t.java:595) at ica.cruscotto.servlet.CruscottoCurrServlet.processRequest(CruscottoCurrS ervlet.java:151) at ica.cruscotto.servlet.CruscottoCurrServlet.doPost(CruscottoCurrServlet.j ava: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(ResourceFilterChai n.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(ServletRequestD ispatcher.java:604) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.ServletRequestDispatcher.forwardInternal(Servle tRequestDispatcher.java:317) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.ServletRequestDispatcher.forward(ServletRequest Dispatcher.java:251) at oracle.portal.provider.v2.render.http.AbstractResourceRenderer.renderBod y(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(Unkn own Source) at oracle.webdb.provider.v2.adapter.soapV1.ProviderAdapter.handleHttp(Unkno wn Source) at sun.reflect.GeneratedMethodAccessor726.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor Impl.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(ResourceFilterChai n.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(ServletRequestD ispatcher.java:604) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.ServletRequestDispatcher.forwardInternal(Servle tRequestDispatcher.java:317) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.HttpRequestHandler.processRequest(HttpRequestHa ndler.java:793) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.AJPRequestHandler.run(AJPRequestHandler.java:20 8) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.AJPRequestHandler.run(AJPRequestHandler.java:12 5) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].util.ReleasableResourcePooledExecutor$MyWorker.run(Releasab leResourcePooledExecutor.java:192) at java.lang.Thread.run(Thread.java:534) can you help me? it's a library problem? thanks, vincenzo
