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……
Hi ! Did you by chance resolve this issue ? I’m currently facing the exact same problem !
No, I did not (back then). I’m sure the current versions will work?
Hi! I am facing the same problem trying to integrate OpenLayers 3 + Oracle + GeoServer.I am trying to insert/update feature and geometry through openLayers Draw Interaction.Geometry in Oracle database (sdo_geometry) is always null when i tried to insert a geometry through WFS transaction using Openlayers.
It’s been a long time since I posted this (9 years ago), and my OpenLayers adventures deviated from Oracle to using PostGIS more. That being said, I think I solved it back then by switching to a vector layer instead of a WFS layer. Obviously, the WFS layer was (is?) bugged when I posted this and the vector layer has the same functionality although you need to specify more if I recall correctly.
Hope that helps!