ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ayan.m.afr...@jpmchase.com
Subject Re: Rif: RE: abator problem
Date Wed, 07 Mar 2007 16:30:05 GMT
Can you provide your sql map 
"SIDA_ESAMI_ISCR_SBF.abatorgenerated_updateByPrimaryKeySelective"?





v.viggiani@amm.unibs.it 
03/07/2007 11:27 AM
Please respond to
user-java@ibatis.apache.org


To
user-java@ibatis.apache.org
cc

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.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 
[ica2.ibatis.model.sida.EsamiIscrSbfKey@1b8896f].  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.

Mime
View raw message