You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-user@db.apache.org by ABOU LINA <am...@gmail.com> on 2006/07/18 17:35:15 UTC
ERROR: Error while iterate ResultSet for query , Error setting field
Hi, i got this error using db-ojb-1.0.rc5.jar.
thx in advance.
in the mapping file :
--------
class ="stat.module.diffusion.donnees.BenefDirect"
table ="diff.BENEF"
>
<field-descriptor id="1"
name="code"
column="CODE"
jdbc-type="INTEGER"
primarykey="true"
/>
-----------------
in the table database we declared CODE as NUMBER(12) in oracle.
Message error :
-----------------------------------------------------
[PersistentField] ERROR: while set field:
object class[ stat.module.diffusion.donnees.BenefDirect
target field: code
target field type: class java.lang.Integer
object value class: java.lang.String
object value: 123]
null
*
java.lang.IllegalArgumentException
*
at sun.reflect.UnsafeObjectFieldAccessorImpl.set(*
UnsafeObjectFieldAccessorImpl.java:63*)
at java.lang.reflect.Field.set(*Field.java:656*)
at
org.apache.ojb.broker.metadata.fieldaccess.PersistentFieldDirectAccessImpl.doSet(Unknown
Source)
at org.apache.ojb.broker.metadata.fieldaccess.AbstractPersistentField.set(Unknown
Source)
at
org.apache.ojb.broker.accesslayer.RowReaderDefaultImpl.buildWithReflection(Unknown
Source)
at org.apache.ojb.broker.accesslayer.RowReaderDefaultImpl.readObjectFrom(Unknown
Source)
at org.apache.ojb.broker.accesslayer.RsIterator.getObjectFromResultSet(Unknown
Source)
at org.apache.ojb.broker.accesslayer.RsIterator.next(Unknown Source)
at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unknown
Source)
at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unknown
Source)
at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unknown
Source)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknown
Source)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(Unknown
Source)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(Unknown
Source)
at
framework.services.persistence.ojb.pb.PBPersistenceService.getCollectionByCondition
(*PBPersistenceService.java:218*)
at
framework.services.persistence.PersistenceService.getCollectionByCondition(*
PersistenceService.java:55*)
at stat.common.service.BaseService.searchByCondition(*BaseService.java:87*)
at stat.common.service.BaseService.searchByObjectWithOrder(*BaseService.java
:110*)
at stat.common.service.ServiceFactory.searchByObjectWithOrder(*
ServiceFactory.java:42*)
at stat.common.service.model.SimpleService.setList(*SimpleService.java:281*)
at stat.common.action.model.SaveSearchAction.doSave(*SaveSearchAction.java
:33*)
at stat.common.action.model.BaseSaveAction.doAction(*BaseSaveAction.java:30*
)
at stat.common.action.model.BaseAction.execute(*BaseAction.java:63*)
at org.apache.struts.action.RequestProcessor.processActionPerform(*
RequestProcessor.java:484*)
at org.apache.struts.action.RequestProcessor.process(*RequestProcessor.java
:274*)
at org.apache.struts.action.ActionServlet.process(*ActionServlet.java:1482*)
at org.apache.struts.action.ActionServlet.doPost(*ActionServlet.java:525*)
at javax.servlet.http.HttpServlet.service(*HttpServlet.java:709*)
at javax.servlet.http.HttpServlet.service(*HttpServlet.java:802*)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(*
ApplicationFilterChain.java:237*)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(*
ApplicationFilterChain.java:157*)
at org.apache.catalina.core.StandardWrapperValve.invoke(*
StandardWrapperValve.java:214*)
at org.apache.catalina.core.StandardValveContext.invokeNext(*
StandardValveContext.java:104*)
at org.apache.catalina.core.StandardPipeline.invoke(*StandardPipeline.java
:520*)
at org.apache.catalina.core.StandardContextValve.invokeInternal(*
StandardContextValve.java:198*)
at org.apache.catalina.core.StandardContextValve.invoke(*
StandardContextValve.java:152*)
at org.apache.catalina.core.StandardValveContext.invokeNext(*
StandardValveContext.java:104*)
at org.apache.catalina.core.StandardPipeline.invoke(*StandardPipeline.java
:520*)
at org.apache.catalina.core.StandardHostValve.invoke(*StandardHostValve.java
:137*)
at org.apache.catalina.core.StandardValveContext.invokeNext(*
StandardValveContext.java:104*)
at org.apache.catalina.valves.ErrorReportValve.invoke(*ErrorReportValve.java
:118*)
at org.apache.catalina.core.StandardValveContext.invokeNext(*
StandardValveContext.java:102*)
at org.apache.catalina.core.StandardPipeline.invoke(*StandardPipeline.java
:520*)
at org.apache.catalina.core.StandardEngineValve.invoke(*
StandardEngineValve.java:109*)
at org.apache.catalina.core.StandardValveContext.invokeNext(*
StandardValveContext.java:104*)
at org.apache.catalina.core.StandardPipeline.invoke(*StandardPipeline.java
:520*)
at org.apache.catalina.core.ContainerBase.invoke(*ContainerBase.java:929*)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(*CoyoteAdapter.java:160*)
at org.apache.coyote.http11.Http11Processor.process(*Http11Processor.java
:799*)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection
(*Http11Protocol.java:705*)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(*PoolTcpEndpoint.java
:577*)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(*
ThreadPool.java:683*)
at java.lang.Thread.run(*Thread.java:595*)
[org.apache.ojb.broker.accesslayer.RsIterator] ERROR: Error while iterate
ResultSet for query org.apache.ojb.broker.accesslayer.RsQueryObject[query:
Query from class stat.module.diffusion.donnees.BenefDirect where [], class
descriptor: stat.module.diffusion.donnees.BenefDirect]
Error setting field:code in object:stat.module.diffusion.donnees.BenefDirect
*
org.apache.ojb.broker.metadata.MetadataException*: Error setting field:code
in object:stat.module.diffusion.donnees.BenefDirect
at
org.apache.ojb.broker.metadata.fieldaccess.PersistentFieldDirectAccessImpl.doSet(Unknown
Source)
at org.apache.ojb.broker.metadata.fieldaccess.AbstractPersistentField.set(Unknown
Source)
at
org.apache.ojb.broker.accesslayer.RowReaderDefaultImpl.buildWithReflection(Unknown
Source)
at org.apache.ojb.broker.accesslayer.RowReaderDefaultImpl.readObjectFrom(Unknown
Source)
at org.apache.ojb.broker.accesslayer.RsIterator.getObjectFromResultSet(Unknown
Source)
at org.apache.ojb.broker.accesslayer.RsIterator.next(Unknown Source)
at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unknown
Source)
at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unknown
Source)
at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unknown
Source)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknown
Source)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(Unknown
Source)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(Unknown
Source)
at
framework.services.persistence.ojb.pb.PBPersistenceService.getCollectionByCondition
(*PBPersistenceService.java:218*)
at
framework.services.persistence.PersistenceService.getCollectionByCondition(*
PersistenceService.java:55*)
*at stat*.common.service.BaseService.searchByCondition(*BaseService.java:87*
)
*at stat*.common.service.BaseService.searchByObjectWithOrder(*
BaseService.java:110*)
at stat.common.service.ServiceFactory.searchByObjectWithOrder(*
ServiceFactory.java:42*)
at stat.common.service.model.SimpleService.setList(*SimpleService.java:281*)
at stat.common.action.model.SaveSearchAction.doSave(*SaveSearchAction.java
:33*)
at stat.common.action.model.BaseSaveAction.doAction(*BaseSaveAction.java:30*
)
at stat.common.action.model.BaseAction.execute(*BaseAction.java:63*)
at org.apache.struts.action.RequestProcessor.processActionPerform(*
RequestProcessor.java:484*)
at org.apache.struts.action.RequestProcessor.process(*RequestProcessor.java
:274*)
at org.apache.struts.action.ActionServlet.process(*ActionServlet.java:1482*)
at org.apache.struts.action.ActionServlet.doPost(*ActionServlet.java:525*)
at javax.servlet.http.HttpServlet.service(*HttpServlet.java:709*)
at javax.servlet.http.HttpServlet.service(*HttpServlet.java:802*)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(*
ApplicationFilterChain.java:237*)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(*
ApplicationFilterChain.java:157*)
at org.apache.catalina.core.StandardWrapperValve.invoke(*
StandardWrapperValve.java:214*)
at org.apache.catalina.core.StandardValveContext.invokeNext(*
StandardValveContext.java:104*)
at org.apache.catalina.core.StandardPipeline.invoke(*StandardPipeline.java
:520*)
at org.apache.catalina.core.StandardContextValve.invokeInternal(*
StandardContextValve.java:198*)
at org.apache.catalina.core.StandardContextValve.invoke(*
StandardContextValve.java:152*)
at org.apache.catalina.core.StandardValveContext.invokeNext(*
StandardValveContext.java:104*)
at org.apache.catalina.core.StandardPipeline.invoke(*StandardPipeline.java
:520*)
at org.apache.catalina.core.StandardHostValve.invoke(*StandardHostValve.java
:137*)
at org.apache.catalina.core.StandardValveContext.invokeNext(*
StandardValveContext.java:104*)
at org.apache.catalina.valves.ErrorReportValve.invoke(*ErrorReportValve.java
:118*)
at org.apache.catalina.core.StandardValveContext.invokeNext(*
StandardValveContext.java:102*)
at org.apache.catalina.core.StandardPipeline.invoke(*StandardPipeline.java
:520*)
at org.apache.catalina.core.StandardEngineValve.invoke(*
StandardEngineValve.java:109*)
at org.apache.catalina.core.StandardValveContext.invokeNext(*
StandardValveContext.java:104*)
at org.apache.catalina.core.StandardPipeline.invoke(*StandardPipeline.java
:520*)
at org.apache.catalina.core.ContainerBase.invoke(*ContainerBase.java:929*)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(*CoyoteAdapter.java:160*)
at org.apache.coyote.http11.Http11Processor.process(*Http11Processor.java
:799*)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection
(*Http11Protocol.java:705*)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(*PoolTcpEndpoint.java
:577*)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(*
ThreadPool.java:683*)
at java.lang.Thread.run(*Thread.java:595*)
Caused by: *java.lang.IllegalArgumentException
*
at sun.reflect.UnsafeObjectFieldAccessorImpl.set(*
UnsafeObjectFieldAccessorImpl.java:63*)
at java.lang.reflect.Field.set(*Field.java:656*)
... 51 more
Re: ERROR: Error while iterate ResultSet for query , Error setting field
Posted by Thomas Dudziak <to...@gmail.com>.
On 7/18/06, ABOU LINA <am...@gmail.com> wrote:
> Hi, i got this error using db-ojb-1.0.rc5.jar.
> thx in advance.
> [PersistentField] ERROR: while set field:
> object class[ stat.module.diffusion.donnees.BenefDirect
> target field: code
> target field type: class java.lang.Integer
> object value class: java.lang.String
> object value: 123]
This is the interesting part here: the JDBC driver apparently returned
a String ("123]"), not a numeric type. Please check that you don't use
a (N)VARCHAR2 there. You should also make sure that you use the latest
Oracle 10 driver (even if the DB is Oracle 8 or 9).
If that doesn't help, then you should define a field conversion for
this field where you convert between the string and integers.
HTH,
Tom
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org