Saving features to SQL Server using Openlayers and geoserver -
i using sql server plugin geoserver (http://docs.geoserver.org/stable/en/user/data/database/sqlserver.html) show geometries using wms. works fine. able extract geometries vectors without trouble.
now need add retrieved vector layer , save table in sql server database. causing problems.
this of code:
savestrategy = new openlayers.strategy.save(); savestrategy.events.register("success", '', changessuccess); savestrategy.events.register("fail", '', changesfailed); function changessuccess(e) { alert('done'); } function changesfailed(e) { alert('failed'); } selectionlayer = new openlayers.layer.vector( "selectionlayer", { strategies: [new openlayers.strategy.bbox(), savestrategy] , projection: new openlayers.projection("epsg:25832") , protocol: new openlayers.protocol.wfs({ version: "1.1.0", url: "http://someserver.cloudapp.net:8181/geoserver/wfs", featureprefix: 'xxxx', featuretype: "xxxxxxxxx", featurens: "xxx.xxx/xxx", geometryname: "xxxxx" }) , displayinlayerswitcher: false }); selectcontrol.events.register("featureselected", this, function (e) { var feat = e.feature; feat.state = openlayers.state.insert; selectionlayer.addfeatures([feat]); savestrategy.save(); );
when try save newly added feature following exception in fail event of save strategy:
"java.lang.abstractmethoderror:org.geotools.jdbc.basicsqldialect.encodegeometryvalue(lcom/vividsolutions/jts/geom/geometry;iljava/lang/stringbuffer;)v org.geotools.jdbc.basicsqldialect.encodegeometryvalue(lcom/vividsolutions/jts/geom/geometry;iljava/lang/stringbuffer;)v"
i don't know try here, if has encountered before or has suggestions on issue more happy hear it.. 1:50am here , not going bed before fixed suggestions more welcome :)
Comments
Post a Comment