Hi All
I am inserting data to a table which has a trigger associated with it. The trigger inserts some data to a audit trail table.
i am using the merge method to save my transient object.
But the id (primary key) that i receive after save is not from the table to which i am inserting but it is the id (primary key) of the audit trail table which is inserted by the trigger.

Do anybody know why this is hapenning like this? how can i resolve this issue?

Thanks in advance.
Naveen

Is the ID you get 1 below the actual row ID?

E.g. You create a new entry (via NHibernate), your object/ID is 5, but in the table its 6?

If so, then its probably down to an Insert fired trigger, which calls the sequence. Usually typical of Oracle.

If so, the solution is here:
http://jira.nhibernate.org/browse/NH-1176
but it's not been rolled into the main code base, even though its ready and waiting, it's been nearly 2 years.

Is the ID you get 1 below the actual row ID?

E.g. You create a new entry (via NHibernate), your object/ID is 5, but in the table its 6?

If so, then its probably down to an Insert fired trigger, which calls the sequence. Usually typical of Oracle.

If so, the solution is here:
http://jira.nhibernate.org/browse/NH-1176
but it's not been rolled into the main code base, even though its ready and waiting, it's been nearly 2 years.

Actually i am using ms sql server 2005.

Following is how my code looks like.
Testobject object = objectDAO.merge(transientInstance);

This line saves data to table1 which has a trigger inserting data to audit trail table table2.

When i do
System.out.println(object.getID())

I do not see the id from table 1 but instead i see id of table2.
Hope this gives more information of the problem i am facing.

Thanks in advance
Naveen

http://forum.hibernate.org/viewtopic.php?t=973262