Silvain,
I have set up Geoserver (32-bit Windows 2008) with SQL Server (64-bit SQL
Server 2008), but for performance reasons I set up a small PostGIS database
and now serve the data to Geoserver from there.
I did not have the problems that you report, but I do not use NVARCHAR at
all - only varchar. The only other thing I can think of is - have you set
up a spatial index for the GEOM field?
Regards,
David
On Fri, Oct 21, 2011 at 5:18 PM, springrider <[email protected]>wrote:
> 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
>
------------------------------------------------------------------------------
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
