Well I think i`ll try publishing the view and cant use the new sql layer thing because I am going to do this on GS 1.7.7 regards Imran
On Thu, Apr 21, 2011 at 5:47 PM, Andrea Aime <[email protected]> wrote: > On Thu, Apr 21, 2011 at 1:02 PM, Imran Rajjad <[email protected]> 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 > > ------------------------------------------------------- > -- I.R ------------------------------------------------------------------------------ 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 [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
