[Wsf-general] Data service - Stored Procedures

[Asankha C. Perera]

Diluka

Stored procedures are not portable, and since the database is not 
complicated or huge, the advantages may soon be outweighed

asankha


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.
>
>   And also it will solve some problems regarding authorization. The
> dataservice owner can only execute stored procedures, which are
> allowed by the database owner.
>
>   Also it will remove the complication of writing complex queries
> in the config file, which might be hard to extract. But we have
> to implement the same difficult queries in stored procedures.
>
>   Then the config file writer's task becomes very flexible, as an
> example, suppose their is a stored procedure called getUserInfo(id),
> then, the config file writer can specify his operation as,
>
>  <operation name = "getUserInfo">
>    <!-- PARAMETER LIST -->
>  </operation>
>
>   I'm little bit, confused regarding the problem of the connection
> section of the config file. As shown in james mail earliar, we can
> specify the connectivity information in different ways. If we need
> to use a driver, such as jdbc or odbc, then its ok. But if we use,
> generic way to access the database, then its neccessary to mention
> about the database system to use.
>
>  Suggestions please....
>
> Thanks,
> Diluka.
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> _______________________________________________
> Wsf-general mailing list
> Wsf-general at wso2.org
> http://wso2.org/cgi-bin/mailman/listinfo/wsf-general
>
>