I've loaded a point Shapefile into DB2 Spatial Extender, with DB2 generating an INTEGER PK named "SE_ROW_ID".
While I'm able to extract WFS data with the BBOX filter, I'm not able to extract a single feature via its ID.
That is, when I try:
request=GetFeature&version=1.0.0&propertyname=*&featureversion=1&typename=sdm:STAZIONI&featureid=STAZIONI.6
There's a "translator error", and when I look up the logs, there is this line:
SELECT "SE_ROW_ID", "ID", "DESCR", "STATUS", "SE_ROW_ID", "SHAPE"..ST_AsText() FROM "ADMINISTRATOR"."STAZIONI" WHERE ("SE_ROW_ID" = '6')
...which seems to imply that GeoServer mistakes SE_ROW_ID column for a string.
Regards,
--------------------
Luca Morandini
www.lucamorandini.it
--------------------