Section | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
|
The database connector comes with a built-in hsqldb database for testing purposes. And the database connector's configuration.xml comes pre-configured with a few sample SQL queries. If you installed database.jar under the frevvo-tomcat bundle, run the following test queries. This will retrieve data from the built-in database:
For the tomcat-bundle running on the default port 8082, this query will return an xml document with two orders.
http://localhost:8082/database/myStore/allOrders
This query will select the order where orderId is equal to 102, and return an xml document with that single order.
http://localhost:8082/database/myStore/orders?orderId=102
The Url to the database connector has the following REST parameters:
http://<host>:<port>/database/<queryset-name>/<query-name>
Where:
- <host> - the URL for the web server on which you deployed database.war.
- <port> - port where the container is listening for http requests. This defaults to 8082 if the database connector was deployed in the frevvo-tomcat bundle.
- <queryset name> - queryset name defined in the database connector configuration file.
- <query name> – query name defined in the database connector configuration file.
...
Column | ||||
---|---|---|---|---|
| ||||
On this page:
|
...
Quick Start Sample
The database connector contains a working sample HSQLDB database with some test data. If you are already running the In-house frevvo form server you can get started very quickly.
...