Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

ON UPDATE RESTRICT in cascade?

 
nimo frey
Ranch Hand
Posts: 580
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is this SQL:



the same as this:


(How can I do the update restrict? Is this implicitly set with this annotation?

 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It looks the same, but it isn't. The big difference is where your database supports on update restrict and on delete cascade (not all do) this will happen all the time, regardless of which application connects to the database to manipulate the date. In the case of an ORM offering this behaviour it will happen only when that specific application manipulates the data.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic