Chapter 71. Example relational data resource client

Prev	Part IV. OGSA-DAI for client users	Next

71.1. How to run a query over a relational data resource

OGSA-DAI provides a simple command-line client for running requests involving relational data resources. This uses the SQLQuery, TupleToWebRowSetCharArrays, CharArraysResize and DeliverToRequestStatus activities. The query results are pretty-printed.

	Note
OGSA-DAI example clients are intended to allow users to quickly test their deployment as well to provide basic examples of how to construct clients using the client toolkit. They are not intended to be robust applications for use in problem solving. OGSA-DAI offers a toolkit which provides userss with the tools to develop their own clients that use OGSA-DAI services - these clients are the simplest examples built using this toolkit.

Note

OGSA-DAI example clients are intended to allow users to quickly test their deployment as well to provide basic examples of how to construct clients using the client toolkit. They are not intended to be robust applications for use in problem solving. OGSA-DAI offers a toolkit which provides userss with the tools to develop their own clients that use OGSA-DAI services - these clients are the simplest examples built using this toolkit.

The client takes the following arguments:

-u SERVICES_BASE_URL - services base URL - this specifies the location of the OGSA-DAI server. This will typically be of form:
```
http://HOST:PORT/wsrf/services/dai/
```
where HOST is the host on which the OGSA-DAI is running and PORT is the port on which the container accepts connections.
-e DRER-ID - a data request execution resource (DRER) ID. This is the ID of the DRER that will execute the request. Usually this can be omitted (the default in this case is DataRequestExecutionResource).
-d DATA-RESOURCE-ID - a data resource ID. The ID of the data resource that the client will interact with.
-q QUERY - the SQL query to run.

	Caution
	The client should be run in the `$OGSADAI_HOME` directory or you should make sure that the directory `$OGSADAI_HOME/deploy` is in your `CLASSPATH` (the `client-config.wsdd` file in that directory is necessary).

71.1. How to run a query over a relational data resource

Run the following, replacing SERVICES-BASE-URL, DATA-RESOURCE-ID, QUERY and, if required DRER-ID.

$ java uk.org.ogsadai.client.toolkit.example.SQLClient \
  -u SERVICES-BASE-URL [-e DRER-ID] -d DATA-RESOURCE-ID  \ 
  -q QUERY

For example:

$ java uk.org.ogsadai.client.toolkit.example.SQLClient \
  -u http://coal.epcc.ed.ac.uk:8080/wsrf/services/dai/ -d MyOwnSQLDataResource \
  -q "SELECT * FROM littleblackbook WHERE id < 10;"

Prev	Up	Next
Chapter 70. Example server client	Home	Chapter 72. Example relational data resource client using GT security