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