[hibernate-issues] [Hibernate-JIRA] Created: (HHH-2002) Setting the Primary Key when using Oracle

Setting the Primary Key when using Oracle ----------------------------------------- Key: HHH-2002 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2002 Project: Hibernate3 Type: Bug Environment: Hibernate 3.0 on Oracle 10G Reporter: Garnet Miller Priority: Blocker The database is Oracle 10G, the primary keys are generated by firing a trigger which gets the next value from a sequence number generator and inserting this value into the primary key column. The problem is that when we insert a record to a parent and an associated record into the child table at the same time I'm not able to have hibernate insert into the parent table and then use this value in the foriegn key of the child table. A work around is to get the next value from the sequence generator manually using hibernate and then use this in the child tables foriegn key. However this requires the trigger to be changed to accept a value for the primary key if one is given and if one is not given to fire the trigger and populate the primary key. There are other applications using the database and this is not the preferred approach. Any ideas on how to solve this? -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira