Discussions
Categories
- 385K All Categories
- 2.5K Data
- 568 Big Data Appliance
- 2K Data Science
- 452K Databases
- 222.3K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 32 Multilingual Engine
- 573 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 575 SQLcl
- 4K SQL Developer Data Modeler
- 187.7K SQL & PL/SQL
- 21.5K SQL Developer
- 10 Data Integration
- 10 GoldenGate
- 297.6K Development
- 3 Application Development
- 18 Developer Projects
- 140 Programming Languages
- 294.2K Development Tools
- 118 DevOps
- 3.1K QA/Testing
- 646.3K Java
- 30 Java Learning Subscription
- 37K Database Connectivity
- 185 Java Community Process
- 107 Java 25
- 22.1K Java APIs
- 138.3K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 21 Java Essentials
- 172 Java 8 Questions
- 86K Java Programming
- 82 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 206 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 573 LiveLabs
- 41 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 182 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 239 Portuguese
How to save data in Master-Detail tables with seq PKs in Java?
Hello Experts,
I'm building a Sales Order application.
And now i'm stuck in how to save the sales Order.
I know how to insert records in a single database table ... but now i want to save in both tables.
I want to insert a record in the master SalesOrder table and the items in the detail SalesOrderItems at the same time.
The Primary keys in both tables are assigned using a database sequence so i don't know how to handle the relation between them
There is no way to know the SalesOrder (Master)'s PK to assign as a FK in the SalesOrderItems (Detail) table at the time i'm saving the data.
Is this possible?
Thank you for your time
Gado
Answers
-
Hi, You have to insert into the master table first and get the generated sequence for master inserted value. Then, you can use the value of the master to insert in the detail table. If you use an ORM you only need to insert the master and the ORM do the rest. Here, some resources: Best regards
