just was browsing the sqlite jdbc sources and thought, how do they deal with
date/time/timestamps, if at all. well what they do is this
JDBC3ResultSet.getDate()
https://github.com/xerial/sqlite-jdbc/blob/master/src/main/java/org/sqlite/jdbc3/JDBC3ResultSet.java#L524
you may also search for getTi
Geopackage with 5.4 million polygonz geometries opens with
OpenJUMP-20200818-r6382-PLUS in 49 seconds. There is a trick: the extent of the
table is not recognized right so adding table into a new empty project does not
show anything and zoom to layer does not work as it should. Digitize one
fea
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
On 20.08.2020 19:08, Michaud Michael wrote:
> Hi,
>
> Big thanks for this work Eric, seems to be very well documented.
yup, impressively well documented!
> I think we should take advantage of this work and proceed to a more definitive
> migration without waiting too much.
true. but we should sti
- **Milestone**: undecided --> final_OJ
---
** [bugs:#497] Shapefile export slowed down because of FlexibleDateParser**
**Status:** open
**Milestone:** final_OJ
**Created:** Mon Aug 17, 2020 11:47 AM UTC by michael michaud
**Last Updated:** Thu Aug 20, 2020 05:55 PM UTC
**Owner:** michael mich
- **Milestone**: OJ-1.16 --> undecided
---
** [bugs:#497] Shapefile export slowed down because of FlexibleDateParser**
**Status:** open
**Milestone:** undecided
**Created:** Mon Aug 17, 2020 11:47 AM UTC by michael michaud
**Last Updated:** Thu Aug 20, 2020 05:47 PM UTC
**Owner:** michael mich
- **Milestone**: --> OJ 1.16
---
** [bugs:#497] Shapefile export slowed down because of FlexibleDateParser**
**Status:** open
**Milestone:** OJ 1.16
**Created:** Mon Aug 17, 2020 11:47 AM UTC by michael michaud
**Last Updated:** Thu Aug 20, 2020 08:21 AM UTC
**Owner:** michael michaud
Expor
Hi,Big thanks for this work Eric, seems to be very well documented.I think we should take advantage of this work and proceed to a more definitive migration without waiting too much.What about listing the tickets or tasks we want to fix before migration (if possible something we can achieve within
Just added the documentation to update JTS from 1.14 to 1.17.
Eric
On 20/08/2020 13:42, Eric wrote:
Hi,
The first part of this documentation is now online:
https://github.com/openjump-gis/openjump-migration-doc
It focuses only on the migration from SVN to Git.
Before migrating, the reading
Hi,
The first part of this documentation is now online:
https://github.com/openjump-gis/openjump-migration-doc
It focuses only on the migration from SVN to Git.
Before migrating, the reading of this article could be useful as it
contains some good practice tips:
https://docs.microsoft.com/e
a little off but still on topic :)
https://stackoverflow.com/questions/2305973/java-util-date-vs-java-sql-date
interesting read.. ede
---
** [bugs:#497] Shapefile export slowed down because of FlexibleDateParser**
**Status:** open
**Created:** Mon Aug 17, 2020 11:47 AM UTC by michael michaud
*
On 20.08.2020 10:21, Jukka Rahkonen wrote:
> Handling dates in SQLite generally is somehow special, see for example
> https://www.sqlitetutorial.net/sqlite-date/.
> I believe that in SpatiaLite the dates/times are stored either as strings or
> Julian numbers it is up to client application to know
On 20.08.2020 09:19, michael michaud wrote:
> OK, changed it. I'm not a spatialite user, but I'll try to configure a
> database to do more tests.
> I also upgraded postgresql and sqlite jdbc drivers.
ok. not sure that i like the FlexParser fallback though. this can get really
slow. as you notice
Handling dates in SQLite generally is somehow special, see for example
https://www.sqlitetutorial.net/sqlite-date/.
I believe that in SpatiaLite the dates/times are stored either as strings or
Julian numbers it is up to client application to know how to parse the data.
GeoPackage is using DATE a
OK, changed it. I'm not a spatialite user, but I'll try to configure a database
to do more tests.
I also upgraded postgresql and sqlite jdbc drivers.
As far as I understood, the spatialite database has no date type and getting
date or timestamp from it is still very hazardeous
(https://github.c
Revision: 6384
http://sourceforge.net/p/jump-pilot/code/6384
Author: michaudm
Date: 2020-08-20 07:17:48 + (Thu, 20 Aug 2020)
Log Message:
---
Revert the fallback to FlexibleDateParser if rs.getTimestamp fails (useful for
sqlite ?)
Modified Paths:
--
cor
Revision: 6383
http://sourceforge.net/p/jump-pilot/code/6383
Author: michaudm
Date: 2020-08-20 06:59:27 + (Thu, 20 Aug 2020)
Log Message:
---
Read dates as Date from database, update postgresql and sqlite jdbc drivers
Modified Paths:
--
core/trunk/Change
17 matches
Mail list logo
