Data load from GML to Oracle Spatial using Java SDO API
Hello folks,
I am trying to load spatial data contained in a GML file into an Oracle Spatial DB. What approach would you recomend?
I intend to use the Java SDO API. For this I'll have to implement a GML to SDO adapter first (as per the examples for using the Java SDO API, the shapefile adpater) and then use the example as a guidline to load the data.
Another possibility perhaps is to convert the GML file into a (ESRI) shapefile and use the shp2sdo utility to convert the existing file and then use the SQL*Loader to do the actual load into the Oracle Spatial DB.
Please, let me know what you think it would be the easiest and fastest way to do this. We'd like to use Java, but if it is not easy to load data to an Oracle Spatial db with it, then we'll use whatever tool/method available. Thank you in advance.
Georgi