[Wsf-general] Data service - Stored Procedures

[James Clark]

On Thu, 2007-03-01 at 06:36 -0500, Diluka Moratuwage wrote:
> Hi all,
> 
>   When considering the extensibility of the dataservice, we can
> also think of including the support for stored procedures. If
> we use stored procedurs, for complex queries, as well as for services
> that include, multiple types of sql statements it would become a
> good solution.

Can't queries and other SQL statements call out to stored procedures?

I'm not seeing that we need to do anything special in the config file to
support stored procedures.

>   Also it will remove the complication of writing complex queries
> in the config file

Not always, because the person writing the config file might not be
authorized to add stored procedures to the database.

> But if we use,
> generic way to access the database, then its neccessary to mention
> about the database system to use.

I'm not sure what you mean by "generic" here.  Are you thinking of how
Axis2/C will decide whether to use MySQL or PostgreSQL when it's linked
against both of them?  I would handle this by having a property
"axis2c.driver" with properties "mysql" or "postgresql".

James