Relationship problem.

[David Warnock]

Hi,

I am having a problem with a simple relationship from N to 1 (ie a normal foreign key lookup to a parent table). I have tried looking at the OR guide on the website and at the broker unit tests but am very confused as I think I have copied the Artikle/ProductGroup example fully.

Thanks for your help.

My Unit Test error is:

Incorrect field reference "countryStateId" in org.apache.ojb.broker.metadata.ObjectReferenceDescriptor@1a28362[cascade delete=false,cascade retrieve=true,cascade store=false,is lazy=false,class of Items=class org.visres.contact.data.Country]
org.apache.ojb.broker.OJBRuntimeException: Incorrect field reference "countryStateId" in org.apache.ojb.broker.metadata.ObjectReferenceDescriptor@1a28362[cascade delete=false,cascade retrieve=true,cascade store=false,is lazy=false,class of Items=class org.visres.contact.data.Country]

It happens in this code

State sFind = null;
State sExample = new State();
sExample.setStateId( 1 );
Query query = new QueryByIdentity(sExample);
sFind = (State) broker.getObjectByQuery(query); // ERROR LINE

I have the following in my repository_user.xml (snipped extra fields)

<class-descriptor
class="org.visres.contact.data.Country"
table="Countries"
>
<field-descriptor
name="countryId"
column="CountryId"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
sequence-name="GEN_CountryId"
/>
<field-descriptor
name="name"
column="Name"
jdbc-type="VARCHAR"
/>
</class-descriptor>

<class-descriptor
class="org.visres.contact.data.State"
table="States"
proxy="dynamic"
>
<field-descriptor
name="stateId"
column="StateId"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
sequence-name="GEN_StateId"
/>
<field-descriptor
name="name"
column="Name"
jdbc-type="VARCHAR"
/>
<reference-descriptor
name="countryState"
class-ref="org.visres.contact.data.Country"
>
<foreignkey field-ref="countryStateId"/>
</reference-descriptor>
</class-descriptor>

And I have 2 classes (again extra fields snipped)

package org.visres.contact.data;

class Country implements java.io.Serializable {
private int countryId;
private String name;

public void setCountryId(int countryId) {
this.countryId = countryId;
}
public int getCountryId() {
return countryId;
}

public void setName(String s) {
name = s;
}
public String getName() {
return name;
}

}
===
package org.visres.contact.data;

class State implements java.io.Serializable {
private int stateId;
private String name;
private int countryStateId;
private Country countryState = null;

public void setStateId(int stateId) {
this.stateId = stateId;
}
public int getStateId() {
return stateId;
}

public void setName(String s) {
name = s;
}
public String getName() {
return name;
}

public void setCountryStateId(int countryStateId) {
this.countryStateId = countryStateId;
}
public int getCountryStateId() {
return countryStateId;
}

public void setCountryState(Country countryState) {
this.countryState = countryState;
}
public Country getCountryState() {
return countryState;
}
}

--
David Warnock, Sundayta Ltd. http://www.sundayta.com
iDocSys for Document Management. VisibleResults for Fundraising.
Development and Hosting of Web Applications and Sites.



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