Dear all, A user here at my agency found the problem - it was not to do with changing to a view, it was that the default style for rendering the polygons in the view 9as opposed to the base table) had not been changed from "point" to "polygon". So a simple solution in this case, happily.
Regards - Tony > -----Original Message----- > From: [email protected] [mailto:[email protected]] > Sent: Wednesday, 11 August 2010 4:54 PM > To: [email protected] > Subject: [ExternalEmail] [Geoserver-users] Problem trying to connect to > Oracle data store via a view > > Dear all, > > I have an Oracle table containing a set of multipolygons which I can > successfully connect to from GeoServer; when I look at the relevant > resource configuration table, the feature "type" as displayed is given as > "multipoloygon" and the layer/s display correctly. However there are some > columns in that table that I do not wish to publish, plus others in > ancillary tables which I wish to add, so I created an Oracle "view" which > is a join of the relevant fields (only) from 3 tables. However now when I > attempt to connect the view to GeoServer, the displayed feature "type" has > now changed from "multipolygon" to simply "geometry" and the content does > not display correctly (just small fragments of the content instead of the > full multipolygon). > > Initially I could not get anything to display at all, however I fixed this > by making a new entry in the Oracle table USER_SDO_GEOM_METADATA giving > the relevant values for the geometry column in the named view in addition > to the pre-existing entry for the same column in the base table. > > Regarding the non-geometry columns, they are coming through fine with > their feature types as defined in the base tables (i.e. Strings and > BigDecimals), it seems to be only the geometry column that is not making > it through the "view" process for some reason. > > Any suggestions as to how I can get the "view" to work as an alternative > to connecting directly to the base table would be appreciated. > > Regards > > Tony Rees > Manager, Divisional Data Centre, > CSIRO Marine and Atmospheric Research, > GPO Box 1538, > Hobart, Tasmania 7001, Australia > Ph: 0362 325318 (Int: +61 362 325318) > Fax: 0362 325000 (Int: +61 362 325000) > e-mail: [email protected] > Manager, OBIS Australia regional node, http://www.obis.org.au/ > Biodiversity informatics research activities: > http://www.cmar.csiro.au/datacentre/biodiversity.htm > Personal info: > http://www.fishbase.org/collaborators/collaboratorsummary.cfm?id=1566 > > > > -------------------------------------------------------------------------- > ---- > This SF.net email is sponsored by > > Make an app they can't live without > Enter the BlackBerry Developer Challenge > http://p.sf.net/sfu/RIM-dev2dev > _______________________________________________ > Geoserver-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/geoserver-users ------------------------------------------------------------------------------ This SF.net email is sponsored by Make an app they can't live without Enter the BlackBerry Developer Challenge http://p.sf.net/sfu/RIM-dev2dev _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
