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
