Re: [JPP-Devel] SVN: [6144] core/trunk/src/com/vividsolutions/jump
ok,
i'll prepare a new maintenance release now.. ede
On 03.03.2019 22:13, Rahkonen Jukka (MML) wrote:
> Hi,
>
> Reading layers with Add datastore layer from geopackage and Spatialite with
> r6144 was successful. Thanks, Nico.
>
> -Jukka-
>
> -Alkuperäinen viesti-
> Lähettäjä: edgar.sol...@web.de
> Lähetetty: lauantai 2. maaliskuuta 2019 12.53
> Vastaanottaja: Rahkonen Jukka (MML)
> Aihe: Re: [JPP-Devel] SVN: [6144] core/trunk/src/com/vividsolutions/jump
>
> Jukka,
>
> could you double check it please? i guess now would be a good time for the
> maintenance release then.. ede
>
> On 28.02.2019 11:25, jump-pilot-svn--- via Jump-pilot-devel wrote:
>> Revision: 6144
>> http://sourceforge.net/p/jump-pilot/code/6144
>> Author: elnico
>> Date: 2019-02-28 10:25:42 + (Thu, 28 Feb 2019)
>> Log Message:
>> ---
>> Corrected bug preventing some Spatialite tables to be loaded.
>> Removed system.out.println debug part
>>
>> Modified Paths:
>> --
>>
>> core/trunk/src/com/vividsolutions/jump/datastore/spatialite/SpatialiteDSMetadata.java
>>
>> core/trunk/src/com/vividsolutions/jump/workbench/ui/plugin/datastore/A
>> ddDatastoreLayerPanel.java
>>
>> Modified:
>> core/trunk/src/com/vividsolutions/jump/datastore/spatialite/Spatialite
>> DSMetadata.java
>> ===
>> ---
>> core/trunk/src/com/vividsolutions/jump/datastore/spatialite/SpatialiteDSMetadata.java
>> 2019-02-25 14:11:38 UTC (rev 6143)
>> +++
>> core/trunk/src/com/vividsolutions/jump/datastore/spatialite/SpatialiteDSMetadata.java
>> 2019-02-28 10:25:42 UTC (rev 6144)
>> @@ -1,6 +1,7 @@
>> package com.vividsolutions.jump.datastore.spatialite;
>>
>> import com.vividsolutions.jump.datastore.DataStoreConnection;
>> +import com.vividsolutions.jump.datastore.DataStoreLayer;
>> import com.vividsolutions.jump.datastore.GeometryColumn;
>> import com.vividsolutions.jump.datastore.SQLUtil;
>> import com.vividsolutions.jump.datastore.spatialdatabases.*;
>> @@ -289,17 +290,17 @@
>> // tries to load spatialite, assuming it is available on the system's
>> path
>> Statement stmt = null;
>> try {
>> - stmt = conn.getJdbcConnection().createStatement();
>> - stmt.executeUpdate("SELECT load_extension('mod_spatialite')");
>> - // ex is thrown if extension cannot be loaded
>> - this.spatialiteLoaded = true;
>> - ResultSet rs = stmt.executeQuery("select spatialite_version()");
>> - rs.next();
>> - this.setSpatialiteVersion(rs.getString(1));
>> -
>> - JUMPWorkbench.getInstance().getFrame().log(
>> - "SpatialDatabasesPlugin: Spatialite extension loaded for this
>> connexion, version: "
>> - + this.getSpatialiteVersion(), this.getClass());
>> +// stmt = conn.getJdbcConnection().createStatement();
>> +// stmt.executeUpdate("SELECT load_extension('mod_spatialite')");
>> +// // ex is thrown if extension cannot be loaded
>> +// this.spatialiteLoaded = true;
>> +// ResultSet rs = stmt.executeQuery("select spatialite_version()");
>> +// rs.next();
>> +// this.setSpatialiteVersion(rs.getString(1));
>> +//
>> +// JUMPWorkbench.getInstance().getFrame().log(
>> +// "SpatialDatabasesPlugin: Spatialite extension loaded for this
>> connexion, version: "
>> +// + this.getSpatialiteVersion(), this.getClass());
>> } catch (Exception e) {
>>JUMPWorkbench.getInstance().getFrame().log(
>>"SpatialDatabasesPlugin: CANNOT load Spatialite Extention
>> (mod_spatialite), reason:"
>> @@ -306,7 +307,7 @@
>>+ e.getMessage(), this.getClass());
>> } finally {
>>try {
>> -stmt.close();
>> +//stmt.close();
>>} catch (Throwable th) {
>> // TODO: log
>> th.printStackTrace();
>> @@ -418,7 +419,7 @@
>>/**
>> * builds the map of geometric columns database type: WKB, WKT,
>> SPATIALITE to
>> * be able to build custom queries for extent and geo type retrieval. The
>> - * geometry_format column of the metadata will be queries to find geometry
>> + * geometry_format column of the metadata will be queried to find
>> + geometry
>> * type (column only detected in the FDO_LAYOUT format). For other layout,
>> * will default to SPATIALITE type
>> */
>> @@ -498,6 +499,15 @@
>>public GeometryColumn getGeometryColumn(String datasetName, String
>> geoCol) {
>> List l = this.geometryColumnListMap.get(datasetName);
>> if (l == null) {
>> + // 2018-02-28: also look into dataStoreLayers to find geo column, now
>> this container is used to
>> + // speedup DB tables discovery
>> + if (this.dataStoreLayers != null) {
>> +for (DataStoreLayer dsl : this.dataStoreLayers) {
>> + if (datasetName.equals(dsl.getFullName()) &&
>> geoCol.equals(dsl.getGeoCol().getName())) {
>> +return dsl.getGeoCol();
>> + }
Re: [JPP-Devel] SVN: [6144] core/trunk/src/com/vividsolutions/jump
Thanks Ede,
Michaël
Le 04/03/2019 à 10:51, edgar.sol...@web.de a écrit :
ok,
i'll prepare a new maintenance release now.. ede
On 03.03.2019 22:13, Rahkonen Jukka (MML) wrote:
Hi,
Reading layers with Add datastore layer from geopackage and Spatialite with
r6144 was successful. Thanks, Nico.
-Jukka-
-Alkuperäinen viesti-
Lähettäjä: edgar.sol...@web.de
Lähetetty: lauantai 2. maaliskuuta 2019 12.53
Vastaanottaja: Rahkonen Jukka (MML)
Aihe: Re: [JPP-Devel] SVN: [6144] core/trunk/src/com/vividsolutions/jump
Jukka,
could you double check it please? i guess now would be a good time for the
maintenance release then.. ede
On 28.02.2019 11:25, jump-pilot-svn--- via Jump-pilot-devel wrote:
Revision: 6144
http://sourceforge.net/p/jump-pilot/code/6144
Author: elnico
Date: 2019-02-28 10:25:42 + (Thu, 28 Feb 2019)
Log Message:
---
Corrected bug preventing some Spatialite tables to be loaded.
Removed system.out.println debug part
Modified Paths:
--
core/trunk/src/com/vividsolutions/jump/datastore/spatialite/SpatialiteDSMetadata.java
core/trunk/src/com/vividsolutions/jump/workbench/ui/plugin/datastore/A
ddDatastoreLayerPanel.java
Modified:
core/trunk/src/com/vividsolutions/jump/datastore/spatialite/Spatialite
DSMetadata.java
===
---
core/trunk/src/com/vividsolutions/jump/datastore/spatialite/SpatialiteDSMetadata.java
2019-02-25 14:11:38 UTC (rev 6143)
+++
core/trunk/src/com/vividsolutions/jump/datastore/spatialite/SpatialiteDSMetadata.java
2019-02-28 10:25:42 UTC (rev 6144)
@@ -1,6 +1,7 @@
package com.vividsolutions.jump.datastore.spatialite;
import com.vividsolutions.jump.datastore.DataStoreConnection;
+import com.vividsolutions.jump.datastore.DataStoreLayer;
import com.vividsolutions.jump.datastore.GeometryColumn;
import com.vividsolutions.jump.datastore.SQLUtil;
import com.vividsolutions.jump.datastore.spatialdatabases.*;
@@ -289,17 +290,17 @@
// tries to load spatialite, assuming it is available on the system's path
Statement stmt = null;
try {
- stmt = conn.getJdbcConnection().createStatement();
- stmt.executeUpdate("SELECT load_extension('mod_spatialite')");
- // ex is thrown if extension cannot be loaded
- this.spatialiteLoaded = true;
- ResultSet rs = stmt.executeQuery("select spatialite_version()");
- rs.next();
- this.setSpatialiteVersion(rs.getString(1));
-
- JUMPWorkbench.getInstance().getFrame().log(
- "SpatialDatabasesPlugin: Spatialite extension loaded for this connexion,
version: "
- + this.getSpatialiteVersion(), this.getClass());
+// stmt = conn.getJdbcConnection().createStatement();
+// stmt.executeUpdate("SELECT load_extension('mod_spatialite')");
+// // ex is thrown if extension cannot be loaded
+// this.spatialiteLoaded = true;
+// ResultSet rs = stmt.executeQuery("select spatialite_version()");
+// rs.next();
+// this.setSpatialiteVersion(rs.getString(1));
+//
+// JUMPWorkbench.getInstance().getFrame().log(
+// "SpatialDatabasesPlugin: Spatialite extension loaded for this
connexion, version: "
+// + this.getSpatialiteVersion(), this.getClass());
} catch (Exception e) {
JUMPWorkbench.getInstance().getFrame().log(
"SpatialDatabasesPlugin: CANNOT load Spatialite Extention
(mod_spatialite), reason:"
@@ -306,7 +307,7 @@
+ e.getMessage(), this.getClass());
} finally {
try {
-stmt.close();
+//stmt.close();
} catch (Throwable th) {
// TODO: log
th.printStackTrace();
@@ -418,7 +419,7 @@
/**
* builds the map of geometric columns database type: WKB, WKT, SPATIALITE
to
* be able to build custom queries for extent and geo type retrieval. The
- * geometry_format column of the metadata will be queries to find geometry
+ * geometry_format column of the metadata will be queried to find
+ geometry
* type (column only detected in the FDO_LAYOUT format). For other layout,
* will default to SPATIALITE type
*/
@@ -498,6 +499,15 @@
public GeometryColumn getGeometryColumn(String datasetName, String geoCol) {
List l = this.geometryColumnListMap.get(datasetName);
if (l == null) {
+ // 2018-02-28: also look into dataStoreLayers to find geo column, now
this container is used to
+ // speedup DB tables discovery
+ if (this.dataStoreLayers != null) {
+for (DataStoreLayer dsl : this.dataStoreLayers) {
+ if (datasetName.equals(dsl.getFullName()) &&
geoCol.equals(dsl.getGeoCol().getName())) {
+return dsl.getGeoCol();
+ }
+}
+ }
return null;
}
Modified:
core/trunk/src/com/vividsolutions/jump/workbench/ui/plugin/datastore/A
ddDatastoreLayerPanel.java
===
[JPP-Devel] SVN: [6145] core/trunk
Revision: 6145
http://sourceforge.net/p/jump-pilot/code/6145
Author: edso
Date: 2019-03-04 17:00:44 + (Mon, 04 Mar 2019)
Log Message:
---
summarize Changes before release
Modified Paths:
--
core/trunk/ChangeLog
core/trunk/Changes.txt
Modified: core/trunk/ChangeLog
===
--- core/trunk/ChangeLog2019-02-28 10:25:42 UTC (rev 6144)
+++ core/trunk/ChangeLog2019-03-04 17:00:44 UTC (rev 6145)
@@ -3,8 +3,11 @@
# 2. make sure that lines break at 80 chars for constricted display situations
#< 80 chars
-->#
+2019-02-28 Nicolas Ribot
+ * Corrected another bug preventing some Spatialite tables to be loaded.
+
2019-02-21 mmichaud
- * Add an option to connect to a WMS with unchecked certificate authority
+ * Add an option to connect to a WMS with invalid certificate (unchecked)
2019-02-19 Nicolas Ribot
* Corrected typo in SpatialiteDSMetadata datasetInfoQuery string preventing
@@ -39,7 +42,7 @@
2019-01-17 ede
* bugfix "NPE with adding data into the second project with OJ"
-<-- Changes.txt updated until here -->
+* release 1.14
*
2018-12-31 ede, Giuseppe Aruta.
* Updated ColorChooser to version 1.3.
Modified: core/trunk/Changes.txt
===
--- core/trunk/Changes.txt 2019-02-28 10:25:42 UTC (rev 6144)
+++ core/trunk/Changes.txt 2019-03-04 17:00:44 UTC (rev 6145)
@@ -1,5 +1,35 @@
Version ${version.number} ${version.release} rev.${version.revision} (released
on ${version.buildDateLong})
+ Improvements
+ * Add an option to connect to a WMS with invalid certificate
+ * speedup loading GeoPackage datasets w/ date/time columns utilizing
+flex feature's lazy conversion
+ * added format to FlexibleDateParser for dates containing
+ISO 8601 time zone "-08; -0800; -08:00" eg. "2019/02/17 22:44:35.325+02"
+ * Added calculus of number of classes on DEM statistics plugin
+
+ Bug Fixes
+ * Corrected typo in SpatialiteDSMetadata datasetInfoQuery string preventing
+spatial tables to be listed
+ * Corrected another bug preventing some Spatialite tables to be loaded.
+ * bugfix "NPE with adding data into the second project with OJ"
+
+ PLUS
+ * PLUS upgrade KML extension
+- 0.2.5 (2019-02-17) also read if no exists
+ * bugfix #485 "Cannot import kml", removed currently obsolete conversion to
+FlexibleFeatureSchema
+ * OpenKLEM Plugin: Corrected a list of bug and made some implementations:
+1) Reduced hydro table to 2500 cells for OpenKLEM output tab (speedup time)
+2) added monitoring to mostly all processes
+3) workaround to avoid 'gost' list of raster layers (partially solved)
+4) workaround to solve border false values on the borders for aspect and
+ slope rasters
+5) added file type to exported raster plugin
+
+
+Version 1.14 release rev.6065 (released on 01. January 2019)
+
Highlights
* CORE source is now java 8
* general java 11 runtime compatibility
___
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
[JPP-Devel] SVN: [6146] core/tags/1.14.1/
Revision: 6146 http://sourceforge.net/p/jump-pilot/code/6146 Author: edso Date: 2019-03-04 17:03:17 + (Mon, 04 Mar 2019) Log Message: --- Added Paths: --- core/tags/1.14.1/ ___ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
[JPP-Devel] SVN: [6147] core/trunk/ChangeLog
Revision: 6147 http://sourceforge.net/p/jump-pilot/code/6147 Author: edso Date: 2019-03-04 17:05:53 + (Mon, 04 Mar 2019) Log Message: --- add "updated until" marker Modified Paths: -- core/trunk/ChangeLog Modified: core/trunk/ChangeLog === --- core/trunk/ChangeLog2019-03-04 17:03:17 UTC (rev 6146) +++ core/trunk/ChangeLog2019-03-04 17:05:53 UTC (rev 6147) @@ -3,6 +3,8 @@ # 2. make sure that lines break at 80 chars for constricted display situations #< 80 chars --># +<-- Changes.txt updated until here --> + 2019-02-28 Nicolas Ribot * Corrected another bug preventing some Spatialite tables to be loaded. ___ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
Re: [JPP-Devel] SVN: [6144] core/trunk/src/com/vividsolutions/jump
Hi
thanks Ede for your effort!
Peppe
Il giorno lun 4 mar 2019 alle ore 13:32 Michaël Michaud <
m.michael.mich...@orange.fr> ha scritto:
> Thanks Ede,
>
> Michaël
>
> Le 04/03/2019 à 10:51, edgar.sol...@web.de a écrit :
> > ok,
> >
> > i'll prepare a new maintenance release now.. ede
> >
> > On 03.03.2019 22:13, Rahkonen Jukka (MML) wrote:
> >> Hi,
> >>
> >> Reading layers with Add datastore layer from geopackage and Spatialite
> with r6144 was successful. Thanks, Nico.
> >>
> >> -Jukka-
> >>
> >> -Alkuperäinen viesti-
> >> Lähettäjä: edgar.sol...@web.de
> >> Lähetetty: lauantai 2. maaliskuuta 2019 12.53
> >> Vastaanottaja: Rahkonen Jukka (MML) <
> jukka.rahko...@maanmittauslaitos.fi>
> >> Aihe: Re: [JPP-Devel] SVN: [6144] core/trunk/src/com/vividsolutions/jump
> >>
> >> Jukka,
> >>
> >> could you double check it please? i guess now would be a good time for
> the maintenance release then.. ede
> >>
> >> On 28.02.2019 11:25, jump-pilot-svn--- via Jump-pilot-devel wrote:
> >>> Revision: 6144
> >>>http://sourceforge.net/p/jump-pilot/code/6144
> >>> Author: elnico
> >>> Date: 2019-02-28 10:25:42 + (Thu, 28 Feb 2019)
> >>> Log Message:
> >>> ---
> >>> Corrected bug preventing some Spatialite tables to be loaded.
> >>> Removed system.out.println debug part
> >>>
> >>> Modified Paths:
> >>> --
> >>>
> core/trunk/src/com/vividsolutions/jump/datastore/spatialite/SpatialiteDSMetadata.java
> >>>
> >>> core/trunk/src/com/vividsolutions/jump/workbench/ui/plugin/datastore/A
> >>> ddDatastoreLayerPanel.java
> >>>
> >>> Modified:
> >>> core/trunk/src/com/vividsolutions/jump/datastore/spatialite/Spatialite
> >>> DSMetadata.java
> >>> ===
> >>> ---
> core/trunk/src/com/vividsolutions/jump/datastore/spatialite/SpatialiteDSMetadata.java
> 2019-02-25 14:11:38 UTC (rev 6143)
> >>> +++
> core/trunk/src/com/vividsolutions/jump/datastore/spatialite/SpatialiteDSMetadata.java
> 2019-02-28 10:25:42 UTC (rev 6144)
> >>> @@ -1,6 +1,7 @@
> >>> package com.vividsolutions.jump.datastore.spatialite;
> >>>
> >>> import com.vividsolutions.jump.datastore.DataStoreConnection;
> >>> +import com.vividsolutions.jump.datastore.DataStoreLayer;
> >>> import com.vividsolutions.jump.datastore.GeometryColumn;
> >>> import com.vividsolutions.jump.datastore.SQLUtil;
> >>> import com.vividsolutions.jump.datastore.spatialdatabases.*;
> >>> @@ -289,17 +290,17 @@
> >>> // tries to load spatialite, assuming it is available on the
> system's path
> >>> Statement stmt = null;
> >>> try {
> >>> - stmt = conn.getJdbcConnection().createStatement();
> >>> - stmt.executeUpdate("SELECT load_extension('mod_spatialite')");
> >>> - // ex is thrown if extension cannot be loaded
> >>> - this.spatialiteLoaded = true;
> >>> - ResultSet rs = stmt.executeQuery("select spatialite_version()");
> >>> - rs.next();
> >>> - this.setSpatialiteVersion(rs.getString(1));
> >>> -
> >>> - JUMPWorkbench.getInstance().getFrame().log(
> >>> - "SpatialDatabasesPlugin: Spatialite extension loaded for
> this connexion, version: "
> >>> - + this.getSpatialiteVersion(), this.getClass());
> >>> +// stmt = conn.getJdbcConnection().createStatement();
> >>> +// stmt.executeUpdate("SELECT load_extension('mod_spatialite')");
> >>> +// // ex is thrown if extension cannot be loaded
> >>> +// this.spatialiteLoaded = true;
> >>> +// ResultSet rs = stmt.executeQuery("select
> spatialite_version()");
> >>> +// rs.next();
> >>> +// this.setSpatialiteVersion(rs.getString(1));
> >>> +//
> >>> +// JUMPWorkbench.getInstance().getFrame().log(
> >>> +// "SpatialDatabasesPlugin: Spatialite extension loaded for
> this connexion, version: "
> >>> +// + this.getSpatialiteVersion(), this.getClass());
> >>> } catch (Exception e) {
> >>> JUMPWorkbench.getInstance().getFrame().log(
> >>> "SpatialDatabasesPlugin: CANNOT load Spatialite Extention
> (mod_spatialite), reason:"
> >>> @@ -306,7 +307,7 @@
> >>> + e.getMessage(), this.getClass());
> >>> } finally {
> >>> try {
> >>> -stmt.close();
> >>> +//stmt.close();
> >>> } catch (Throwable th) {
> >>> // TODO: log
> >>> th.printStackTrace();
> >>> @@ -418,7 +419,7 @@
> >>> /**
> >>> * builds the map of geometric columns database type: WKB, WKT,
> SPATIALITE to
> >>> * be able to build custom queries for extent and geo type
> retrieval. The
> >>> - * geometry_format column of the metadata will be queries to find
> geometry
> >>> + * geometry_format column of the metadata will be queried to find
> >>> + geometry
> >>> * type (column only detected in the FDO_LAYOUT format). For other
> layout,
> >>> * will default to SPATIALITE type
> >>> */
> >>> @@ -498,6 +499,15 @@
> >>> public GeometryC
