You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by v....@amm.unibs.it on 2007/03/07 17:13:51 UTC
In: abator problem
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
RE: RE: abator problem
Posted by "Armeanu, Christian" <Ar...@hsd.k12.or.us>.
Well, that leads to a similar conclusion: Verify that the naming
conventions for your production environment RDBMS are the same as for
dev. Tripple check that the production environment is using the correct
versions of packages and, obviously, that all needed packages are in the
classpath.
More likely than not, one of the above will be it.
Chris
________________________________
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" <Ar...@hsd.k12.or.us>
07/03/2007 17.24
Per favore, rispondere a
user-java@ibatis.apache.org
Per
<us...@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(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
Rif: Re: Rif: RE: abator problem
Posted by v....@amm.unibs.it.
this is the abator sqlmap
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-2.dtd" >
<sqlMap namespace="SIDA_ESAMI_ISCR_SBF" >
<resultMap id="abatorgenerated_EsamiIscrSbfResult"
class="ica2.ibatis.model.sida.EsamiIscrSbf" >
<!--
WARNING - This element is automatically generated by Abator for
iBATIS, do not modify.
This element was generated on Mon Feb 19 17:48:37 CET 2007.
-->
<result column="ESBF_CODESA" property="esbfCodesa" jdbcType="DECIMAL"
/>
<result column="ESBF_FIRANNOACC" property="esbfFirannoacc"
jdbcType="DECIMAL" />
<result column="ESBF_MATRICOLA" property="esbfMatricola"
jdbcType="DECIMAL" />
<result column="ESBF_SEMESTRE" property="esbfSemestre"
jdbcType="VARCHAR" />
<result column="ESBF_TIPO_CARICAMENTO" property="esbfTipoCaricamento"
jdbcType="VARCHAR" />
<result column="ESBF_TIPOES" property="esbfTipoes" jdbcType="VARCHAR"
/>
<result column="ESBF_DURATA" property="esbfDurata" jdbcType="VARCHAR"
/>
<result column="ESBF_ANNOCOR" property="esbfAnnocor"
jdbcType="DECIMAL" />
<result column="ESBF_CODNAZ" property="esbfCodnaz" jdbcType="DECIMAL"
/>
<result column="ESBF_CODFAC" property="esbfCodfac" jdbcType="DECIMAL"
/>
<result column="ESBF_CODCOR" property="esbfCodcor" jdbcType="DECIMAL"
/>
<result column="ESBF_CODORD" property="esbfCodord" jdbcType="DECIMAL"
/>
<result column="ESBF_DESCR_SCLIBERA" property="esbfDescrSclibera"
jdbcType="VARCHAR" />
<result column="ESBF_SPOSTABILE" property="esbfSpostabile"
jdbcType="CHAR" />
<result column="ESBF_DATASP" property="esbfDatasp" jdbcType="DATE" />
<result column="ESBF_USERSP" property="esbfUsersp" jdbcType="VARCHAR"
/>
<result column="ESBF_CRUSCOTTO" property="esbfCruscotto"
jdbcType="CHAR" />
<result column="ESBF_CONFERMATO" property="esbfConfermato"
jdbcType="CHAR" />
<result column="ESBF_DATA_CONF" property="esbfDataConf"
jdbcType="DATE" />
<result column="ESBF_AUTOCERTIFICATO" property="esbfAutocertificato"
jdbcType="CHAR" />
<result column="ESBF_PROGR_INS" property="esbfProgrIns"
jdbcType="DECIMAL" />
<result column="ESBF_TIPO_INSCURR" property="esbfTipoInscurr"
jdbcType="VARCHAR" />
<result column="ESBF_ISCRIZIONE" property="esbfIscrizione"
jdbcType="VARCHAR" />
<result column="ESBF_COPIATOCARR" property="esbfCopiatocarr"
jdbcType="CHAR" />
<result column="ESBF_EXTRACURR" property="esbfExtracurr"
jdbcType="CHAR" />
<result column="ESBF_NOTE" property="esbfNote" jdbcType="VARCHAR" />
<result column="ESBF_SLEX_CODMOT" property="esbfSlexCodmot"
jdbcType="DECIMAL" />
</resultMap>
<sql id="SIDA_ESAMI_ISCR_SBF.abatorgenerated_Example_Where_Clause" >
<!--
WARNING - This element is automatically generated by Abator for
iBATIS, do not modify.
This element was generated on Mon Feb 19 17:48:37 CET 2007.
-->
<iterate property="oredCriteria" conjunction="or" prepend="where"
removeFirstPrepend="iterate" >
(
<iterate prepend="and"
property="oredCriteria[].criteriaWithoutValue" conjunction="and" >
$oredCriteria[].criteriaWithoutValue[]$
</iterate>
<iterate prepend="and"
property="oredCriteria[].criteriaWithSingleValue" conjunction="and" >
$oredCriteria[].criteriaWithSingleValue[].condition$
#oredCriteria[].criteriaWithSingleValue[].value#
</iterate>
<iterate prepend="and"
property="oredCriteria[].criteriaWithListValue" conjunction="and" >
$oredCriteria[].criteriaWithListValue[].condition$
<iterate property="oredCriteria[].criteriaWithListValue[].values"
open="(" close=")" conjunction="," >
#oredCriteria[].criteriaWithListValue[].values[]#
</iterate>
</iterate>
<iterate prepend="and"
property="oredCriteria[].criteriaWithBetweenValue" conjunction="and" >
$oredCriteria[].criteriaWithBetweenValue[].condition$
#oredCriteria[].criteriaWithBetweenValue[].values[0]# and
#oredCriteria[].criteriaWithBetweenValue[].values[1]#
</iterate>
)
</iterate>
</sql>
<select id="abatorgenerated_selectByPrimaryKey"
resultMap="abatorgenerated_EsamiIscrSbfResult"
parameterClass="ica2.ibatis.model.sida.EsamiIscrSbfKey" >
<!--
WARNING - This element is automatically generated by Abator for
iBATIS, do not modify.
This element was generated on Mon Feb 19 17:48:37 CET 2007.
-->
select ESBF_CODESA, ESBF_FIRANNOACC, ESBF_MATRICOLA, ESBF_SEMESTRE,
ESBF_TIPO_CARICAMENTO,
ESBF_TIPOES, ESBF_DURATA, ESBF_ANNOCOR, ESBF_CODNAZ, ESBF_CODFAC,
ESBF_CODCOR, ESBF_CODORD,
ESBF_DESCR_SCLIBERA, ESBF_SPOSTABILE, ESBF_DATASP, ESBF_USERSP,
ESBF_CRUSCOTTO,
ESBF_CONFERMATO, ESBF_DATA_CONF, ESBF_AUTOCERTIFICATO,
ESBF_PROGR_INS, ESBF_TIPO_INSCURR,
ESBF_ISCRIZIONE, ESBF_COPIATOCARR, ESBF_EXTRACURR, ESBF_NOTE,
ESBF_SLEX_CODMOT
from SIDA.ESAMI_ISCR_SBF
where ESBF_CODESA = #esbfCodesa:DECIMAL#
and ESBF_FIRANNOACC = #esbfFirannoacc:DECIMAL#
and ESBF_MATRICOLA = #esbfMatricola:DECIMAL#
</select>
<select id="abatorgenerated_selectByExample"
resultMap="abatorgenerated_EsamiIscrSbfResult"
parameterClass="ica2.ibatis.model.sida.EsamiIscrSbfExample" >
<!--
WARNING - This element is automatically generated by Abator for
iBATIS, do not modify.
This element was generated on Mon Feb 19 17:48:37 CET 2007.
-->
select ESBF_CODESA, ESBF_FIRANNOACC, ESBF_MATRICOLA, ESBF_SEMESTRE,
ESBF_TIPO_CARICAMENTO,
ESBF_TIPOES, ESBF_DURATA, ESBF_ANNOCOR, ESBF_CODNAZ, ESBF_CODFAC,
ESBF_CODCOR, ESBF_CODORD,
ESBF_DESCR_SCLIBERA, ESBF_SPOSTABILE, ESBF_DATASP, ESBF_USERSP,
ESBF_CRUSCOTTO,
ESBF_CONFERMATO, ESBF_DATA_CONF, ESBF_AUTOCERTIFICATO,
ESBF_PROGR_INS, ESBF_TIPO_INSCURR,
ESBF_ISCRIZIONE, ESBF_COPIATOCARR, ESBF_EXTRACURR, ESBF_NOTE,
ESBF_SLEX_CODMOT
from SIDA.ESAMI_ISCR_SBF
<isParameterPresent >
<include
refid="SIDA_ESAMI_ISCR_SBF.abatorgenerated_Example_Where_Clause" />
<isNotNull property="orderByClause" >
order by $orderByClause$
</isNotNull>
</isParameterPresent>
</select>
<delete id="abatorgenerated_deleteByPrimaryKey"
parameterClass="ica2.ibatis.model.sida.EsamiIscrSbfKey" >
<!--
WARNING - This element is automatically generated by Abator for
iBATIS, do not modify.
This element was generated on Mon Feb 19 17:48:37 CET 2007.
-->
delete from SIDA.ESAMI_ISCR_SBF
where ESBF_CODESA = #esbfCodesa:DECIMAL#
and ESBF_FIRANNOACC = #esbfFirannoacc:DECIMAL#
and ESBF_MATRICOLA = #esbfMatricola:DECIMAL#
</delete>
<delete id="abatorgenerated_deleteByExample"
parameterClass="ica2.ibatis.model.sida.EsamiIscrSbfExample" >
<!--
WARNING - This element is automatically generated by Abator for
iBATIS, do not modify.
This element was generated on Mon Feb 19 17:48:37 CET 2007.
-->
delete from SIDA.ESAMI_ISCR_SBF
<include
refid="SIDA_ESAMI_ISCR_SBF.abatorgenerated_Example_Where_Clause" />
</delete>
<insert id="abatorgenerated_insert"
parameterClass="ica2.ibatis.model.sida.EsamiIscrSbf" >
<!--
WARNING - This element is automatically generated by Abator for
iBATIS, do not modify.
This element was generated on Mon Feb 19 17:48:37 CET 2007.
-->
insert into SIDA.ESAMI_ISCR_SBF (ESBF_CODESA, ESBF_FIRANNOACC,
ESBF_MATRICOLA, ESBF_SEMESTRE,
ESBF_TIPO_CARICAMENTO, ESBF_TIPOES, ESBF_DURATA, ESBF_ANNOCOR,
ESBF_CODNAZ, ESBF_CODFAC,
ESBF_CODCOR, ESBF_CODORD, ESBF_DESCR_SCLIBERA, ESBF_SPOSTABILE,
ESBF_DATASP, ESBF_USERSP,
ESBF_CRUSCOTTO, ESBF_CONFERMATO, ESBF_DATA_CONF,
ESBF_AUTOCERTIFICATO, ESBF_PROGR_INS,
ESBF_TIPO_INSCURR, ESBF_ISCRIZIONE, ESBF_COPIATOCARR,
ESBF_EXTRACURR, ESBF_NOTE,
ESBF_SLEX_CODMOT)
values (#esbfCodesa:DECIMAL#, #esbfFirannoacc:DECIMAL#,
#esbfMatricola:DECIMAL#,
#esbfSemestre:VARCHAR#, #esbfTipoCaricamento:VARCHAR#,
#esbfTipoes:VARCHAR#,
#esbfDurata:VARCHAR#, #esbfAnnocor:DECIMAL#, #esbfCodnaz:DECIMAL#,
#esbfCodfac:DECIMAL#,
#esbfCodcor:DECIMAL#, #esbfCodord:DECIMAL#,
#esbfDescrSclibera:VARCHAR#,
#esbfSpostabile:CHAR#, #esbfDatasp:DATE#, #esbfUsersp:VARCHAR#,
#esbfCruscotto:CHAR#,
#esbfConfermato:CHAR#, #esbfDataConf:DATE#,
#esbfAutocertificato:CHAR#,
#esbfProgrIns:DECIMAL#, #esbfTipoInscurr:VARCHAR#,
#esbfIscrizione:VARCHAR#,
#esbfCopiatocarr:CHAR#, #esbfExtracurr:CHAR#, #esbfNote:VARCHAR#,
#esbfSlexCodmot:DECIMAL#)
</insert>
<update id="abatorgenerated_updateByPrimaryKey"
parameterClass="ica2.ibatis.model.sida.EsamiIscrSbf" >
<!--
WARNING - This element is automatically generated by Abator for
iBATIS, do not modify.
This element was generated on Mon Feb 19 17:48:37 CET 2007.
-->
update SIDA.ESAMI_ISCR_SBF
set ESBF_SEMESTRE = #esbfSemestre:VARCHAR#,
ESBF_TIPO_CARICAMENTO = #esbfTipoCaricamento:VARCHAR#,
ESBF_TIPOES = #esbfTipoes:VARCHAR#,
ESBF_DURATA = #esbfDurata:VARCHAR#,
ESBF_ANNOCOR = #esbfAnnocor:DECIMAL#,
ESBF_CODNAZ = #esbfCodnaz:DECIMAL#,
ESBF_CODFAC = #esbfCodfac:DECIMAL#,
ESBF_CODCOR = #esbfCodcor:DECIMAL#,
ESBF_CODORD = #esbfCodord:DECIMAL#,
ESBF_DESCR_SCLIBERA = #esbfDescrSclibera:VARCHAR#,
ESBF_SPOSTABILE = #esbfSpostabile:CHAR#,
ESBF_DATASP = #esbfDatasp:DATE#,
ESBF_USERSP = #esbfUsersp:VARCHAR#,
ESBF_CRUSCOTTO = #esbfCruscotto:CHAR#,
ESBF_CONFERMATO = #esbfConfermato:CHAR#,
ESBF_DATA_CONF = #esbfDataConf:DATE#,
ESBF_AUTOCERTIFICATO = #esbfAutocertificato:CHAR#,
ESBF_PROGR_INS = #esbfProgrIns:DECIMAL#,
ESBF_TIPO_INSCURR = #esbfTipoInscurr:VARCHAR#,
ESBF_ISCRIZIONE = #esbfIscrizione:VARCHAR#,
ESBF_COPIATOCARR = #esbfCopiatocarr:CHAR#,
ESBF_EXTRACURR = #esbfExtracurr:CHAR#,
ESBF_NOTE = #esbfNote:VARCHAR#,
ESBF_SLEX_CODMOT = #esbfSlexCodmot:DECIMAL#
where ESBF_CODESA = #esbfCodesa:DECIMAL#
and ESBF_FIRANNOACC = #esbfFirannoacc:DECIMAL#
and ESBF_MATRICOLA = #esbfMatricola:DECIMAL#
</update>
<update id="abatorgenerated_updateByPrimaryKeySelective"
parameterClass="ica2.ibatis.model.sida.EsamiIscrSbf" >
<!--
WARNING - This element is automatically generated by Abator for
iBATIS, do not modify.
This element was generated on Mon Feb 19 17:48:37 CET 2007.
-->
update SIDA.ESAMI_ISCR_SBF
<dynamic prepend="set" >
<isNotNull prepend="," property="esbfSemestre" >
ESBF_SEMESTRE = #esbfSemestre:VARCHAR#
</isNotNull>
<isNotNull prepend="," property="esbfTipoCaricamento" >
ESBF_TIPO_CARICAMENTO = #esbfTipoCaricamento:VARCHAR#
</isNotNull>
<isNotNull prepend="," property="esbfTipoes" >
ESBF_TIPOES = #esbfTipoes:VARCHAR#
</isNotNull>
<isNotNull prepend="," property="esbfDurata" >
ESBF_DURATA = #esbfDurata:VARCHAR#
</isNotNull>
<isNotNull prepend="," property="esbfAnnocor" >
ESBF_ANNOCOR = #esbfAnnocor:DECIMAL#
</isNotNull>
<isNotNull prepend="," property="esbfCodnaz" >
ESBF_CODNAZ = #esbfCodnaz:DECIMAL#
</isNotNull>
<isNotNull prepend="," property="esbfCodfac" >
ESBF_CODFAC = #esbfCodfac:DECIMAL#
</isNotNull>
<isNotNull prepend="," property="esbfCodcor" >
ESBF_CODCOR = #esbfCodcor:DECIMAL#
</isNotNull>
<isNotNull prepend="," property="esbfCodord" >
ESBF_CODORD = #esbfCodord:DECIMAL#
</isNotNull>
<isNotNull prepend="," property="esbfDescrSclibera" >
ESBF_DESCR_SCLIBERA = #esbfDescrSclibera:VARCHAR#
</isNotNull>
<isNotNull prepend="," property="esbfSpostabile" >
ESBF_SPOSTABILE = #esbfSpostabile:CHAR#
</isNotNull>
<isNotNull prepend="," property="esbfDatasp" >
ESBF_DATASP = #esbfDatasp:DATE#
</isNotNull>
<isNotNull prepend="," property="esbfUsersp" >
ESBF_USERSP = #esbfUsersp:VARCHAR#
</isNotNull>
<isNotNull prepend="," property="esbfCruscotto" >
ESBF_CRUSCOTTO = #esbfCruscotto:CHAR#
</isNotNull>
<isNotNull prepend="," property="esbfConfermato" >
ESBF_CONFERMATO = #esbfConfermato:CHAR#
</isNotNull>
<isNotNull prepend="," property="esbfDataConf" >
ESBF_DATA_CONF = #esbfDataConf:DATE#
</isNotNull>
<isNotNull prepend="," property="esbfAutocertificato" >
ESBF_AUTOCERTIFICATO = #esbfAutocertificato:CHAR#
</isNotNull>
<isNotNull prepend="," property="esbfProgrIns" >
ESBF_PROGR_INS = #esbfProgrIns:DECIMAL#
</isNotNull>
<isNotNull prepend="," property="esbfTipoInscurr" >
ESBF_TIPO_INSCURR = #esbfTipoInscurr:VARCHAR#
</isNotNull>
<isNotNull prepend="," property="esbfIscrizione" >
ESBF_ISCRIZIONE = #esbfIscrizione:VARCHAR#
</isNotNull>
<isNotNull prepend="," property="esbfCopiatocarr" >
ESBF_COPIATOCARR = #esbfCopiatocarr:CHAR#
</isNotNull>
<isNotNull prepend="," property="esbfExtracurr" >
ESBF_EXTRACURR = #esbfExtracurr:CHAR#
</isNotNull>
<isNotNull prepend="," property="esbfNote" >
ESBF_NOTE = #esbfNote:VARCHAR#
</isNotNull>
<isNotNull prepend="," property="esbfSlexCodmot" >
ESBF_SLEX_CODMOT = #esbfSlexCodmot:DECIMAL#
</isNotNull>
</dynamic>
where ESBF_CODESA = #esbfCodesa#
and ESBF_FIRANNOACC = #esbfFirannoacc#
and ESBF_MATRICOLA = #esbfMatricola#
</update>
</sqlMap>
ayan.m.afridi@jpmchase.com
07/03/2007 17.30
Per favore, rispondere a
user-java@ibatis.apache.org
Per
user-java@ibatis.apache.org
CC
Oggetto
Re: Rif: RE: abator problem
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" <Ar...@hsd.k12.or.us>
07/03/2007 17.24
Per favore, rispondere a
user-java@ibatis.apache.org
Per
<us...@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.
Re: Rif: RE: abator problem
Posted by ay...@jpmchase.com.
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" <Ar...@hsd.k12.or.us>
07/03/2007 17.24
Per favore, rispondere a
user-java@ibatis.apache.org
Per
<us...@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.
Rif: RE: abator problem
Posted by v....@amm.unibs.it.
the problem is:
in jdeveloper (in embedded oc4j) run well
in production enviroment throw exception
"Armeanu, Christian" <Ar...@hsd.k12.or.us>
07/03/2007 17.24
Per favore, rispondere a
user-java@ibatis.apache.org
Per
<us...@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
RE: abator problem
Posted by "Armeanu, Christian" <Ar...@hsd.k12.or.us>.
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