| Example |
Description |
| A Simple Example |
| Simple Example |
Runs a simple query on a relational data service resource exposed by a data service. |
| The Basics |
| Locating A Data Service |
Contacts a data service and gets the list of resources exposed by the data service. |
| Performing Queries |
| Simple SQL Query |
Submits a simple SQL query. |
| Sequence of SQL Queries |
Submits a request containing several queries. |
| Parameterised SQL Query |
Parameterises an SQL query then submits it repeatedly with different parameter values. |
| Simple XPath Query |
Submits a simple XPath query against an XMLDB collection. |
| Processing Results |
| Processing SQL Query Results |
Processes the results of an SQL query using the JDBC java.sql.ResultSet interface. |
| Processing Larger SQL Query Result Sets |
Process the results of an SQL query that returns a large number of rows. The rows are returned asynchronously from the service via the use of a DTOutputStream so that the entire results do not have to be returned to the client in one go. |
| Processing XPath Query Results |
Processes the results of an XPath query using the XMLDB org.xmldb.api.base.ResourceSet interface. |
| Updates and Bulk Load |
| SQL Update |
Performs an SQL update. A new row is inserted, updated and then deleted. |
| SQL Bulk Load |
Bulk loads the results of a query performed against one table into another table. |
| SQL Update Parameterised Via Data Transport |
Performs a parameterised SQL update, the parameter values being provided via the service's putBlock data transport operation. |
| XUpdate |
Performs an XUpdate statement. |
| Transforming Data |
| XSL Transform With Delivery |
Transforms the results of an SQL query into an HTML table. The XSL Transform document is loaded from a URL. |
| Using Sessions |
| Using Sessions |
A session is created, a request joins the session, the session is terminated. |
| Asynchronous Requests |
| Aysnchronous Requests |
Introduces asynchronous requests and explains how to monitor the status of a request. |
| Asynchronous Delivery |
| Data Transport Example |
One service pulls data to another service via the use of the getBlock data transport operation. |
| Data Integration |
| Data Integration Example |
A simple data integration scenario. An XPath query is performed on an XML database, the results are transformed into a WebRowSet and bulk loaded into a temporary table on a relational database. |
| Using Message-Level andTransport-Level Security (OGSA-DAI WSRF only) |
| Using Transport Level Security |
Using transport-level security when communicating with a service. |
| Using Message Level Security |
Using message-level security when communicating with a service. |