Create a GeoServer feature using a SQL Server 2008 View

Question

We are trying to create a feature (layer) in GeoServer on top of a view in SQL Server 2008, rather than a table. We are able to create the feature, but it won't display any data because GeoServer (JDBC) can't detect a primary key to use as the FID. To the best of my knowledge, it is not possible to make a view column appear to be a primary key, and we can't figure out how to force GeoServer to recognize a specific column as the FID.

Any help would be greatly appreciated.

Answer 1

This was apparently a known bug in the SQL 08 GeoServer driver. They have since fixed the problem, and the fixed version can be obtained by downloading one of their nightly builds. You'll need to get the latest copy of both GeoServer and the SQL Server driver.