Can you provide your sql map "SIDA_ESAMI_ISCR_SBF.abatorgenerated_updateByPrimaryKeySelective"?
[EMAIL PROTECTED] 03/07/2007 11:27 AM Please respond to [email protected] To [email protected] cc 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 [email protected] Per <[email protected]> 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: [email protected] 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.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 ----------------------------------------- This transmission may contain information that is privileged, confidential, legally privileged, and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. Although this transmission and any attachments are believed to be free of any virus or other defect that might affect any computer system into which it is received and opened, it is the responsibility of the recipient to ensure that it is virus free and no responsibility is accepted by JPMorgan Chase & Co., its subsidiaries and affiliates, as applicable, for any loss or damage arising in any way from its use. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you.
