Unknown macro: {next_previous_link3}
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 13 Current »

Introduction

This sample demonstrates how to expose some data stored in a database created via WSO2 storage server.

Prerequisites

Creating a data service

  1. Create a Database, a privilege template and a database user  using WSO2SS and attach the created user to the database,
  2. Use WSO2 Developer Studio and create a data service using the following values.

    FieldExampleDescription
    Driver Classcom.mysql.jdbc.DriverThis is the driver class of the database created via WSO2 SS.
    JDBC URLjdbc:mysql://localhost:3306/wso2DB_wso2_comThis is the url received from WSO2 SS after successful creation of a database.
    User Nameuser1_aJLNWWiSThe user name of a user created in WSO2 SS, and attached to the database created.
    Passworduser1The password of the above user created in WSO2 SS, and attached to the database created.

The sample data service descriptor would be as follows.

<data enableBoxcarring="true" name="RDBMSSample" serviceNamespace="http://ws.wso2.org/dataservice/samples/rdbms_sample">   
	<config id="default">
	  // add the database driver of the relevant db instance created.
      <property name="org.wso2.ws.dataservice.driver">com.mysql.jdbc.Driver</property>
	  //add the database url recieved from Storage server.
      <property name="org.wso2.ws.dataservice.protocol">jdbc:mysql://localhost:3306/wso2DB_wso2_com</property>
	  //add a user to connecto to the database, which is already attached to the afore mentioned database via Storage Server.
      <property name="org.wso2.ws.dataservice.user">user1_aJLNWWiS</property>
	  //use the aforementioned users password. 	
      <property name="org.wso2.ws.dataservice.password">user1</property>
      <property name="org.wso2.ws.dataservice.minpoolsize">1</property>
      <property name="org.wso2.ws.dataservice.maxpoolsize">10</property>
      <property name="org.wso2.ws.dataservice.autocommit">false</property>
      <property name="org.wso2.ws.dataservice.validation_query"/>
   </config>

   //The sample Query.
   <query id="customersInBostonSQL" useConfig="default">
      <sql>select  * from Customers where city = 'Boston' and country = 'USA'</sql>
      <result element="customers" rowName="customer">
         <element column="customerName" name="customer-name" xsdType="string"/>
         <element column="contactLastName" name="contact-last-name" xsdType="string"/>
         <element column="contactFirstName" name="contact-first-name" xsdType="string"/>
         <element column="phone" name="phone" xsdType="string"/>
         <element column="city" name="city" xsdType="string"/>
         <element column="country" name="country" xsdType="string"/>
      </result>
   </query>

	//The sample dataservice.
	<operation name="customersInBoston">
      <call-query href="customersInBostonSQL"/>
   </operation>
</data>

 

Executing the sample

  1. Group the created data service with a Carbon Application Project and create the Carbon Application Archive [CAR] and deploy in to the WSO2 Data Services Server.

 

  • No labels