No need for it thus far; however I do note that the next version of WFS spec (i.e. WFS 2.0) does have the ability to publish predefined queries; which look tailor made to be backed by stored procedures.
–
Jody Garnett
On Wednesday, 8 February 2012 at 7:04 AM, George, Curtis D (US SSA) wrote:
Hello all,
I was wondering why the current geoserver jdbc plugins do not support calling stored procedures. We currently use geoserver and have a scalability problem that our database engineer is convinced can be solved by calling a store procedure. Our scalability problem is caused in part by an oracle bug which has driven our physical table layout to a certain way (inefficient for use with geoserver). Our database engineer says he can work around the oracle bug by calling a stored procedure that he wrote, which seems to require us writing a customized jdbc plugin to allow this in geoserver. Before I ventured any further down this path I wanted to see if anyone else had any thoughts on this, of if it was already attempted by anyone already.
Thanks,
Curtis
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel