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.