Dear all,
I’ve been struggling with Geoserver and Oracle as a datastore. In a webpage that uses OpenLayers, I’m trying to use the WFS-T features. Don’t get me wrong, WFS works great. That is, the read-only part. WFS-T works great with shape files. WFS-T works great with PostGIS. But the same page, same WFS-server (my local Geoserver) with Oracle as a datastore just inserts empty geometry columns (NULL). When making the geometry column “NOT NULL” Geoserver and/or OpenLayers just inserts a point with 0.0,0.0 as coordinates. Which is NOT where I clicked on the map (0.0,0.0 isn’t even close to being visible on screen).
So, anyone got WFS-T with an Oracle datastore working? I’m using Geoserver 1.7.5 on Tomcat 6.0.something (latest as of now), OracleNG plugin, OpenLayers 2.8 (local, not the hosted version). With Firebug I can see that the GML being sent in the POST command is CORRECT, i.e. it shows the correct coordinates. Somewhere along the line these are discarded and NULL or 0,0 (depending on the column definition) is inserted.
Change to PostGIS (with almost the same table definition, that’s the beauty of PostgreSQL) and everything works like a charm. PostGIS + Geoserver + OpenLayers is a killer combination!
Let the comments pour in……