On Fri, Jun 3, 2011 at 5:27 AM, Harikumar Reddy <harik....@gmail.com> wrote: > Hi, > > We configured SQL views (oracle 11g r2) in geoserver for single geometry > type (like continents, countries, states, districts, cities, villages etc. > are present in one table but views configured for different admin type > layers with SQL views) and working fine till now. > > I think it is possible to strore multiple geometry types into a oracle > spatial table and access through views. It stores geometry with clear > differentiation (like 2001, 2002, 2003 for points, lines & polygons). If > there is no future insertions/updates, i hope it may be OK. > If updates are there, then considering separate table for different geometry > types.
Oracle also allows to build updatable views, provided the query that selects the contents of the view is simple enough. But you have to create a database level view instead of using the GeoServer 2.1 ability to create layers out of raw sql Cheers Andrea -- ------------------------------------------------------- Ing. Andrea Aime GeoSolutions S.A.S. Tech lead Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 962313 http://www.geo-solutions.it http://geo-solutions.blogspot.com/ http://www.youtube.com/user/GeoSolutionsIT http://www.linkedin.com/in/andreaaime http://twitter.com/geowolf ------------------------------------------------------- ------------------------------------------------------------------------------ Simplify data backup and recovery for your virtual environment with vRanger. Installation's a snap, and flexible recovery options mean your data is safe, secure and there when you need it. Discover what all the cheering's about. Get your free trial download today. http://p.sf.net/sfu/quest-dev2dev2 _______________________________________________ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
