How To?: Upload MDSYS SDO_GEOMETRY spatial Type Data from .siard into MySQL

ibbenz commented 2 years ago

I want to upload the content of a SIARD-File, containing spatial data, to a MySQL database. The SIARD-File contains a MDSYS SDO_GEOMETRY Datatype, which is a spatial datatype in ORACLE databases. MySQL offers a related type called GEOGRAPHY. A direct upload of a SIARD containing MDSYS-data into MySQL via Siard Suite results in an error. Which is the SiardSuite configuration or workaround to upload the MDSYS spatial data into a MySQL DB from a SIARD-file?

The SIARD-File: 0_4-6_oe_Northwind_complex_V02.zip s

The Error Message: Archive upload failed ( java.lang.NullPointerException: Cannot invoke "ch.admin.bar.siard2.api.MetaType.getParentMetaSchema()" because "mt" is null)! Partial

The image of the error message Oracle_Geo_Location_Error

Information about Spatial Types: https://docs.oracle.com/database/121/SPATL/sdo_geometry-object-type.htm#SPATL489 https://social.msdn.microsoft.com/Forums/sqlserver/en-US/4ba9c5b5-9c33-43d6-ad72-62418bcd6f77/loading-oracle-geomerty-column-data-into-sql-server-using-ssis?forum=sqlintegrationservice

mburri commented 2 years ago

We have to look into this - as far as I can remember, MySQL had some changes concerning GeoSpatial Data Types - but I have to check.

Meanwhile - what version of mysql are you using?

ibbenz commented 2 years ago

Thank you, that you are looking into it. I use MySQL Workbench 8.0.

sfa-siard / SiardGui

How To?: Upload MDSYS SDO_GEOMETRY spatial Type Data from .siard into MySQL #31