What's the best approach to import a user uploaded shapefile into an Oracle DB? The dbf, shx and shp files of the Shapefile come in a ZIP Archive.
Currently, we unzip programatically and then parse the dbf, shx and shp files manually using custom Java and the GeoTools library. From this we build SQL Strings to create the table and insert the values. This works, but seems cumbersome given the complexity of shapefiles.
I thought that there must be an easier way of just using some kind of Java library to which we pass the shapefile. The library should just take care of all the shapefile import stuff.
However, I do not find any GeoTools method for simply importing a Shapefile into a Oracle DB. I only found this Oracle Java Program, but no tutorials on how to use this as part of a java based web portal.