aspose file tools*
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 Spring in Action this week in the Spring 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
Author

Updating multiple tables while creating the application

Konda Golamaru
Ranch Hand

Joined: Dec 12, 2005
Posts: 36
Hi,

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

I have two tables with the columns given below.

Table-1: APPLICATIONS

Columns:

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_NUMBER etc..

Table-2: SUBMISSIONS

Columns

SUB_ID->PK
APP_ID->FK(Primary key of APPLICATIONS Table)
SUB_TITLE Etc..

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.

Thanks,
Konda Golamaru.
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17257
    
    6

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 www.hibernate.org for exact mapping details.

Good Luck

Mark


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.
 
wood burning stoves
 
subject: Updating multiple tables while creating the application