Dear all,<\/p>\n
I’ve been struggling with Geoserver<\/a> and Oracle as a datastore. In a webpage that uses OpenLayers<\/a>, 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<\/a>. 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).<\/p>\n 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<\/em>, 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.<\/p>\n Change to PostGIS (with almost the same table definition, that’s the beauty of PostgreSQL<\/a>) and everything works like a charm. PostGIS + Geoserver + OpenLayers is a killer combination!<\/p>\n Let the comments pour in……<\/p>\n","protected":false},"excerpt":{"rendered":" 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 […]<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[58,59,70,132],"class_list":["post-890","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-geoserver","tag-gis","tag-openlayers","tag-oracle","category-1-id","post-seq-1","post-parity-odd","meta-position-corners","fix"],"_links":{"self":[{"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/posts\/890","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/comments?post=890"}],"version-history":[{"count":0,"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/posts\/890\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/media?parent=890"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/categories?post=890"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/tags?post=890"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}