On Thu, Apr 21, 2011 at 1:02 PM, Imran Rajjad <raj...@gmail.com> wrote: > Hi list, > > Is it possible to use an attribute field from a non-spatial oracle > table and use it for a published datastore which can be an oracle > spatial table or a shapefile? In case of oracle, both table can be > joined using a foreign key, can we point the sld to the joined table`s > attribute feild? Can anybody point me towards any possible work > arounds for this'?
Joining is not supported, would be a nice addition actually, but it requires coding a new kind of data store (one that does joins in memory). The closes thing is to import all your data in a single database and then create a view and publish it or use the new "sql layers" feature to write the joining query directly in GeoServer 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 ------------------------------------------------------- ------------------------------------------------------------------------------ Benefiting from Server Virtualization: Beyond Initial Workload Consolidation -- Increasing the use of server virtualization is a top priority.Virtualization can reduce costs, simplify management, and improve application availability and disaster protection. Learn more about boosting the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev _______________________________________________ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users