What version of iBATIS are you running? What database are you running against? It appears to be caused by an exception thrown by the JDBC driver. You should turn on Debugging as Vadim suggested and find out what exact SQL statement is being excecuted.
-Richard -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 07, 2007 9:10 AM To: user-java@ibatis.apache.org Subject: Rif: RE: RE: abator problem values are ok the question is: in jdeveloper (embedded oc4j) the queries (all) are ok in production oc4j no "Yee, Richard K CTR DMDC" <[EMAIL PROTECTED]> 07/03/2007 18.06 Per favore, rispondere a user-java@ibatis.apache.org Per "'user-java@ibatis.apache.org'" <user-java@ibatis.apache.org> CC Oggetto RE: RE: abator problem Christian, What are the values in your EsamiIscrSbf object when the exception occurs? -Richard -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 07, 2007 8:27 AM To: user-java@ibatis.apache.org Subject: Rif: RE: abator problem the problem is: in jdeveloper (in embedded oc4j) run well in production enviroment throw exception "Armeanu, Christian" <[EMAIL PROTECTED]> 07/03/2007 17.24 Per favore, rispondere a user-java@ibatis.apache.org Per <user-java@ibatis.apache.org> CC Oggetto RE: abator problem 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(SqlMapDaoTemplate.ja va:147) at ica2.ibatis.dao.sida.EsamiIscrSbfDAOImpl.updateByPrimaryKeySelective(EsamiIs crSbfDAOImpl.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(EsbfCruscServic e.java:57) at ica.cruscotto.servlet.CruscottoCurrServlet.changeStatoIscrizione(CruscottoCu rrServlet.java:561) at ica.cruscotto.servlet.CruscottoCurrServlet.processRequest(CruscottoCurrServl et.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.ja va: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(ServletRequestDispa tcher.java:604) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.ServletRequestDispatcher.forwardInternal(ServletReq uestDispatcher.java:317) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.ServletRequestDispatcher.forward(ServletRequestDisp atcher.java:251) at oracle.portal.provider.v2.render.http.AbstractResourceRenderer.renderBody(Un known 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.ja va: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(ServletRequestDispa tcher.java:604) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.ServletRequestDispatcher.forwardInternal(ServletReq uestDispatcher.java:317) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.HttpRequestHandler.processRequest(HttpRequestHandle r.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(ReleasableRe sourcePooledExecutor.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(SqlMapDaoTem plate.java:225) at ica2.ibatis.dao.sida.EsamiIscrSbfDAOImpl.selectByPrimaryKey(EsamiIscrSbfDAOI mpl.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.ja va:595) at ica.cruscotto.servlet.CruscottoCurrServlet.processRequest(CruscottoCurrServl et.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.ja va: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(ServletRequestDispa tcher.java:604) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.ServletRequestDispatcher.forwardInternal(ServletReq uestDispatcher.java:317) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.ServletRequestDispatcher.forward(ServletRequestDisp atcher.java:251) at oracle.portal.provider.v2.render.http.AbstractResourceRenderer.renderBody(Un known 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.ja va: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(ServletRequestDispa tcher.java:604) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.ServletRequestDispatcher.forwardInternal(ServletReq uestDispatcher.java:317) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.HttpRequestHandler.processRequest(HttpRequestHandle r.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(ReleasableRe sourcePooledExecutor.java:192) at java.lang.Thread.run(Thread.java:534) can you help me? it's a library problem? thanks, vincenzo
