I have a Student table with an auto generated id as primary key and one to many mapping to Phone table.
My Phone table has a composite key PhonePK with phone number and the foreign key id to the Student table as primary keys.
If I do phonePk.setStudent it works but I really don't want to do this. How can I achieve this? If its not achievable, I would like to settle with setting the student id but not the whole student object. How do I do this? Would really appreciate if someone can give an insight on this.
The way I have the schema, I have id column in Phone table as both primary key and foreign key to Student table and its failing while trying to perform an insert. How can I get this to work? Below is from logs.
I able to generate the schema but when I try to insert, I am getting the error com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'id' cannot be null. My Phone table primary key is a composite key consisting of phoneNumber and foreign key id.