Hmmm, Are you sure the column name starts with a lowercase P ?
Your annotation starts with an uppercase ParentReplica_id_001 but your sample data references lowercase parentReplica_id_001 shendel18 wrote: > > Hello im new to appfuse 2.X and configuring a one to may relationship. I > have created successfully the new two objects: > > replica object and replica_tables object > > The problem is when i put values on sample data to test if it will link my > replica_table to its parent replica object. I'm getting an empty value. > > replica_table > id description name > > parentReplica_001 > 1 replica_table test_001 desc 1 replica_table name 1 > > 2 replica_table test_001 desc 2 replica_table name 2 > > > > im expecting values in mysql like this one. > > replica_table > id description name > > parentReplica_001 > 1 replica_table test_001 desc 1 replica_table name 1 > > 2 > 2 replica_table test_001 desc 2 replica_table name 2 > > 2 > > > Below is my code.. > > ----------------------------- Replica > > @Entity @Table(name="replica") > public class Replica extends BaseObject { > private Long id; > private String name; > private String description; > > public Replica() {} > > @Id @GeneratedValue(strategy = GenerationType.AUTO) > public Long getId() { > return id; > } > > public void setId(Long id) { > this.id = id; > } > > @Column(name="name", length=50) > public String getName() { > return name; > } > > public void setName(String name) { > this.name = name; > } > > @Column(name="description", length=50) > public String getDescription() { > return description; > } > > public void setDescription(String description) { > this.description = description; > } > > @OneToMany (mappedBy="parentReplica_001") > private Set<ReplicaTables> replica_tables = new HashSet(); > > etc... > > ----------------------------- > > > ----------------------------- Replica table object > > @Entity @Table(name="replica_tables") > public class ReplicaTables extends BaseObject { > private Long id; > private String name; > private String description; > > public ReplicaTables() {} > > > @Column(name="name", length=50) > public String getName() { > return name; > } > > public void setName(String name) { > this.name = name; > } > > @Column(name="description", length=50) > public String getDescription() { > return description; > } > > public void setDescription(String description) { > this.description = description; > } > > @Id @GeneratedValue(strategy = GenerationType.AUTO) > public Long getId() { > return id; > } > > public void setId(Long id) { > this.id = id; > } > > @ManyToOne > @JoinColumn (name="ParentReplica_id_001", updatable = false, > insertable = false) > private Replica parentReplica_001; > > etc . . . > -------------------------------- > > ------------------------------- sample-data.xml > > <table name="replica"> > <column>id</column> > <column>name</column> > <column>description</column> > <row> > <value description="id">1</value> > <value description="name">replica name 1</value> > <value description="description">replica desc 1</value> > </row> > <row> > <value description="id">2</value> > <value description="name">replicate name 2</value> > <value description="description">replicate desc 2</value> > </row> > </table> > > <table name="replica_tables"> > <column>id</column> > <column>name</column> > <column>description</column> > <column>parentReplica_001</column> > <row> > <value description="id">1</value> > <value description="name">replica_table name 1</value> > <value description="description">replica_table test_001 desc > 1</value> > <value description="parentReplica_001">2</value> > </row> > <row> > <value description="id">2</value> > <value description="name">replicate_table2 name 2</value> > <value description="description">replicate_table2 desc 2</value> > <value description="parentReplica_001">2</value> > </row> > </table> > ---------------------------- > > Thanks in advance for the help. :) > -- View this message in context: http://www.nabble.com/one-to-many-mapping-problem..-tp25146746s2369p25147293.html Sent from the AppFuse - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@appfuse.dev.java.net For additional commands, e-mail: users-h...@appfuse.dev.java.net