The data imported without errors, and I was able to configure GeoServer layer to use Oracle datasource for the data. However, when I look at the data with GeoServer's "layer preview", it's just points when it should be vector shapes.

This is how my layer looks like with Postgis (and how it should be):

And this is how it looks like with Oracle:

Any ideas on what went wrong? Loading the shapefile, configuring Oracle, configuring GeoServer, or what...?

3 Answers
3

In Oracle the geometry type can be declared only as a metadata of the spatial index, evidently the import tool did not do so. Another option is to setup a geometry metadata table, please consult the geoserver documentation for details.