Start your servlet container. If you are using the frevvo-tomcat bundle double click <frevvo-home>\start-frevvo. This will start the database connector web application. Access the connector by typing one of the test Urls below directly in your browser. 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>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.
|