78442

Turn off referential integrity in Derby? is it possible?

Is there a setting in derby, for example an sql query ala "SET DATABASE REFERENTIAL INTEGRITY FALSE" where i can turn on and off referential integrity?

Answer1:

According to this post on the mailing list (from 2006) it is not possible:

http://www.mail-archive.com/derby-user@db.apache.org/msg05345.html

I couldn't find anything in the manual either.

And the list of jdbc parameters has nothing, too.

Answer2:

If you have a constraint that you don't wish to enforce, you can use DROP CONSTRAINT to drop it.

I frequently drop a constraint for a period of time while I am re-structuring my database, then re-add the constraint subsequently when I have the new data arranged as I want it.

Recommend

  • C# why shall I use “new” keyword when subscribing for an event?
  • multiple edmx in the same .net solution
  • How to view navigation with infinit sub entries?
  • git include compiled dll from another repository
  • Explain EMV MDK Keys Enc MAC AC
  • Where are the start/stop hadoop hdfs/mapred scripts on CDH5
  • OpenCV: wrap image to cylindrical coordinates
  • Python/C++/Java: Is there a library that will recognize characters and tell me where they are in an
  • Conditional Foreign Key to multiple tables
  • Locking tables in Access 2010
  • Is it good to have multiple database running in a same project?
  • Condor job using DAG with some jobs needing to run the same host
  • C++ Boost ptr_map serialization error
  • Team Foundation Server 2015 vs. Bitbucket Server (Stash)
  • Fat binaries in iOS
  • Open Existing DB in MySQL WorkBench
  • How can I extract results of aggregate queries in slick?
  • Needing to do .toArray() to get output of mongodb .find() on key name not value
  • Get data from AJAX - How to
  • MongoDB in PHP using aggregate to group by _id is null not working
  • does jqgrid support a multiple checkbox list for editing
  • Optimizing database types to compact database (SQLite)
  • Cross-Platform Protobuf Serialization
  • Do I've to free mysql result after storing it?
  • Warning: Can't call setState (or forceUpdate) on an unmounted component
  • bootstrap to use multiple ng-app
  • How to get icons for entities from eclipse?
  • AngularJs get employee from factory
  • Free memory of cv::Mat loaded using FileStorage API
  • How do I configure my settings file to work with unit tests?
  • Memory offsets in inline assembly
  • Authorize attributes not working in MVC 4
  • Add sale price programmatically to product variations
  • JaxB to read class hierarchy
  • Busy indicator not showing up in wpf window [duplicate]
  • Unable to use reactive element in my shiny app
  • Python/Django TangoWithDjango Models and Databases
  • Net Present Value in Excel for Grouped Recurring CF
  • jQuery Masonry / Isotope and fluid images: Momentary overlap on window resize
  • How do I use LINQ to get all the Items that have a particular SubItem?