This quickstart demonstrates how to use SQL via JDBC along with Camel's REST DSL to expose a RESTful API.
The example can be built with
mvn clean install
It is assumed that OpenShift platform is already running. If not you can find details how to Install OpenShift at your site.
The example can be built and deployed using a single goal:
mvn -Pf8-deploy
When the example runs in OpenShift, you can use the OpenShift client tool to inspect the status
To list all the running pods:
oc get pods
Then find the name of the pod that runs this quickstart, and output the logs from the running pods with:
oc logs <name of pod>
You can also use the OpenShift web console to manage the running pods, and view logs and much more.
When the example is running, a reset service can be accessed to list available books that can be ordered, and as well order status.
If you run the example on a local fabric8 installation using vagrant, then the REST service is exposes as
http://qs-camel-rest-sql.vagrant.f8
The actual endpoint is using context-path camel-rest-sql/books
and the REST service provides two services
- books = to list all the available books that can be ordered
- order/{id} = to output order status for the given order id. The example will automatic create new orders with a running order id starting from 1.
You can from a web browser then access these services such as:
http://qs-camel-rest-sql.vagrant.f8/camel-rest-sql/books
http://qs-camel-rest-sql.vagrant.f8/camel-rest-sql/books/order/1
The example can also be built and run using the included S2I template quickstart-template.json.
The application can be run directly by first editing the template file and populating S2I build parameters, including the required parameter GIT_REPO and then executing the command:
oc new-app -f quickstart-template.json
Alternatively the template file can be used to create an OpenShift application template by executing the command:
oc create -f quickstart-template.json
You can find more details about running this quickstart on the website. This also includes instructions how to change the Docker image user and registry.