Co-Authored-By: Claude Sonnet 5.5 <[email protected]> Claude-Session: https://claude.ai/code/session_017ic4b4H5ph3J7k2MJnRuVH
28 lines
1.3 KiB
Plaintext
28 lines
1.3 KiB
Plaintext
# One parent, two children, four mappings: tables and insert SQL
|
|
# Hibernate ORM 7.4.16.Final, H2, JDK 25
|
|
|
|
== A. Unidirectional, plain @OneToMany (no mappedBy, no @JoinColumn)
|
|
tables: [JTCHILD, JTLISTPARENT, JTLISTPARENT_JTCHILD]
|
|
-- persist(parent with 2 children); commit
|
|
sql> insert into JtListParent (id) values (default)
|
|
sql> insert into JtChild (name,id) values (?,default)
|
|
sql> insert into JtChild (name,id) values (?,default)
|
|
sql> insert into JtListParent_JtChild (JtListParent_id,children_id) values (?,?)
|
|
sql> insert into JtListParent_JtChild (JtListParent_id,children_id) values (?,?)
|
|
|
|
== B. Unidirectional with @JoinColumn(name = "parent_id")
|
|
tables: [JCCHILD, JCLISTPARENT]
|
|
-- persist(parent with 2 children); commit
|
|
sql> insert into JcListParent (id) values (default)
|
|
sql> insert into JcChild (name,id) values (?,default)
|
|
sql> insert into JcChild (name,id) values (?,default)
|
|
sql> update JcChild set parent_id=? where id=?
|
|
sql> update JcChild set parent_id=? where id=?
|
|
|
|
== C. Bidirectional, mappedBy, child owns the foreign key
|
|
tables: [DEPARTMENTS, EMPLOYEES]
|
|
-- persist(department with 2 employees); commit
|
|
sql> insert into departments (name,id) values (?,default)
|
|
sql> insert into employees (dept_id,name,uuid,id) values (?,?,?,default)
|
|
sql> insert into employees (dept_id,name,uuid,id) values (?,?,?,default)
|