Re: [JPP-Devel] Adding other spatial databases support in OJ core

2015-12-14 Thread Rahkonen Jukka (MML)
You can test if Spatialite is available by using some Spatialite function in the "where" box of the connection, for example [where] ST_Area(geometry)>2 The ne_110m_admin_0_countries layer should have 153 rows now. For me the count is 0 but log file does not report any error. Another way to test

[JPP-Devel] SVN: [4627] core/trunk

2015-12-14 Thread jump-pilot-svn
Revision: 4627 http://sourceforge.net/p/jump-pilot/code/4627 Author: edso Date: 2015-12-15 01:26:12 + (Tue, 15 Dec 2015) Log Message: --- added icons to the datastore query chooser's combobox "static"alized a part of ConnectionManagerPanel w/o redesign consequences Modi

[JPP-Devel] SVN: [4626] core/trunk/etc/readme.txt

2015-12-14 Thread jump-pilot-svn
Revision: 4626 http://sourceforge.net/p/jump-pilot/code/4626 Author: edso Date: 2015-12-15 01:14:05 + (Tue, 15 Dec 2015) Log Message: --- refine readme icon desc Modified Paths: -- core/trunk/etc/readme.txt Modified: core/trunk/etc/readme.txt ==

[JPP-Devel] SVN: [4625] core/trunk/src/com/vividsolutions/jump/workbench/ui

2015-12-14 Thread jump-pilot-svn
Revision: 4625 http://sourceforge.net/p/jump-pilot/code/4625 Author: edso Date: 2015-12-14 23:48:30 + (Mon, 14 Dec 2015) Log Message: --- moved some astray famfam icons into the famfam folder modded IconLoader to autosearch for images in famfam/ and fugue/ in case the i

Re: [JPP-Devel] Adding other spatial databases support in OJ core

2015-12-14 Thread edgar . soldin
ok, loading the dataset works. Nico: why can't i modify my request via 'layer name context menu/Database/Edit Query'? Jukka&Nico: how can i check if spatialite is working? ..ede On 14.12.2015 22:59, Rahkonen Jukka (MML) wrote: > Hi, > > The latest ones are these: > http://www.gaia-gis.it/gaia

[JPP-Devel] SVN: [4624] core/trunk/src/com/vividsolutions/jump/workbench/ui

2015-12-14 Thread jump-pilot-svn
Revision: 4624 http://sourceforge.net/p/jump-pilot/code/4624 Author: edso Date: 2015-12-14 22:47:54 + (Mon, 14 Dec 2015) Log Message: --- new cleaner spatialite icon commented unused/missing sqlserver icons Modified Paths: -- core/trunk/src/com/vividsolu

Re: [JPP-Devel] Adding other spatial databases support in OJ core

2015-12-14 Thread Rahkonen Jukka (MML)
Hi, The latest ones are these: http://www.gaia-gis.it/gaia-sins/windows-bin-x86-test/mod_spatialite-4.4.0-RC0-win-x86.7z http://www.gaia-gis.it/gaia-sins/windows-bin-amd64-test/mod_spatialite-4.4.0-RC0-win-amd64.7z The list of the SQL functions of this version is at http://www.gaia-gis.it/gaia-s

Re: [JPP-Devel] Adding other spatial databases support in OJ core

2015-12-14 Thread edgar . soldin
On 14.12.2015 14:33, Rahkonen Jukka (MML) wrote: > I will give a better example once I have managed to make the brand new > SpatiaLite v. 4.4.0 version to work with OpenJUMP. The RC0 was published > today but it seems to miss some dependencies. Jukka, what is the latest libspatialite version a

[JPP-Devel] SVN: [4623] core/trunk/src/com/vividsolutions/jump/I18N.java

2015-12-14 Thread jump-pilot-svn
Revision: 4623 http://sourceforge.net/p/jump-pilot/code/4623 Author: edso Date: 2015-12-14 18:39:48 + (Mon, 14 Dec 2015) Log Message: --- fixing Malayalam File menu broken " Exception in thread "AWT-EventQueue-0" java.lang.ArrayIndexOutOfBoundsException: 280 at su

[JPP-Devel] SVN: [4622] core/trunk

2015-12-14 Thread jump-pilot-svn
Revision: 4622 http://sourceforge.net/p/jump-pilot/code/4622 Author: elnico Date: 2015-12-14 17:42:19 + (Mon, 14 Dec 2015) Log Message: --- New images for spatial datastore connections: loaded with OJ method, moved to the right folder. Licenses added to readme.txt Modi

Re: [JPP-Devel] Adding other spatial databases support in OJ core

2015-12-14 Thread Nicolas Ribot
Thanks for the research. I will make modifications. I like the oracle logo ;) On 14 December 2015 at 13:00, wrote: > On 14.12.2015 11:22, Nicolas Ribot wrote: > > 4. > > what is the licensing for the icons? where do they come from? > > > > > > > > Postgresql: From official icons/logo: >

Re: [JPP-Devel] Adding other spatial databases support in OJ core

2015-12-14 Thread Nicolas Ribot
Hi, I must say I'm confused too :) Glad to read it works even when spatialite is not detected. Spatialite sql code is catched so it should default to no extent, then the Converter tries to guess the geometry column type, and converts to OJ geometries I'm currently trying to test on platforms w/o

Re: [JPP-Devel] Adding other spatial databases support in OJ core

2015-12-14 Thread Rahkonen Jukka (MML)
I mean these blogs: http://openjump.blogspot.fi/search/label/GeoPackage -Jukka- -Alkuperäinen viesti- Lähettäjä: Rahkonen Jukka (MML) [mailto:jukka.rahko...@maanmittauslaitos.fi] Lähetetty: 14. joulukuuta 2015 15:34 Vastaanottaja: OpenJump develop and use Aihe: Re: [JPP-Devel] Adding oth

Re: [JPP-Devel] Adding other spatial databases support in OJ core

2015-12-14 Thread Rahkonen Jukka (MML)
Here you are: http://latuviitta.org/documents/Spatialite_datastore_in_OpenJUMP.pdf Sample data http://latuviitta.org/downloads/ne_countries.sqlite. I have not discovered yet how to make datastore to use Spatialite or other SQLite extensions. Part 2 of our GeoPackage blog posts gives an example a

Re: [JPP-Devel] Adding other spatial databases support in OJ core

2015-12-14 Thread edgar . soldin
On 13.12.2015 23:59, Rahkonen Jukka (MML) wrote: > Works now but SQLite jdbc driver must still be in \lib. Using > \lib\ext\dbdatastore gives ClassNotFound error. hey Jukka, can you give me a short step-by-step on how to load an sqlite dataset plus an example sqlite file? maybe including spatia

Re: [JPP-Devel] Adding other spatial databases support in OJ core

2015-12-14 Thread edgar . soldin
On 14.12.2015 11:22, Nicolas Ribot wrote: > 4. > what is the licensing for the icons? where do they come from? > > > > Postgresql: From official icons/logo: > http://www.postgresql.org/community/propaganda/, reduced and colors modified ok these are, Creative Commons Attribution-ShareAl

Re: [JPP-Devel] WFS plugin gives NoSuchMethodError in r4620

2015-12-14 Thread Rahkonen Jukka (MML)
I thought that it has been working but probably I was wrong and at least r4401 (2015-04-18) gives the same error. I attached SRID 4326 for the layer with the Layer - Set SRID tool because it looks like degree wants to know it but it does not help. There is something commented out in https://so

Re: [JPP-Devel] Adding other spatial databases support in OJ core

2015-12-14 Thread Rahkonen Jukka (MML)
Hi Nicolas, I am confused. I am using the Spatialite datastore with OJ r4620 for reading my existing Spatialite databases with good success and I am sure that I do not have mod_spatialite nor the dependencies in my OJ installation. Where does you code try to find mod_spatialite and the dll file

Re: [JPP-Devel] WFS plugin gives NoSuchMethodError in r4620

2015-12-14 Thread edgar . soldin
did that work at some point in the past in my port, meaning after r4219? ..ede On 14.12.2015 11:41, Rahkonen Jukka (MML) wrote: > How to reproduce: > > > > - Create a layer, digitize any feature on it, select the feature and > press the WFS button. The plugin is supposed to take the

[JPP-Devel] WFS plugin gives NoSuchMethodError in r4620

2015-12-14 Thread Rahkonen Jukka (MML)
How to reproduce: - Create a layer, digitize any feature on it, select the feature and press the WFS button. The plugin is supposed to take the selected geometry and use it for building a spatial filter but now it throws an error: java.lang.NoSuchMethodError: org.deegree.model.spatia

Re: [JPP-Devel] Adding other spatial databases support in OJ core

2015-12-14 Thread Nicolas Ribot
Some notes concerning Sqlite/Spatialite support. My primary goal was to support *spatialite*, ie, as you said, with a valid spatialite installation for the target platform (mod_spatialite available). The main reason is I wanted the mechanism to be as close as possible from other Spatial databases

Re: [JPP-Devel] SQLite/SpatiaLite and Error parsing timestamp

2015-12-14 Thread Nicolas Ribot
Hi Jukka, Thanks for the link. I will add tables with these data to test. Nicolas On 14 December 2015 at 00:07, Rahkonen Jukka (MML) < jukka.rahko...@maanmittauslaitos.fi> wrote: > Hi Nicolas, > > > > This discussion defines the problem with SQLite and times > > http://comments.gmane.org/gmane.

Re: [JPP-Devel] Adding other spatial databases support in OJ core

2015-12-14 Thread Nicolas Ribot
On 13 December 2015 at 19:33, wrote: > Nico, > > 1. > i reverted your changes to pom.xml, which cannot stay in this fashion > anyway as the libs would be packaged into CORE. for now DB connectivity is > a PLUS feature to keep the CORE footprint small. > > also my guess it that it stops the build