On Sun, Apr 5, 2015 at 8:13 PM, Suhan Dharmasuriya <[email protected]> wrote:
> Hi, > > I'm using WSO2 DSS 3.2.1 with local MySQL DB. > > Please find the data service XML configuration below[1]. > > There are two ways to retrieve data from a mysql database table as I have > tested. > > 1. Using a stored procedure created as follows in MySQL DB. > Here the query logic is inside MySQL DB as stored procedures. > CREATE PROCEDURE GetAllEmployees() SELECT FirstName , LastName , Team FROM > Employee; > Refer Query "getAllEmployeesQuery" in below configuration[1]. > > 2. Directly using the select statement inside data service configuration. > Here the query logic is embedded inside the data service configuration. > Refer Query "getAllEmployeesSQLQuery" in below configuration[1]. > > What is the recommended way/best practice to retrieve data from the above > given two alternatives? > > Or is there a better third alternative? > > [1] > <data xmlns:svns="http://org.wso2.securevault/configuration"; > name="SampleDataSource" serviceNamespace="www.wso2.org/dss"> > <description>test with or without stored procedure</description> > <config id="dss_sampleDB"> > <property name="driverClassName">com.mysql.jdbc.Driver</property> > <property name="url">jdbc:mysql://127.0.0.1:3306/dss_sample > </property> > <property name="username">root</property> > <property name="password" svns:secretAlias="yourMySQLDBPassword"/> > </config> > <query id="*getAllEmployeesQuery*" useConfig="dss_sampleDB"> > <sql>call GetAllEmployees;</sql> > <result element="Employees" rowName="Employee"> > <element column="FirstName" name="FirstNameValue" > xsdType="string"/> > <element column="LastName" name="LastNameValue" xsdType="string"/> > <element column="Team" name="TeamValue" xsdType="string"/> > </result> > </query> > <query id="*getAllEmployeesSQLQuery*" useConfig="dss_sampleDB"> > <sql>SELECT FirstName , LastName , Team FROM Employee;</sql> > <result element="Employees" rowName="Employee"> > <element column="FirstName" name="FirstNameValue" > xsdType="string"/> > <element column="LastName" name="LastNameValue" xsdType="string"/> > <element column="Team" name="TeamValue" xsdType="string"/> > </result> > </query> > <operation name="getAllEmployees"> > <description>using a stored procedure</description> > <call-query href="getAllEmployeesQuery"/> > </operation> > <operation name="getAllEmployeesSQL"> > <description>without using a stored procedure</description> > <call-query href="getAllEmployeesSQLQuery"/> > </operation> > </data> > > Thanks, > Suhan > > -- > Suhan Dharmasuriya > Software Engineer - Test Automation > > *WSO2, Inc. * > > lean . enterprise . middleware > Tel: +94 112 145345 > Mob: +94 779 869138 > Blog: http://suhan-opensource.blogspot.com/ > -- Suhan Dharmasuriya Software Engineer - Test Automation *WSO2, Inc. * lean . enterprise . middleware Tel: +94 112 145345 Mob: +94 779 869138 Blog: http://suhan-opensource.blogspot.com/
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
