Hi,
Spatialite and Geopackage are read-only for OpenJUMP so I only tried to add
data to project.
I took the 3.21.0 version of the driver and this is what I do and what happens:
Create a connection to Spatialite/Geopackage
opening:
[INFO] 2018-05-11_12:26:59.745 Suorittaa: Avaa...
[INFO] 2018-05-11_12:28:27.973 Target database URL :
jdbc:sqlite:C:\data\paivita\kielto.sqlite
[INFO] 2018-05-11_12:28:27.989 java.net.preferIPv4Stack=null
[INFO] 2018-05-11_12:28:27.989 java.net.preferIPv6Addresses=null
does not find Spatialite, that is correct and not an error:
[INFO] 2018-05-11_12:28:28.161 SpatialDatabasesPlugin: CANNOT load Spatialite
Extention (mod_spatialite), reason:[SQLITE_ERROR] SQL error or missing database
(Määritettyä osaa ei löydy.
)
select a table and add it into OJ:
[INFO] 2018-05-11_12:29:32.581 SQL query to get Spatial table features:
SELECT
geometry,ogc_fid,tunnus,kieltotunnus,aluetunnus,uomatunnus,nimi,voimaantulopvm,paattymispvm,kiellonlisatieto,voimassaolo,yhteystiedot,tyyli,paivitystila,viimeisinpaivitys,harmaa
FROM "kalastuskielto" WHERE 1 AND (1)
[INFO] 2018-05-11_12:29:32.597 SQL query to get Spatial table features:
SELECT
geometry,ogc_fid,tunnus,kieltotunnus,aluetunnus,uomatunnus,nimi,voimaantulopvm,paattymispvm,kiellonlisatieto,voimassaolo,yhteystiedot,tyyli,paivitystila,viimeisinpaivitys,harmaa
FROM "kalastuskielto" WHERE 1 AND (1)
[INFO] 2018-05-11_12:29:32.612 Valmis. Muistia varattu:274 MB
everything OK and data are opened correctly, now try to close the connection
and an exception happens:
[ERROR] 2018-05-11_12:31:14.299 java.sql.SQLException: The prepared statement
has been finalized
com.vividsolutions.jump.datastore.DataStoreException: java.sql.SQLException:
The prepared statement has been finalized
at
com.vividsolutions.jump.datastore.spatialdatabases.SpatialDatabasesDSConnection.close(SpatialDatabasesDSConnection.java:95)
at
com.vividsolutions.jump.workbench.ui.plugin.datastore.ConnectionManagerPanel.closeSelectedConnections(ConnectionManagerPanel.java:475)
at
com.vividsolutions.jump.workbench.ui.plugin.datastore.ConnectionManagerPanel.access$1000(ConnectionManagerPanel.java:50)
at
com.vividsolutions.jump.workbench.ui.plugin.datastore.ConnectionManagerPanel$11.actionPerformed(ConnectionManagerPanel.java:413)
at
javax.swing.AbstractButton.fireActionPerformed(Unknown Source)...
-Jukka-
Lähettäjä: Michaël Michaud [mailto:m.michael.mich...@orange.fr]
Lähetetty: 11. toukokuuta 2018 12:20
Vastaanottaja: jump-pilot-devel@lists.sourceforge.net
Aihe: Re: [JPP-Devel] Impossible to close OJ after reading GeoPackage
Hi Jukka,
Could you please :
- make a try with the very last version of the sqlite driver (seems to be
3.21.0)
- check that before closing the connection you have no error message related to
database connection in the log file
What kind of operation do you do on the database ? Just select (visualisation)
or also insert/update ?
Michaël
Le 11/05/2018 à 10:19, Rahkonen Jukka (MML) a écrit :
Hi,
I noticed that at least with some GeoPackage databases OpenJUMP goes to a
strange state which makes it impossible to close OpenJUMP. The main reason is
probably that it is not possible to close the connection to GeoPackage (SQLite)
because the same exception comes if I try to close the connection from the
database connection manager. This does not seem to be a new issue but happens
for example with OpenJUMP-20171111-r5557-PLUS and all newer versions which I
tested. Java 8 vs. Java 10 does not make difference.
java.lang.RuntimeException:
com.vividsolutions.jump.datastore.DataStoreException: java.sql.SQLException:
The prepared statement has been finalized
at
com.vividsolutions.jump.workbench.datastore.ConnectionManager$2.exitApplication(ConnectionManager.java:84)
at
com.vividsolutions.jump.workbench.ui.WorkbenchFrame.closeApplication(WorkbenchFrame.java:1380)
at
com.vividsolutions.jump.workbench.ui.WorkbenchFrame.access$000(WorkbenchFrame.java:152)
at
com.vividsolutions.jump.workbench.ui.WorkbenchFrame$ExitPlugin.execute(WorkbenchFrame.java:217)
at
com.vividsolutions.jump.workbench.plugin.AbstractPlugIn$1.actionPerformed(AbstractPlugIn.java:339)
at
javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at
javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at
javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown
Source)
at javax.swing.AbstractButton.doClick(Unknown Source)
at
javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source)
at
javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown
Source)
at javax.swing.JComponent.processMouseEvent(Unknown
Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown
Source)
at java.awt.Container.dispatchEventImpl(Unknown
Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at
java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at
java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at
java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown
Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown
Source)
at java.awt.EventQueue.access$500(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at
java.security.AccessController.doPrivileged(Native Method)
at
java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown
Source)
at
java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown
Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at
java.security.AccessController.doPrivileged(Native Method)
at
java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown
Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at
java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at
java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown
Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown
Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: com.vividsolutions.jump.datastore.DataStoreException:
java.sql.SQLException: The prepared statement has been finalized
at
com.vividsolutions.jump.datastore.spatialdatabases.SpatialDatabasesDSConnection.close(SpatialDatabasesDSConnection.java:95)
at
com.vividsolutions.jump.workbench.datastore.ConnectionManager.closeConnections(ConnectionManager.java:235)
at
com.vividsolutions.jump.workbench.datastore.ConnectionManager$2.exitApplication(ConnectionManager.java:82)
... 42 more
Caused by: java.sql.SQLException: The prepared statement has been finalized
at
org.sqlite.core.NativeDB.throwex(NativeDB.java:471)
at org.sqlite.core.NativeDB.finalize(Native Method)
at org.sqlite.core.DB.close(DB.java:190)
at
org.sqlite.core.CoreConnection.close(CoreConnection.java:394)
at
com.vividsolutions.jump.datastore.spatialdatabases.SpatialDatabasesDSConnection.close(SpatialDatabasesDSConnection.java:93)
... 44 more
-Jukka Rahkonen-
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net<mailto:Jump-pilot-devel@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel