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
