Layers from SQL Server not loading in geoserver -


i've loaded shapefile sql server using ogr2ogr , can connect database/layer , create store , publish layer, when try preview layer openlayers option returns suggests problem srs:

<?xml version="1.0" encoding="utf-8" standalone="no"?><!doctype serviceexceptionreport system "http://localhost:8080/geoserver/schemas/wms/1.1.1/wms_exception_1_1_1.dtd">       <serviceexceptionreport version="1.1.1" >   <serviceexception>   java.io.ioexception: no such resource: generic.sld no such resource: generic.sld </serviceexception></serviceexceptionreport> 

following answer here: geoserver - connect sql server 2008 express , fetch data have updated geometry in sql using:

update xxx set ogr_geometry =  geometry::stgeomfromtext(ogr_geometry.stastext(), 27700)  

and reloaded layer

...but same error. can see i'm doing wrong please?

it seems geoserver unable determine sort of geometry in table , attempting use generic style display them, reason generic.sld missing styles (possibly upgrade issue?). solution go layer publishing tab , change default style 1 of point, line or polygon depending on geometry type of table. or can create , apply style of own.


Comments