Hello I have geoserver 2.4 with the spatial data in a postgresql+postgis database and some additional alphanumerical data in a corporate oracle 11 database.
For some layers, I need to access data in the oracle database and join it with the spatial data to do the right representation. I'll leave an example: PostgreSQL -> table "places" (id, name, corp_code, the_geom) Oracle11 -> table "CORP_PLACES" (code, status) I have both databases set as datasources and both tables published. But for the WMS service of "places" I need to style them more or less like this: if status is 1, then the symbol must be red; if status is blue, then the symbol must be green. How can I combine the data from the two different data sources to publish it together? Thank you ------------------------------------------------------------------------------ Flow-based real-time traffic analytics software. Cisco certified tool. Monitor traffic, SLAs, QoS, Medianet, WAAS etc. with NetFlow Analyzer Customize your own dashboards, set traffic alerts and generate reports. Network behavioral analysis & security monitoring. All-in-one tool. http://pubads.g.doubleclick.net/gampad/clk?id=126839071&iu=/4140/ostg.clktrk _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
