Problem using anonymous keys

["Plummer, Greg" <Gr...@LibertyMutual.com>]

Hi All,

This is my second post regarding this problem. I was able to get the insert to work fine, but when I changed the test to use anonymous keys, I continue to get the following problem. Code and repository.xml are attached below. Any help would be appreciated.

Thanks,
Greg Plummer

assertValidPkFields failed for Object of type: ojbtests.Client on insert
org.apache.ojb.broker.PersistenceBrokerException: assertValidPkFields failed for Object of type: ojbtests.Client on insert
	at org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(PersistenceBrokerImpl.java:1942)
	at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImpl.java:1889)
	at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImpl.java:665)
	at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPersistenceBroker.java:160)
	at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPersistenceBroker.java:160)
	at ojbtests.OjbTest.createClient(OjbTest.java:39)
	at ojbtests.OjbTest.createClients(OjbTest.java:62)
	at ojbtests.OjbTest.testInsert(OjbTest.java:96)
	at java.lang.reflect.Method.invoke(Native Method)
	at junit.framework.TestCase.runTest(TestCase.java:154)
	at junit.framework.TestCase.runBare(TestCase.java:127)
	at junit.framework.TestResult$1.protect(TestResult.java:106)
	at junit.framework.TestResult.runProtected(TestResult.java:124)
	at junit.framework.TestResult.run(TestResult.java:109)
	at junit.framework.TestCase.run(TestCase.java:118)
	at junit.framework.TestSuite.runTest(TestSuite.java:208)
	at junit.framework.TestSuite.run(TestSuite.java:203)
	at junit.textui.TestRunner.doRun(TestRunner.java:116)
	at junit.textui.TestRunner.doRun(TestRunner.java:109)
	at junit.textui.TestRunner.run(TestRunner.java:72)
	at junit.textui.TestRunner.run(TestRunner.java:57)
	at ojbtests.OjbTest.main(OjbTest.java:77)


Domain Classes:

package ojbtests;

import java.util.ArrayList;
import java.util.Collection;
import java.util.Iterator;

public class Client {
	
	private String name;
	private int id;
	private Collection clientGroups = new ArrayList();

	public Client() {
		super();
	}

	public int getId() {
		return id;
	}

	public String getName() {
		return name;
	}

	public void setId(int id) {
		this.id = id;
	}

	public void setName(String name) {
		this.name = name;
	}
	
	public void addClientGroup(ClientGroup clientGroup) {
		clientGroups.add(clientGroup);
		clientGroup.setClient(this);
	}
	
	public Iterator getClientGroups() {
		return clientGroups.iterator();
	}
}

package ojbtests;

public class ClientGroup {
	
	private String name;
	private int id;
	private Client client;

	public ClientGroup() {
		super();
	}

	public Client getClient() {
		return client;
	}

	public int getId() {
		return id;
	}

	public String getName() {
		return name;
	}

	public void setClient(Client client) {
		this.client = client;
	}

	public void setId(int id) {
		this.id = id;
	}

	public void setName(String name) {
		this.name = name;
	}
}

DB Setup code:

	private void create(Connection conn) throws SQLException {

		Statement statement=conn.createStatement();
		try {
			statement.executeUpdate("DROP TABLE client_group");
			statement.executeUpdate("DROP TABLE client");
		} catch (SQLException e) {
			e.printStackTrace();
		}
		statement.execute("CREATE TABLE client(" +
			"id INTEGER PRIMARY KEY, " +
			"name VARCHAR(255))");
		statement.execute(
			"CREATE TABLE client_group(" +
				"id INTEGER PRIMARY KEY, "  +
				"name VARCHAR(255), " +
				"client_id INTEGER, " +
				"FOREIGN KEY (client_id) REFERENCES client(id))");
		statement.close();
	}

Repository.xml file:

   <class-descriptor
   	  class="ojbtests.Client"
   	  table="CLIENT"
   >
      <field-descriptor
         name="id"
         column="ID"
         jdbc-type="INTEGER"
         primarykey="true"
         autoincrement="false"
         access="anonymous"
      />
      <field-descriptor
         name="name"
         column="NAME"
         jdbc-type="VARCHAR"
      />
      <collection-descriptor
      	name="clientGroups"
      	element-class-ref="ojbtests.ClientGroup"
      >
      		<inverse-foreignkey field-ref="clientId" />
      </collection-descriptor>
   </class-descriptor>

   <class-descriptor
   	  class="ojbtests.ClientGroup"
   	  table="CLIENT_GROUP"
   >
      <field-descriptor
         name="id"
         column="ID"
         jdbc-type="INTEGER"
         primarykey="true"
         autoincrement="false"
      />
      <field-descriptor
         name="name"
         column="NAME"
         jdbc-type="VARCHAR"
      />
      <field-descriptor
         name="clientId"
         column="CLIENT_ID"
         jdbc-type="INTEGER"
         access="anonymous"
      />
   </class-descriptor>