ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Armeanu, Christian" <Armea...@hsd.k12.or.us>
Subject RE: abator problem
Date Wed, 07 Mar 2007 16:24:15 GMT
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(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 [ica2.ibatis.model.sida.EsamiIscrSbfKey@1b8896f].
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


Mime
View raw message