Good afternoon, i run some tests with GeoServer 2.1.2 and the SQL Server extension. I am able to create a new layer linked to my SQL Server store.
However, I met some issues at layer creation level: - Native SRS is not recognized even when declared in SQL server (4326) - Bounding boxes doesn' t work, only providing 0 0 -1 -1 - Feature Type Details: Not all fields are provided. In my case, i have 4 fields in SQL Server: ID (Int), Seas (nvarchar), ID_Seas(smallint) and geom(geometry) and this is what i got in geoServer: ID (Int), ID_Seas(short) and geom(byte). One of the fields has disappear (could be related to the nvarchar type) and the geometry field is not identified as such. When i tried to display it with OpenLayers, i got a "InternalError Rendering process failed" blank page. It looks really similar to http://jira.codehaus.org/browse/GEOS-4670. I am using GS 2.1.2 and SQL Server 2008 R2. Is it a bug as suggested in the jira or am i missing something? Is GS able to deal with SQL server data? Thanks in advance Sylvain -- View this message in context: http://osgeo-org.1803224.n2.nabble.com/SQL-Server-Layers-not-displayed-tp6915925p6915925.html Sent from the GeoServer - User mailing list archive at Nabble.com. ------------------------------------------------------------------------------ The demand for IT networking professionals continues to grow, and the demand for specialized networking skills is growing even more rapidly. Take a complimentary Learning@Cisco Self-Assessment and learn about Cisco certifications, training, and career opportunities. http://p.sf.net/sfu/cisco-dev2dev _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
