5 Replies Latest reply on Apr 4, 2006 4:36 AM by Emmanuel Bernard

    history table (before insert / trigger?)

    Bernhard Neuhauser Newbie


      Given szenario:
      Each object update should store the original object inside a history table.

      Whats the best suitable technique for my szenario?

      db trigger
      Is it possible to tell hibernate to create the triggers? some kind of additional ddl which should be executed after the basic cmp table creation.

      Hibernate PreUpdateEventListener
      Is this a problem with the ejb3 sepc? Will work only with hibernate, so switching to products like toplink would be harder or?

      The App itself knows that there are different versions available. Would be possible to implement it with pure cmp offering db/appserver independence. But maybe worst performance and more redundant code.

      Any ideas?
      Bernhard Neuhauser