Further investigation seems to show this is only a problem with 11.2 and not with 11.1 if that helps anyone.
Ian On 15 August 2011 17:07, Ian Turton <[email protected]> wrote: > I'm trying to add an Oracle view (Oracle 11g) to GeoServer 2.1.1 but > the columns of the view are being replicated multiple times - the > query that GeoServer is running is: > > SELECT * FROM (SELECT > SYSTEMCODENUMBER,SHORTDESCRIPTION,LONGDESCRIPTION,DATASOURCE_TYPEID,NORTHING,EASTING,GEOMETRY > as > GEOMETRY,NETWORKPATHREFERENCE,TRANSPORTLINKREFERENCE,TYPEID,LINKDISTANCE,CREATIONDATE,DELETIONDATE,QUALITYSTATEMENTID,DISPLAYOPTION,STR_STATUS,SYSTEMCODENUMBER,SHORTDESCRIPTION,LONGDESCRIPTION,DATASOURCE_TYPEID,NORTHING,EASTING,GEOMETRY > as > GEOMETRY,NETWORKPATHREFERENCE,TRANSPORTLINKREFERENCE,TYPEID,LINKDISTANCE,CREATIONDATE,DELETIONDATE,QUALITYSTATEMENTID,DISPLAYOPTION,STR_STATUS,SYSTEMCODENUMBER,SHORTDESCRIPTION,LONGDESCRIPTION,DATASOURCE_TYPEID,NORTHING,EASTING,GEOMETRY > as > GEOMETRY,NETWORKPATHREFERENCE,TRANSPORTLINKREFERENCE,TYPEID,LINKDISTANCE,CREATIONDATE,DELETIONDATE,QUALITYSTATEMENTID,DISPLAYOPTION,STR_STATUS,SYSTEMCODENUMBER,SHORTDESCRIPTION,LONGDESCRIPTION,DATASOURCE_TYPEID,NORTHING,EASTING,GEOMETRY > as > GEOMETRY,NETWORKPATHREFERENCE,TRANSPORTLINKREFERENCE,TYPEID,LINKDISTANCE,CREATIONDATE,DELETIONDATE,QUALITYSTATEMENTID,DISPLAYOPTION,STR_STATUS,SYSTEMCODENUMBER,SHORTDESCRIPTION,LONGDESCRIPTION,DATASOURCE_TYPEID,NORTHING,EASTING,GEOMETRY > as > GEOMETRY,NETWORKPATHREFERENCE,TRANSPORTLINKREFERENCE,TYPEID,LINKDISTANCE,CREATIONDATE,DELETIONDATE,QUALITYSTATEMENTID,DISPLAYOPTION,STR_STATUS,SYSTEMCODENUMBER,SHORTDESCRIPTION,LONGDESCRIPTION,DATASOURCE_TYPEID,NORTHING,EASTING,GEOMETRY > as > GEOMETRY,NETWORKPATHREFERENCE,TRANSPORTLINKREFERENCE,TYPEID,LINKDISTANCE,CREATIONDATE,DELETIONDATE,QUALITYSTATEMENTID,DISPLAYOPTION,STR_STATUS,SYSTEMCODENUMBER,SHORTDESCRIPTION,LONGDESCRIPTION,DATASOURCE_TYPEID,NORTHING,EASTING,GEOMETRY > as > GEOMETRY,NETWORKPATHREFERENCE,TRANSPORTLINKREFERENCE,TYPEID,LINKDISTANCE,CREATIONDATE,DELETIONDATE,QUALITYSTATEMENTID,DISPLAYOPTION,STR_STATUS,SYSTEMCODENUMBER,SHORTDESCRIPTION,LONGDESCRIPTION,DATASOURCE_TYPEID,NORTHING,EASTING,GEOMETRY > as > GEOMETRY,NETWORKPATHREFERENCE,TRANSPORTLINKREFERENCE,TYPEID,LINKDISTANCE,CREATIONDATE,DELETIONDATE,QUALITYSTATEMENTID,DISPLAYOPTION,STR_STATUS,SYSTEMCODENUMBER,SHORTDESCRIPTION,LONGDESCRIPTION,DATASOURCE_TYPEID,NORTHING,EASTING,GEOMETRY > as > GEOMETRY,NETWORKPATHREFERENCE,TRANSPORTLINKREFERENCE,TYPEID,LINKDISTANCE,CREATIONDATE,DELETIONDATE,QUALITYSTATEMENTID,DISPLAYOPTION,STR_STATUS,SYSTEMCODENUMBER,SHORTDESCRIPTION,LONGDESCRIPTION,DATASOURCE_TYPEID,NORTHING,EASTING,GEOMETRY > as > GEOMETRY,NETWORKPATHREFERENCE,TRANSPORTLINKREFERENCE,TYPEID,LINKDISTANCE,CREATIONDATE,DELETIONDATE,QUALITYSTATEMENTID,DISPLAYOPTION,STR_STATUS,SYSTEMCODENUMBER,SHORTDESCRIPTION,LONGDESCRIPTION,DATASOURCE_TYPEID,NORTHING,EASTING,GEOMETRY > as > GEOMETRY,NETWORKPATHREFERENCE,TRANSPORTLINKREFERENCE,TYPEID,LINKDISTANCE,CREATIONDATE,DELETIONDATE,QUALITYSTATEMENTID,DISPLAYOPTION,STR_STATUS,SYSTEMCODENUMBER,SHORTDESCRIPTION,LONGDESCRIPTION,DATASOURCE_TYPEID,NORTHING,EASTING,GEOMETRY > as > GEOMETRY,NETWORKPATHREFERENCE,TRANSPORTLINKREFERENCE,TYPEID,LINKDISTANCE,CREATIONDATE,DELETIONDATE,QUALITYSTATEMENTID,DISPLAYOPTION,STR_STATUS,SYSTEMCODENUMBER,SHORTDESCRIPTION,LONGDESCRIPTION,DATASOURCE_TYPEID,NORTHING,EASTING,GEOMETRY > as > GEOMETRY,NETWORKPATHREFERENCE,TRANSPORTLINKREFERENCE,TYPEID,LINKDISTANCE,CREATIONDATE,DELETIONDATE,QUALITYSTATEMENTID,DISPLAYOPTION,STR_STATUS,SYSTEMCODENUMBER,SHORTDESCRIPTION,LONGDESCRIPTION,DATASOURCE_TYPEID,NORTHING,EASTING,GEOMETRY > as > GEOMETRY,NETWORKPATHREFERENCE,TRANSPORTLINKREFERENCE,TYPEID,LINKDISTANCE,CREATIONDATE,DELETIONDATE,QUALITYSTATEMENTID,DISPLAYOPTION,STR_STATUS,SYSTEMCODENUMBER,SHORTDESCRIPTION,LONGDESCRIPTION,DATASOURCE_TYPEID,NORTHING,EASTING,GEOMETRY > as > GEOMETRY,NETWORKPATHREFERENCE,TRANSPORTLINKREFERENCE,TYPEID,LINKDISTANCE,CREATIONDATE,DELETIONDATE,QUALITYSTATEMENTID,DISPLAYOPTION,STR_STATUS,SYSTEMCODENUMBER,SHORTDESCRIPTION,LONGDESCRIPTION,DATASOURCE_TYPEID,NORTHING,EASTING,GEOMETRY > as > GEOMETRY,NETWORKPATHREFERENCE,TRANSPORTLINKREFERENCE,TYPEID,LINKDISTANCE,CREATIONDATE,DELETIONDATE,QUALITYSTATEMENTID,DISPLAYOPTION,STR_STATUS > FROM DETECTOR_DEFINITION WHERE SDO_RELATE(GEOMETRY, ?, > 'mask=anyinteract querytype=WINDOW') = 'TRUE' ) WHERE ROWNUM <= 50 > > which is clearly wrong. > The view is defined as: > > CREATE OR REPLACE FORCE VIEW "ADMINUTMC"."DETECTOR_DEFINITION" ( > "SYSTEMCODENUMBER", "SHORTDESCRIPTION", "LONGDESCRIPTION", > "DATASOURCE_TYPEID", "NORTHING", "EASTING", "GEOMETRY", > "NETWORKPATHREFERENCE", "TRANSPORTLINKREFERENCE", "TYPEID", "LINKDISTANCE", > "CREATIONDATE", "DELETIONDATE", "QUALITYSTATEMENTID", "DISPLAYOPTION", > "STR_STATUS", primary key(SYSTEMCODENUMBER)RELY DISABLE NOVALIDATE) > AS > SELECT > SYSTEMCODENUMBER, > SHORTDESCRIPTION, > LONGDESCRIPTION, > DATASOURCE_TYPEID, > NORTHING, > EASTING, > GEOMETRY, > NETWORKPATHREFERENCE, > TRANSPORTLINKREFERENCE, > TYPEID, > LINKDISTANCE, > CREATIONDATE, > DELETIONDATE, > QUALITYSTATEMENTID, > DISPLAYOPTION, > STR_STATUS > FROM > ADMINUTMC.TBLDETECTORDEFINITION; > > Has anyone seen anything liek this before? > > Ian > > -- > Ian Turton > -- Ian Turton ------------------------------------------------------------------------------ uberSVN's rich system and user administration capabilities and model configuration take the hassle out of deploying and managing Subversion and the tools developers use with it. Learn more about uberSVN and get a free download at: http://p.sf.net/sfu/wandisco-dev2dev _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
