All,
After two days I have hit a brick wall on this one. I run the following
SQL in 11g. In geoserver I create a layer for both the
View(SHAPE_POLY_LAYER) and the table(ORA_POLY_POINTS). If I try to
preview the View's layer or hit the server with a WFS request I get the
exception listed at the bo
,
ORA_POLY_POINTS.RECEIVED_DATETIME,
ORA_POLY_POINTS.SHAPE
FROM ORA_POLY_POINTS;
From: geoserver-users-boun...@lists.sourceforge.net
[mailto:geoserver-users-boun...@lists.sourceforge.net] On Behalf Of
Gorman, Stephen A.
Sent: Wednesday, December 15
Does anyone have an example of creating a primary key on an oracle view?
I use this
CREATE OR REPLACE FORCE VIEW person_pk_view
(GEOM, RecievedTime,NAME,IntVal,SHAPE
UNIQUE RELY DISABLE NOVALIDATE,CONSTRAINT pk_person_view PRIMARY KEY
(GEOM) RELY DISABLE NOVALIDATE)
AS
SELECT ORA_POLY_POINT