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
> [email protected]
> (mailto:[email protected])
> https://lists.sourceforge.net/lists/listinfo/geoserver-devel
>
>
------------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
