Hibernate version:1.2.8

Database version:Oracle 10g

Dialect version:9i dialect

Is it possible to change the way inserts are made to tables so that whenever a insert is made to the table the insert should also contain the pimary key. However the primary keys are only set after the data has been inserted and by an Update. Please see description below.

I have three tables
Table A -- Table B -- Table C

Each table has a one to many relation ship. Table B references to A and Table C references to B.


Whenever i persist my object the Queries are executred are done in the following order.

for this example say each has one child.

Get Sequence For Table A
Get Sequence For Table B
Get Sequence For Table C
Insert NON PK Data Into Table A.
Insert NON PK Data Into Table B.
Insert NON PK Data Into Table C.
Update Table B with PK Information ( contains a column for Referencing Table A)
Update Table C with PK Information( contains a column for Referencing Table B)

i want this sql to look more like this.

Get Sequence For Table A
Get Sequence For Table B
Get Sequence For Table C
Insert ALL Data Into Table A.
Insert ALL Data Into Table B.
Insert ALL Data Into Table C.

Regards
Jai