Hi list,
When I create a new layer based on a table in a sql server database, all properties are shown under “Feature Type Details” except for the table column which is marked as primary key. The definition of this PK column looks like: [MI_PRINX] [int] IDENTITY(1,1) NOT NULL
When I create a view based on this table (selecting all columns in the table) and then create a new layer based on this view, I get all columns (including the primary key one) in the “Feature Type Details” section.
Experiencing this behavior in geoserver 2.4.0, 2.5.2 and 2.6.1 using both Microsoft’s jdbc drivers sqljdbc4-4.0.2206.100 and sqljdbc41-4.1.5605.100.
Any ideas? A limitation on the name of a PK column?
Kind regards,
Roel De Nijs
Senior Java Developer