Hi Ede, Right, it is possible to close OJ r5791 even it throws an error.
-Jukka- -----Alkuperäinen viesti----- Lähettäjä: edgar.sol...@web.de [mailto:edgar.sol...@web.de] Lähetetty: 11. toukokuuta 2018 13:15 Vastaanottaja: OpenJump develop and use <jump-pilot-devel@lists.sourceforge.net>; Rahkonen Jukka (MML) <jukka.rahko...@maanmittauslaitos.fi> Aihe: Re: [JPP-Devel] Impossible to close OJ after reading GeoPackage Jukka, can you try r5791 ? it should at least make OJ shit down again but show the error beforehand. ..ede On 11.05.2018 11:39, Rahkonen Jukka (MML) wrote: > 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,voimaa > ntulopvm,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,voimaa > ntulopvm,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.SpatialDatabasesDSC > onnection.close(SpatialDatabasesDSConnection.java:95) > > at > com.vividsolutions.jump.workbench.ui.plugin.datastore.ConnectionManage > rPanel.closeSelectedConnections(ConnectionManagerPanel.java:475) > > at > com.vividsolutions.jump.workbench.ui.plugin.datastore.ConnectionManage > rPanel.access$1000(ConnectionManagerPanel.java:50) > > at > com.vividsolutions.jump.workbench.ui.plugin.datastore.ConnectionManage > rPanel$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.exitAp > plication(ConnectionManager.java:84) > > at > com.vividsolutions.jump.workbench.ui.WorkbenchFrame.closeApplication(W > orkbenchFrame.java:1380) > > at > com.vividsolutions.jump.workbench.ui.WorkbenchFrame.access$000(Workben > chFrame.java:152) > > at > com.vividsolutions.jump.workbench.ui.WorkbenchFrame$ExitPlugin.execute > (WorkbenchFrame.java:217) > > at > com.vividsolutions.jump.workbench.plugin.AbstractPlugIn$1.actionPerfor > med(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.doIntersectionPr > ivilege(Unknown Source) > > at > java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPr > ivilege(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.doIntersectionPr > ivilege(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.SpatialDatabasesDSC > onnection.close(SpatialDatabasesDSConnection.java:95) > > at > com.vividsolutions.jump.workbench.datastore.ConnectionManager.closeCon > nections(ConnectionManager.java:235) > > at > com.vividsolutions.jump.workbench.datastore.ConnectionManager$2.exitAp > plication(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.SpatialDatabasesDSC > onnection.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 > ------------------------------------------------------------------------------ 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