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

On 17.12.2015 07:21, Rahkonen Jukka (MML) wrote: > edgar soldin wrote: > >> just assumed because of >> https://sourceforge.net/p/jump-pilot/code/HEAD/tree/core/trunk/src/com/vividsolutions/jump/datastore/spatialite/SpatialiteDataStoreDriver.java#l69 >> "new

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

On 16.12.2015 16:44, Rahkonen Jukka (MML) wrote: > Lähettäjä: edgar.sol...@web.de [mailto:edgar.sol...@web.de] > > >> issue with the sqlite extension libs seems to be that they are loaded by >> sqlite itself. all _we've_ got is the >> sqlite jdbc that seems to have a config switch to turn on

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

I think you guys have figured this out, more details if not: DBQuery requires "spatialite=mod_spatialite" because this tells the SQLite drivers to load the spatialite extensions. I didn't want to hardcode the string "mod_spatialite" in case the Spatialite author changed the name of the shared

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

edgar soldin wrote: > just assumed because of > https://sourceforge.net/p/jump-pilot/code/HEAD/tree/core/trunk/src/com/vividsolutions/jump/datastore/spatialite/SpatialiteDataStoreDriver.java#l69 > "new SQLiteConfig().enableLoadExtension(true);" > but obviously this just autoloads the sqlite

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

Lähettäjä: edgar.sol...@web.de [mailto:edgar.sol...@web.de] > issue with the sqlite extension libs seems to be that they are loaded by > sqlite itself. all _we've_ got is the > sqlite jdbc that seems to have a config switch to turn on autoloading *OR* > the SELECT load_extension(...); >

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

hey Jukka, On 16.12.2015 09:34, Rahkonen Jukka (MML) wrote: > Hi, > > I have nothing at all to complain and I think that you managed to add the > SQLite/Spatialite datastore very quickly. It just appears that in my Windows > environment the mod_spatialite extension is not found if I put all

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

Hi, I have nothing at all to complain and I think that you managed to add the SQLite/Spatialite datastore very quickly. It just appears that in my Windows environment the mod_spatialite extension is not found if I put all the dll files into lib\ext which was the only place where I could make

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

edgar soldin wrote: > yes. DBQuery seems to insist on having the parameter > "spatialite=mod_spatialite". seems like it does > not enable the autoloading. > Larry: any reason for that? I think it is the right thing to do because the key feature of DB Query is that it is robust. It can read

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

On 15.12.2015 07:11, Rahkonen Jukka (MML) wrote: > 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

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

Jukka, The SQLite/Spatialite code in OJ is quite new and barely tested with all combinations of sqlite flavours. There is a lot of room for improvement, especially with regards to loaded extension. Currently, mod_spatialite loading is detected and a boolean is set to tell the code if spatialite

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

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

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

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

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

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) > > >

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

wt.EventQueue$4.run(Unknown Source) > > at java.awt.EventQueue$4.run(Unknown Source) > > at java.security.AccessController.doPrivileged(Native Method) > > at > java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source) > > at java.awt.

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

n_0_countries; -Jukka- -Alkuperäinen viesti- Lähettäjä: edgar.sol...@web.de [mailto:edgar.sol...@web.de] Lähetetty: 15. joulukuuta 2015 0:53 Vastaanottaja: OpenJump develop and use Kopio: Nicolas Ribot Aihe: Re: [JPP-Devel] Adding other spatial databases support in OJ core ok, loadin

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

other spatial databases support in OJ core 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

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

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

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

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$1.doIntersectionPrivilege(Unknown Source) > >

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

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

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

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

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

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

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

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

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

ok, loading the dataset works. Nico: why can't i modify my request via 'layer name context menu/Database/Edit Query'? Jukka: 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: >

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

the functionally correct approach of course would be adding the layer only after the request went trough fine. you can create layers and feature collections and throw them away if it wont work out. ..ede On 13.12.2015 00:17, Nicolas Ribot wrote: > Yes good idea, I will add a test before

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

I completely forgot the validateInput() method: perfect place to detect invalid layers before sending them... ^^ Nicolas On 13 December 2015 at 16:31, Nicolas Ribot wrote: > Yes, I will look at another solution. > BTW, ImageCacheRenderer is already catching the

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

Hi, I made a commit (r4609) adding Spatial databases support for MySQL/MariaDB and Spatialite. Some points concerning this commit: • FilterQuery and Adhoc queries are supported for all spatial databases • When a wrong WHERE clause is added to a datasource, SQL error is displayed and layer is

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

Yes, I will look at another solution. BTW, ImageCacheRenderer is already catching the Throwable when rendering, and issues a user warning in the Frame statusbar in case of error. Nicolas On 13 December 2015 at 16:27, wrote: > On 13.12.2015 16:17, Nicolas Ribot wrote: > >

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

On 13.12.2015 16:17, Nicolas Ribot wrote: > AFAIU, when choosing a layer from a datastore, the OJ Layer is added to the > panel, then a separate thread tries to load the Features. This thread > triggers the actual SQL code for the layer. > Instead of testing the layer each time a WHERE clause is

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

seek, and ye shall find :)).. ede On 13.12.2015 17:34, Nicolas Ribot wrote: > I completely forgot the validateInput() method: perfect place to detect > invalid layers before sending them... ^^ > > Nicolas > > On 13 December 2015 at 16:31, Nicolas Ribot

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

On 13.12.2015 19:33, edgar.sol...@web.de wrote: > 3. > we keep icons in a special folder, please move them there > com.vividsolutions.jump.workbench.ui.images there even is an IconLoader class which is easy to use.. e.g. IconLoader.icon("application_mosaic.png"); ..ede

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

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) > > > -Alkupe

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

Jukka, please try r4614 PLUS.. ede On 13.12.2015 19:00, Rahkonen Jukka (MML) wrote: > Very interesting. Unfortunately r4609 did not build > http://vorboss.dl.sourceforge.net/project/jump-pilot/OpenJUMP_snapshots/OpenJUMP-20151213-r4609.log. > > > > -Jukka Rahkonen- > > > > Nicolas Ribot

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

Very interesting. Unfortunately r4609 did not build http://vorboss.dl.sourceforge.net/project/jump-pilot/OpenJUMP_snapshots/OpenJUMP-20151213-r4609.log. -Jukka Rahkonen- Nicolas Ribot wrote: Hi, I made a commit (r4609) adding Spatial databases support for MySQL/MariaDB and Spatialite. Some

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

...@web.de [mailto:edgar.sol...@web.de] Lähetetty: 13. joulukuuta 2015 21:40 Vastaanottaja: jump-pilot-devel@lists.sourceforge.net Aihe: Re: [JPP-Devel] Adding other spatial databases support in OJ core Jukka, please try r4614 PLUS.. ede On 13.12.2015 19:00, Rahkonen Jukka (MML) wrote: > V

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

rce) > 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) > >

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

Hi Nicolas, I had a look but did not find an easy way to fix the problem. In SpatialDatabasesDSConnection you added a comment that it is no more necessary to subclass to PostGIS... On the other hand, - SpatialDatabasesDSConnection instantiates - SpatialDatabasesResultSetConverter which in

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

Hi Michaël, Thanks for the insight. I'm currently refactoring a bit the SpatialDatabases code. The error you pointed out showed me some problems with current code, and as you noted, I have to instantiate a correct, concrete class for each detected DSConnection. I'm finalising my todo list, but

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

Are WKB and WKT really used in Spatialite? FDO system is probably using WKB but I have never met WKT geometries. More useful might be to support GeoPackage geometries and I suppose that DB Query Plugin has good native parser for them. I suppose you are making a pure java solution because with

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

Yes good idea, I will add a test before loading a layer. Nicolas On 12 December 2015 at 20:22, Michaël Michaud wrote: > Hi Nicolas, > > Thanks for your answer. > > Just one idea about the problem Jukka has mentionned : > Maybe the query should be tested before the

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

Hi Jukka, I agree, will correct that. Nicolas On 10 December 2015 at 08:52, Rahkonen Jukka (MML) < jukka.rahko...@maanmittauslaitos.fi> wrote: > Hi, > > > > This version makes connection with out Oracle rather fast and reading data > is successful. > > > > I have one suggestion: If adding a

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

Hi Nicholas, I agree for your proposal to add MariaDB/MySQL and Spatialite codes Peppe 2015-12-10 8:52 GMT+01:00 Rahkonen Jukka (MML) < jukka.rahko...@maanmittauslaitos.fi>: > Hi, > > > > This version makes connection with out Oracle rather fast and reading data > is successful. > > > > I have

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

Hi, This version makes connection with out Oracle rather fast and reading data is successful. I have one suggestion: If adding a new layer fails because of some ORA-error it would be better not to add the layer into the OpenJUMP project. Test case: Add a layer with invalid WHERE. It seems to

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

Hi Michaël, I will look at it. Nicolas On 7 December 2015 at 23:12, Michaël Michaud wrote: > Hi > > Waw, thanks for this refactoring Nicolas ! > > Just noticed the following regression > > in the File > Execute Query plugin > If I try to query a postgis table as I

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

Hi, Oracle Spatial support has been added to OJ core (read-only). It works the same way as Postgis support: define a DB connection to Oracle and choose spatial layers from the list of found layers to display them in OJ Oracle 9i -> 12c supported (though only tested recently with Oracle 11i and

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

Hi Waw, thanks for this refactoring Nicolas ! Just noticed the following regression in the File > Execute Query plugin If I try to query a postgis table as I did before, I get the following NPE : java.lang.NullPointerException at