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
[Congres publieke ruimte]<http://www.congrespubliekeruimte.be>
________________________________

Volg Aquafin op Facebook<https://www.facebook.com/AquafinNV> | 
Twitter<https://twitter.com/aquafinnv> | 
YouTube<http://www.youtube.com/channel/UCk_4P5BJ-MtEEDCkCsR_KqQ?feature=mhee> | 
LinkedIN<http://www.linkedin.com/company/aquafin/products>

Disclaimer: zie www.aquafin.be<http://www.aquafin.be>   P Denk aan het milieu. 
Druk deze mail niet onnodig af.
------------------------------------------------------------------------------
New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
GigeNET is offering a free month of service with a new server in Ashburn.
Choose from 2 high performing configs, both with 100TB of bandwidth.
Higher redundancy.Lower latency.Increased capacity.Completely compliant.
http://p.sf.net/sfu/gigenet
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Reply via email to