org.apache.ojb.broker.OJBRuntimeException: Incorrect field reference

[Naveen Singh]

HI,
Thanks in advance.
I am getting this error while doing:

Criteria courseNmCrit = new Criteria();
            courseNmCrit.addEqualTo("unitNm", new Integer(1));
            QueryByCriteria crsQuery =
QueryFactory.newQuery(Units.class,courseNmCrit);
            Units unit =
(Units)newDbPersistenceBroker.getObjectByQuery(crsQuery);  //error comes
at this line

Here is the stack trace-

org.apache.ojb.broker.OJBRuntimeException: Incorrect field reference
"unitId " in
[EMAIL PROTECTED]
delete=false,cascade retrieve=true,cascade store=false,is
lazy=false,class of Items=class
edu.sc.asg.astronomy.persistence.ojb.StudentUnitDtl]
        at
org.apache.ojb.broker.metadata.ObjectReferenceDescriptor.getForeignKeyFi
eldDescriptors(Unknown Source)
        at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getFKQuery1toN(Unknown
Source)
        at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getFKQuery(Unknown
Source)
        at
org.apache.ojb.broker.core.PersistenceBrokerImpl.retrieveCollection(Unkn
own Source)
        at
org.apache.ojb.broker.core.PersistenceBrokerImpl.retrieveCollections(Unk
nown Source)
        at
org.apache.ojb.broker.accesslayer.RsIterator.getObjectFromResultSet(Unkn
own Source)
        at org.apache.ojb.broker.accesslayer.RsIterator.next(Unknown
Source)
        at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Un
known Source)
        
Caused by: java.util.NoSuchElementException: Could not obtain next
object: Incorrect field reference "unitId " in
[EMAIL PROTECTED]
delete=false,cascade retrieve=true,cascade store=false,is
lazy=false,class of Items=class
edu.sc.asg.astronomy.persistence.ojb.StudentUnitDtl]
        at org.apache.ojb.broker.accesslayer.RsIterator.next(Unknown
Source)
        at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Un
known Source)
        ... 43 more

Here is the part of Repository.xml

<class-descriptor 
  class="edu.sc.asg.astronomy.persistence.ojb.StudentUnitDtl"
  table="astronomy.dbo.student_unit_dtl">
  <field-descriptor 
     name="completedUnitFlg"
     column="completed_unit_flg"
     jdbc-type="CHAR"
  />
  <field-descriptor 
     name="statusDt"
     column="status_dt"
     jdbc-type="DATE"
  />
  <field-descriptor 
     name="studentId"
     column="student_id"
     jdbc-type="INTEGER"
  />
  <field-descriptor 
     name="studentUnitDtlId"
     column="student_unit_dtl_id"
     jdbc-type="INTEGER"
     primarykey="true"
     autoincrement="true"
  />
  <field-descriptor 
     name="studentUnitStatusId"
     column="student_unit_status_id"
     jdbc-type="INTEGER"
  />
  <field-descriptor 
     name="unitId"
     column="unit_id"
     jdbc-type="INTEGER"
  />
  <reference-descriptor
    name="aUnits"
    class-ref="edu.sc.asg.astronomy.persistence.ojb.Units"
    auto-retrieve="true"
    auto-update="false"
    auto-delete="false">
    <foreignkey field-ref="unitId" />
  </reference-descriptor>
</class-descriptor>

<class-descriptor 
  class="edu.sc.asg.astronomy.persistence.ojb.Units"
  table="astronomy.dbo.units">
  <field-descriptor 
     name="unitId"
     column="unit_id"
     jdbc-type="INTEGER"
     primarykey="true"
     autoincrement="true"
  />
  <field-descriptor 
     name="unitNm"
     column="unit_nm"
     jdbc-type="INTEGER"
  />
  <field-descriptor 
     name="unitTx"
     column="unit_tx"
     jdbc-type="VARCHAR"
  />
 <collection-descriptor
    name="collStudentUnitDtl"
 
element-class-ref="edu.sc.asg.astronomy.persistence.ojb.StudentUnitDtl"
    auto-retrieve="true"
    auto-update="false"
    auto-delete="false">
    <inverse-foreignkey field-ref="unitId "    />
  </collection-descriptor>
</class-descriptor>

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]