File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Object Relational Mapping and the fly likes Updating multiple tables while creating the application Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Customer Requirements for Developers this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Updating multiple tables while creating the application" Watch "Updating multiple tables while creating the application" New topic

Updating multiple tables while creating the application

Konda Golamaru
Ranch Hand

Joined: Dec 12, 2005
Posts: 36

When I create an application, two tables have to be updated.

I have two tables with the columns given below.



AP_ID -> PK (I use the APP_SEQ to get the next sequence id)
INITIAL_SUB_ID ->(This will be the PK of SUBMISSIONS Table. When I create the APPLICATION, I use SUB_SEQ to get the next sequnce id and insert a record into both APPLICATIONS and SUBMISSIONS Table)



APP_ID->FK(Primary key of APPLICATIONS Table)

1. When I create the application, I will be updating both APPLICATIONS, SUBMISSIONS Table(Currently I have a view which updates both the tables.)
2. When I create the submission, I will be updating only submissions table as the submission can be created for any of the existing application.

Question: I am planning to replace JDBC with Hibernate. I would appreciate, If any body can help/throw a suggetion for creating mapping file in the above scenario.

Konda Golamaru.
Mark Spritzler

Joined: Feb 05, 2001
Posts: 17271

Not sure what the initial sub id in Application is for. If it is just which was the first Submission record added, then make that a OneToOne mapping. In regards to the Submission having Many records to One Application sounds like a OneToMany/ManyToOne relationship.

Check out the Hibernate documentation at for exact mapping details.

Good Luck


Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
Konda Golamaru
Ranch Hand

Joined: Dec 12, 2005
Posts: 36
Hi Mark,

Thanks for your reply.

I don't see the use of Initial Submisson Id being present in Applications table. Any way, The database was created 7 years ago and still we are using the same schema.

Coming back to the mapping, I think as you suggested, I need to more read on One to Many or Many to One mappings as The application can have multiple submissions/Multiple submissions can be created for a single application.

Thanks for your time.

Konda Golamaru.
It is sorta covered in the JavaRanch Style Guide.
subject: Updating multiple tables while creating the application
It's not a secret anymore!