Newbie OJB Problem

[Chuck Grohowski]

Hi,
I recently set up OJB to work with a MySQL database and am having a problem storing an 
UserRoles object I created.  Here are snippets from the repository_user.xml and other 
important files.

repository_user.xml:

 <class-descriptor 
     class="ojb.Users"
     table="users"
   >
 <field-descriptor
    name="id"
    column="id"
    jdbc-type="INTEGER"
    nullable="false"
    primarykey="true"
    autoincrement="true"
    
 />
 <field-descriptor
    name="logon"
    column="logon"
    jdbc-type="VARCHAR"
    
 />

... more here, cut for brevity 

    <collection-descriptor
       name="userRoles"
       element-class-ref="edu.rutgers.rsa.ojb.UserRoles"
       auto-retrieve="true"
    >
       <inverse-foreignkey field-ref="userId"/>
       
 </collection-descriptor>
</class-descriptor>

   <class-descriptor 
     class="ojb.UserRoles"
     table="user_roles"
   >
 <field-descriptor
    name="userId"
    column="user_id"
    jdbc-type="INTEGER"
    primarykey="true"
    
 />

 <field-descriptor
    name="roleName"
    column="role_name"
    jdbc-type="VARCHAR"
    primarykey="true"
    
 />

 <field-descriptor
    name="logon"
    column="logon"
    jdbc-type="VARCHAR"
    
 />
    <reference-descriptor
       name="users"
       class-ref="edu.rutgers.rsa.ojb.Users"
       auto-retrieve="true"
       auto-delete="false"
       auto-update="false"
    >
       <foreignkey field-ref="userId"/>
 </reference-descriptor>

   </class-descriptor>

Classes: 
UserRoles.java
public class UserRoles { 
        
        private Integer userId;
        public void setUserId( Integer userId ) { this.userId = userId; }
        public Integer getUserId() { return userId; }
        
        private String logon;
        public void setLogon( String logon ) { this.logon = logon; }
        public String getLogon() {  return logon; }

        private String roleName;
        public void setRoleName( String roleName ) { this.roleName = roleName; }
        public String getRoleName() {  return roleName; }

        private Users users;
        public void setUsers( Users users ) { this.users = users; }
        public Users getUsers() { return users; }
} 


Users.java

public class Users { 

        private Integer id;
        public void setId( Integer id ) { this.id = id; }
        public Integer getId() {  return id; }

        private String logon;
        public void setLogon( String logon ) { this.logon = logon; }
        public String getLogon() {  return logon; }

        private Vector userRoles;
        public void setUserRoles( Vector userRoles ) { this.userRoles = userRoles; }
        public Vector getUserRoles() { return userRoles; }

// cut for brevity as well        
        
}

1st question: When I store a User object which has a Vector of User Roles should these 
UserRole objects be persisted automagically? (they're not currently and I have to 
store all the objects related to a user separately).  If this is possible, how is it 
accomplished?  

2nd question: Am I mapping this relationship correctly? (It's a 1:n relationship 
Users:UserRoles )

Now the real problem, when i go to store a UserRoles object, I get the following debug 
code: 

[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG: SQL: SELECT 
role_name,logon FROM user_roles WHERE logon = ?  AND role_name = ? 

[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG: SQL: INSERT 
INTO user_roles (logon,role_name) VALUES ( ?, ? )

Why is this totally ignoring my user_id field even though it's specified as a primary 
key?

Any help is appreciated as I am wearing a hole in my desk from banging my head on it.  

Thanks for any and all help ( I thought I mapped things correctly according to the 
tutorials ),

Chuck Grohowski