...

If you are using the v2.3 database connector you can quickly verify proper installation using the built-in status service by putting this URL into your browser: http://localhost:8082/database/status. Change localhost and port 8082 to the host and port where you installed the connector.If you are using the v2.3 database connector you can quickly verify proper installation by putting this URL into your browser: http://localhost:8082/database/status. Change localhost and port 8082 to the host and port where you installed the connector.

If you are using the v2.2 database connector you can verify the installation using one of the pre-configured SQL queries. 

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  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> <host> - the URL for the web server on which you deployed database.war.
• port> <port> - port where the container is listening for http requests. This defaults to 8082 if the database connector was deployed in the frevvo-tomcat  tomcat bundle.
• queryset <queryset name> - queryset name defined in the database connector configuration file.
• query <query name> – query name  defined in the database connector configuration file.

...

The database connector contains a working sample HSQLDB database with some test data. If you are already running the Live Forms the  In-house frevvo form server you can get started very quickly.

...

• Successfully installed the frevvo database  database connector and,
• Retrieved data from the built-in test database

If you have any problems with the Quick Start please see Getting Help to contact frevvo supportcontact  support.

Common Problems

...

Live Forms tomcat running on non-default port

If you have configured your frevvo-tomcat your tomcat in <frevvo-home>/tomcat/conf/server.xml to run on a port other than the default 8082, then you must set the port in the Url to the database connector to that different port number.

This will not work:

http://localhost:8082/database/myStore/allOrders

Change 8082 to your tomcat port.

...

In the v2.1 database connector you MUST restart frevvo after  after changing the location of configuration.xml. Even though it appears that the changed location is picked up automatically after you save the change in context.default.xml, when you try your query after this change the tomcat logs will have an NPE and none of your queries will work.

The solution is to stop and restart the database connector. If you are using the frevvo-tomcat  tomcat bundle you can do this by: Double click <frevvo-home>\stop-frevvo. Wait until frevvo stops stops. Then Double click <frevvo-home>\start-frevvo

The query returns old results after you update the SQL in configuration.xml

It is very helpful to first test your queries by entering the query URL directly into your web browser and verify that the data resultset returned to your browser as a web page is as you expect. Note however that browsers often cache web pages. If you edit your configuration.xml SQL query and reload/refresh the URL in your browser you may NOT get the updated results due to your browser's caching. Avoid this caching issue by always opening a new browser tab to retest an updated query.