...
| Code Block | ||
|---|---|---|
| ||
<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">devuser1<>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> |
...