HIbernate issue with Oracle Trigger for generating id from a sequence

by

Just update your trigger to only fire when not given an id.

create or replace
trigger sa.my_trigger
before insert on sa.my_table
for each row
when (new.id is null)
begin
   select sa.my_sequence.nextval
    into :new.id
    from dual;
end;

More Related Contents:

  1. hibernate oracle sequence produces large gap
  2. ORA-04091: table [blah] is mutating, trigger/function may not see it
  3. Oracle trigger after insert or delete
  4. No more data to read from socket error
  5. Auto-increment in Oracle without using a trigger
  6. Trigger to enforce M-M relationship
  7. Spring boot Hibernate error “Access to DialectResolutionInfo cannot be null when ‘hibernate.dialect’ not set” when working with multiple data sources
  8. Why is the GETDATE() an invalid identifier
  9. Oracle: difference between max(id)+1 and sequence.nextval
  10. Difference between LockModeType Jpa
  11. Printing the value of a variable in SQL Developer
  12. Spring 3 MVC: one-to-many within a dynamic form (add/remove on create/update)
  13. UTL_FILE.FOPEN() procedure not accepting path for directory?
  14. Oracle stored procedure with parameters for IN clause
  15. NLS_NUMERIC_CHARACTERS setting for decimal
  16. get next sequence value from database using hibernate
  17. What is the minimal setup required to deploy a .NET application with Oracle client 11?
  18. Best practice for pagination in Oracle?
  19. check if “it’s a number” function in Oracle
  20. Need to reset the value of sequence in Oracle
  21. ORA-12170: TNS:Connect timeout occurred
  22. Strange Jackson exception being thrown when serializing Hibernate object
  23. How to create and use temporary table in oracle stored procedure?
  24. Why cannot I use bind variables in DDL/SCL statements in dynamic SQL?
  25. error: ORA-65096: invalid common user or role name in Oracle database
  26. How to insert a column in a specific position in oracle without dropping and recreating the table?
  27. MySQL equivalent of ORACLES rank()
  28. Reading clob line by line with pl\sql
  29. Oracle: Days between two date and Exclude weekdays how to handle negative numbers
  30. How to generate a version 4 (random) UUID on Oracle?

Leave a Comment