Revision: 4483
http://sourceforge.net/p/jump-pilot/code/4483
Author: jratike80
Date: 2015-06-08 11:50:50 +0000 (Mon, 08 Jun 2015)
Log Message:
-----------
After creating connection run PRAGMA foreign_keys=1; for respecting all
possible SQLite foreign key constraints (in java OFF by default).
Modified Paths:
--------------
plug-ins/SpatialitePlugin/trunk/src/org/jam/openjump/spatialiteplugin/SpatialiteDb.java
Modified:
plug-ins/SpatialitePlugin/trunk/src/org/jam/openjump/spatialiteplugin/SpatialiteDb.java
===================================================================
---
plug-ins/SpatialitePlugin/trunk/src/org/jam/openjump/spatialiteplugin/SpatialiteDb.java
2015-06-08 10:00:24 UTC (rev 4482)
+++
plug-ins/SpatialitePlugin/trunk/src/org/jam/openjump/spatialiteplugin/SpatialiteDb.java
2015-06-08 11:50:50 UTC (rev 4483)
@@ -226,9 +226,11 @@
stmt.setQueryTimeout(30); // set timeout to 30 sec.
// loading SpatiaLite
+ // and switching foreign keys ON
//stmt.execute("SELECT load_extension('libspatialite-1.dll')");
System.out.println("sql : " + loadExtension);
stmt.execute(loadExtension);
+ stmt.execute("PRAGMA foreign_keys=1");
System.out.println(loadExtension);
// enabling Spatial Metadata
// using v.2.4.0 this automatically initializes SPATIAL_REF_SYS
and GEOMETRY_COLUMNS
------------------------------------------------------------------------------
_______________________________________________
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
