Hello,
I am interested in learning more about the the interaction between Geoserver and Oracle. I am currently the developer of an application that marries the thematic mapping capabilities of Geoserver with an Oracle Spatial database, but because of some recent requests I am interested in making my application more flexible. My question is this:
Is it currently possible for Geoserver to create a featuretype using an Oracle stored procedure rather than a table or view? If so, how can a parameter be passed from a WMS request through to the stored procedure to facilitate the call?
Thanks in advance for any advice.
Nathan P. Den Herder
Sr. Research Analyst
Fannie Mae - Credit Research
Washington, DC
Unfortunately this is not possible. I am not even sure what it would look like... what does your stored procedure output? A table like structure or a row set?
Den Herder, Nate P wrote:
Hello,
I am interested in learning more about the the interaction between Geoserver and Oracle. I am currently the developer of an application that marries the thematic mapping capabilities of Geoserver with an Oracle Spatial database, but because of some recent requests I am interested in making my application more flexible. My question is this:
Is it currently possible for Geoserver to create a featuretype using an Oracle stored procedure rather than a table or view? If so, how can a parameter be passed from a WMS request through to the stored procedure to facilitate the call?
Thanks in advance for any advice.
Sr. Research Analyst
Fannie Mae - Credit Research
Washington, DC
------------------------------------------------------------------------
------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing server and web deployment.
http://p.sf.net/sfu/businessobjects
------------------------------------------------------------------------
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.