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
