trigger « Insert « JPA Q&A

1. Issue in Inserting / Updating the table with trigger using Hibernate    coderanch.com

net.sf.hibernate.dialect.SQLServerDialect java java jdbc:microsoft:sqlserver://192.168.0.124:3499;lastupdatecount=true;databaseName=NAMSDEV com.microsoft.jdbc.sqlserver.SQLServerDriver false true 10 true 1, false ...

2. INSERT trigger not firing!    forum.hibernate.org

Hello, I have made an insert trigger in my database which inserts some tables depending on an insert of a different table. The trigger is fired when using simple saveOrUpdate hibernate calls, but as soon as hibernate starts to include more than this single table which I am saving, the trigger is not fired anymore! If have tried with flush() and ...

3. Insert and Updates with a trigger    forum.hibernate.org

Hi! We have a problem inserting and updating 2 entities (in same transaction) when a trigger is attached on a table of one of those entities table. This is the scenario: entityADao.save(entA); //---> entity is on database and entA has that id. So it produce an update entityBDao.save(entB); //----> entity is not on database. So it produce an insert //Trigger on ...

4. Insert data, which fires trigger, but exception occurs    forum.hibernate.org

5. Problem inserting dependant object with trigger    forum.hibernate.org

Basically, I have a trigger declared as instead insert on my database to check some constraints. If this trigger is enabled, is like hibernate cannot set the autogenerated (identity column on sql server) into the address object to persist it. If i disabled the trigger, all works well. I'm using jTDS driver in case this makes a difference. Hibernate version:2.1.18 Mapping ...

6. priamry key value set by PRE_INSERT trigger in oracle DB    forum.hibernate.org

7. Insert triggers unneeded updates    forum.hibernate.org

I'm fairly new to Hibernate. I saved a new entity, lets say Foo, and I saw the SQL fly across my console with the corresponding insert statement. Cool.. Good... When the service call is finished, however, hibernate proceeds to update two other tables that are referenced as foreign keys in my Foo entity. I don't feel this is valid because I ...

8. problem with entitymanger and insert trigger    forum.hibernate.org

Hello all, i am having strange problem. i wrote a trigger on a table which will be fired when some one inserts data on to that table.when i insert a row manually on that table in the db the trigger is getting fired and executing successfully. so when i am trying to insert data from my application using entity manager.persist() ,i ...

9. Insert failing when there is EXEC in trigger    forum.hibernate.org

Inserting new entries into a MS SQL table using hibernate layer are failing if there is a trigger on insert on the table and if the trigger has "EXEC statement in it. Its inserting successfully if the EXEC statement is commented out or replaced with inline logic in the trigger. Also if inserted the same values manually, the inserts ...

10. Insert failing when there is EXEC in trigger    forum.hibernate.org

Inserting new entries into a MS SQL table using hibernate layer are failing if there is a trigger on insert on the table and if the trigger has "EXEC statement in it. Its inserting successfully if the EXEC statement is commented out or replaced with inline logic in the trigger. Also if inserted the same values manually, the inserts ...

11. Identity on inserts through SQL Server insteadof trigger    forum.hibernate.org

I'm trying to handle an issue we're having where all of our application's inserts or updates are first going through a MS SQL Server insteadof trigger which modifies the date_created and last_updated date fields. Since this application is deployed in a clustered environment we would like to use the date from the database in case any of the servers clocks get ...