Hi, I commited support for SQLite GeoPackage specifications. 2D objects stored in gpkg formats are available as Datasources. (3D objects are not yet supported by JTS WKBReader, AFAIU)
Date and Datetime SQLite database types are forced to String types in OJ (same behaviour as DB Query) After some readings, Joda (http://www.joda.org/joda-time/) could be a solution to try a date parsing instead of forcing a String Java type. I used some DB Query methods to convert blobs into geometry objects. Now DBQuery is integrated to OJ Plus, could it be possible to expose needed methods from DBQuery and use them directly in SpatialDatabases code ? Currently, code is duplicated, which is not very clean. Nicolas On 27 December 2015 at 14:14, Nicolas Ribot <nicolas.ri...@gmail.com> wrote: > Hi, I commited some corrections for MySQL/MariaDB: > > • OGC geometry_columns table is now used if available (OGR, for instance, > creates OGC metadata tables when loading into MySQL) > > • ResultSetConverter was changed to cope with MySQL binary format, that > stores SRID information in the first 4 bytes of the blob. It rises a > problem: how to correctly detect OGC WKB format from native MySQL format ? > > Larry, DBQuery assumes the MySQL binary format stores 4 "0" bytes at the > beginning, which is the case only when a geometry is built with no SRID or > SRID set to 0: > > select st_geomfromtext('POINT(0 0)'); > -- 00 00 00 00 01 01 ... > > select st_geomfromtext('POINT(0 0)', 1); > -- 01 00 00 00 01 01 ... > > select st_geomfromtext('POINT(0 0)', 12345); > -- 39 30 00 00 01 01 ... > > > Nicolas > > > On 23 December 2015 at 16:34, Nicolas Ribot <nicolas.ri...@gmail.com> > wrote: > >> Hi, >> >> There are some problems with mariaDB and MySQL spatial types: I'm having >> a look at them. >> >> Nicolas >> >> On 23 December 2015 at 11:43, Nicolas Ribot <nicolas.ri...@gmail.com> >> wrote: >> >>> Hi, >>> >>> Sorry, was not available for some days. >>> Great devs on Spatial DB ! >>> >>> I will have some tests with both db's, now I have MySQL on OSX and >>> MariaDB on Windows VM. >>> >>> Nicolas >>> >>> On 23 December 2015 at 10:48, <edgar.sol...@web.de> wrote: >>> >>>> hey Jukka, Nico, >>>> >>>> there are now two MySQL datastores utilizing either the mysql or the >>>> mariadb driver. can one of you check quickly if that still works out. been >>>> careful, but who knows. >>>> >>>> PLUS contains all uptodate jdbc's now except oracle. >>>> >>>> thx.. ede >>>> >>>> >>>> ------------------------------------------------------------------------------ >>>> _______________________________________________ >>>> Jump-pilot-devel mailing list >>>> Jump-pilot-devel@lists.sourceforge.net >>>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >>>> >>> >>> >> >
------------------------------------------------------------------------------
_______________________________________________ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
