Singh -- Check your inverse-foreignkey element. There is a trailing space in the 'field-ref' property. Take it out and things should work better.
Ron Gallagher Atlanta, GA [EMAIL PROTECTED] -----Original Message----- From: Naveen Singh [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 04, 2003 2:20 PM To: OJB Users List Subject: org.apache.ojb.broker.OJBRuntimeException: Incorrect field reference 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
