Re: [JPP-Devel] sqlite database

2020-08-24 Thread edgar . soldin
On 8/24/2020 1:23 PM, Michaud Michael wrote: > Just to precise what I fixed wrt. to what Ede is suggesting : > > I could not read spatialite files from QGis because GeometryColumn.isIndexed() > returned null for some GeometryColumnsLayouts. > > I fixed it for OGC_OGR_LAYOUT (used by QGIS when expor

Re: [JPP-Devel] sqlite database

2020-08-24 Thread Nicolas Ribot
ems to be about GeometryColumn itself returning null. > Looking at the code, I can't guarantee it is never null, but I don't know > if it is possible to produce a NPE with a normal utilisation of OpenJUMP. > > Michaël > > envoyé : 24 août 2020 à 11:46 > de : edgar.sol...@w

Re: [JPP-Devel] sqlite database

2020-08-24 Thread Michaud Michael
Hi,Just to precise what I fixed wrt. to what Ede is suggesting :I could not read spatialite files from QGis because GeometryColumn.isIndexed() returned null for some GeometryColumnsLayouts.I fixed it for OGC_OGR_LAYOUT (used by QGIS when exporting as spatialite), and for other unknown layouts (e.

Re: [JPP-Devel] sqlite database

2020-08-24 Thread edgar . soldin
you can simulate it, simply return NULL in SpatialiteDSMetadata.getGeometryColumn(String datasetName, String geoCol) for testing and you should end up with the stack. wrt. what Mike did. he wrote earlier On 8/22/2020 11:18 AM, Michaud Michael wrote: > > Finally got it : there was a bug preventi

Re: [JPP-Devel] sqlite database

2020-08-24 Thread Nicolas Ribot
Do you have a sample dataset showing the problem ? Or a way to generate such a sample ? I tested with a shapefile exported to a spatialite database with qgis 3.12 and it worked. Nicolas On Mon, 24 Aug 2020 at 10:48, Nicolas Ribot wrote: > Hello ede, > > I'll check it out. There are some todos l

Re: [JPP-Devel] sqlite database

2020-08-24 Thread Nicolas Ribot
Hello ede, I'll check it out. There are some todos left in the code, mainly in case of failure to retrieve expected information. Nicolas On Sun, 23 Aug 2020 at 13:07, wrote: > hey Nico, > > On 21.08.2020 10:52, Michaud Michael wrote: > >> >> For all my tests, I get the same error after I have

Re: [JPP-Devel] sqlite database

2020-08-23 Thread edgar . soldin
On 23.08.2020 20:25, Michaud Michael wrote: > Ede, > > Broken tests : my feeling is that FlexibleDateParser is doing too much (more > than hundred different formats). surely is. my point merely is that if testing, as in the test case June 1970 June 19 than the order dd is import

Re: [JPP-Devel] sqlite database

2020-08-23 Thread Michaud Michael
Ede,Broken tests : my feeling is that FlexibleDateParser is doing too much (more than hundred different formats). Wonder if it wouln't be better to have a parser with less formats (removing ambiguous formats like dd/MM, MM/dd, MM/yy, yy/MM etc.) and add a mechanism to use a user-defined parser wh

Re: [JPP-Devel] sqlite database

2020-08-23 Thread edgar . soldin
hey Nico, On 21.08.2020 10:52, Michaud Michael wrote: >> >> For all my tests, I get the same error after I have choosen the table and >> >> clicked on finish. The error seems related to geometry retrieval or index >> >> retrieval : >> >> >> >> java.lang.NullPointerException >> >> at >> >> >> com.v

Re: [JPP-Devel] sqlite database

2020-08-23 Thread edgar . soldin
On 22.08.2020 22:24, Michaud Michael wrote: > I reactivated the code parsing Date attributes as dates during data loading. > The > slowdown observed during saving should be moved to loading, but thanks to > Ede's > fix, FlexibleDateParser is now much more efficient (exploration to find the > righ

Re: [JPP-Devel] sqlite database

2020-08-23 Thread Giuseppe Aruta
r > (sql datatype returned for timestamp type is ok if the timestamp is stored > as integer but it is not recognized if the timestamp is stored as > character) > > Michaël > > > > > envoyé : 21 août 2020 à 10:58 > de : edgar.sol...@web.de > à : Michaud Michael ,

Re: [JPP-Devel] sqlite database

2020-08-22 Thread Michaud Michael
or handling for"beginners" ;-)yeah, NPEs should never be exposed to the user!.. cloudy but warm greetings edeMichaël>> envoyé : 21 août 2020 à 10:28>> de : edgar.sol...@web.de>> à : jump-pilot-devel@lists.sourceforge.net>> objet : Re: [JPP-Devel] sqlite database>>&

Re: [JPP-Devel] sqlite database

2020-08-21 Thread edgar . soldin
be exposed to the user!.. cloudy but warm greetings ede > Michaël > >> envoyé : 21 août 2020 à 10:28 >> de : edgar.sol...@web.de >> à : jump-pilot-devel@lists.sourceforge.net >> objet : Re: [JPP-Devel] sqlite database >> >> >> Nico, maybe Mike can provide you

Re: [JPP-Devel] sqlite database

2020-08-21 Thread Michaud Michael
Sorry, I think my test base was empty or something like thatI'll have more time tonight or tomorrow do re-test and give you more elements if it still not work.I'm quite confident it will work. It may just miss better error handling for "beginners" ;-) Michaëlenvoyé : 21 août 2020 à 10:28de : edga

Re: [JPP-Devel] sqlite database

2020-08-21 Thread edgar . soldin
Nico, maybe Mike can provide you the sqlite file he created to test against?.. ede On 21.08.2020 10:25, Nicolas Ribot wrote: > Hi, > > It was supposed to work. > I will have a look > > Nicolas > > On Thu, 20 Aug 2020 at 20:24, Michaud Michael > wrote: > >> Hi Jukka, Nicolas >> >> Do you know the

Re: [JPP-Devel] sqlite database

2020-08-21 Thread Nicolas Ribot
Hi, It was supposed to work. I will have a look Nicolas On Thu, 20 Aug 2020 at 20:24, Michaud Michael wrote: > Hi Jukka, Nicolas > > Do you know the state of sqlite in OpenJUMP ? I've tried to load a table > from a sqlite database for a few hours without success. > > I tried with OJ 1.14, 1.15

Re: [JPP-Devel] sqlite database

2020-08-20 Thread Rahkonen Jukka (MML)
and use Aihe: [JPP-Devel] sqlite database Hi Jukka, Nicolas Do you know the state of sqlite in OpenJUMP ? I've tried to load a table from a sqlite database for a few hours without success. I tried with OJ 1.14, 1.15, last snapshot, and I tried to load from a database created from a shap

[JPP-Devel] sqlite database

2020-08-20 Thread Michaud Michael
Hi Jukka, NicolasDo you know the state of sqlite in OpenJUMP ? I've tried to load a table from a sqlite database for a few hours without success.I tried with OJ 1.14, 1.15, last snapshot, and I tried to load from a database created from a shapefile with spatialite-gui or from a database created f