ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vadim Grinshpun <va...@ll.mit.edu>
Subject Re: Rif: RE: RE: abator problem
Date Wed, 07 Mar 2007 17:20:56 GMT
Have you tried turning on logging? (see here for details:  
 http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+get+SqlMapClient+to+log+SQL+statements
)

This would allow you to see both the actual PreparedStatement that is 
being used, as well as the parameters that are being passed in. 
Comparing both of these between the two environments might shed some 
light on your situation.

-Vadim




v.viggiani@amm.unibs.it wrote:
>
> values are ok
>
> the question is:
>
>    in  jdeveloper (embedded oc4j) the queries (all) are ok
>
>   in production oc4j no
>
>
>
>
> *"Yee, Richard K CTR DMDC" <Richard.Yee.ctr@osd.pentagon.mil>*
>
> 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: v.viggiani@amm.unibs.it [mailto:v.viggiani@amm.unibs.it]
> 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" <ArmeanuC@hsd.k12.or.us>
>
> 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: v.viggiani@amm.unibs.it [mailto:v.viggiani@amm.unibs.it]
> 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 [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.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
> [ica2.ibatis.model.sida.EsamiIscrSbfKey@1b8896f].  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
>
>


Mime
View raw message