+1 , having this will show the real power of data services with the
ability of the query spanning different data sources.
Thanks
Sandakith
Afkham Azeez wrote:
Since there haven't been any responses to this, I'm going to make this
a vote.
Here is my +1 for having this in the next release.
--
Thanks
Azeez
Afkham Azeez wrote:
The real power and usefulness of data services comes from the ability
to combine and query across multiple data sources. To do this in pure
Java code may require 100s of lines of coding. Data services enables
us to do this in a declarative manner.
We can support multiple data sources by slightly changing our current
spec. Let me illustrate this with an example.
e.g.
<config name="ds1">
<property
name="org.wso2.ws.dataservice.driver">com.mysql.jdbc.Driver</property>
<property
name="org.wso2.ws.dataservice.protocol">jdbc:mysql://localhost:3306/SAMPLE1_DB</property>
<property name="org.wso2.ws.dataservice.user">root</property>
<property name="org.wso2.ws.dataservice.password"></property>
</config>
<config name="ds2">
<property
name="org.wso2.ws.dataservice.driver">com.mysql.jdbc.Driver</property>
<property
name="org.wso2.ws.dataservice.protocol">jdbc:mysql://localhost:3306/SAMPLE2_DB</property>
<property name="org.wso2.ws.dataservice.user">root</property>
<property name="org.wso2.ws.dataservice.password"></property>
</config>
<query id="customersInBostonSQL">
<sql>select * from ds1.Customers where ds1.Customers.city =
ds2.CUSTOMERS.city</sql>
<result element="customers" rowName="customer">
<element name="customer-name" column="customerName" />
<element name="contact-last-name"
column="contactLastName" />
<element name="contact-first-name"
column="contactFirstName" />
<element name="phone" column="phone" />
<element name="city" column="city" />
<element name="country" column="country" />
</result>
</query>
...
Notice that in the above segment, two different data sources have
been defined (BTW shall we replace config with dataSource?). The SQL
spans across the two data sources, hence the table names have been
qualified with the data source name. If only a single data source has
been defined, qualifying the table names will not be necessary.
WDYT?
--
Azeez
_______________________________________________
Wsas-java-dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/wsas-java-dev
_______________________________________________
Wsas-java-dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/wsas-java-dev
--
Thanks
Lahiru Sandakith
http://www.wso2.org
GPG Key Fingerprint : 8CD8 68E0 4CBC 75CB 25BC 1AB1 FE5E 7464 1F01 9A0F
_______________________________________________
Wsas-java-dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/wsas-java-dev
