| Section |
|---|
| Column |
|---|
The Database Connector is a web application and can be deployed under any Servlet container or run in a simple Standalone mode. The connector relies on the JDBC API. You can use any relational database as long as you have a JDBC driver for that database. These instructions apply to Cloud and in-house customers. |
|
...
| Info |
|---|
- You MUST copy the MS SQL (sqljdbc.jar) to the <frevvo-home>/tomcat/lib directory when running the connector in the frevvo-tomcat bundle AND using MS SQL as your external database
- If you are using the The jTDS driver , refer to the special considerations when defining datasourcesrequires an adidtional property, Refer to Datasource Definition Examples for information
- It is also appropriate to copy the driver into any location that is in the CLASSPATH of your servlet container. In a tomcat installation another location would be <CATALINA_HOME>/lib.
|
DB Connector Quick Demo
The BIRT (ClassicModels) and myStore querySets are preloaded with in-memory Derby databases and test data. This make it very easy to try out the connector. No configuration is necessary.
Follow the steps below to deploy the connector in the the frevvo-tomcat bundle and you can get started very quickly
Download the latest frevvo-tomcat bundle from the frevvo website.
Download the Database Connector war file.
Extract the tomcat bundle zipfile to a location of your choice. We will refer to this directory as <frevvo-home>.
Copy database.war to <frevvo-home>\tomcat\webapps.
Start the Insight server, then start Live Forms.
| Expand |
|---|
| title | Click here for the instructions to start the Insight Server and Live Forms |
|---|
|
| Insert excerpt |
|---|
| Planning for v7.3 |
|---|
| Planning for v7.3 |
|---|
| nopanel | true |
|---|
|
|
- Test the connector installation by copying this URL directly into your browser:
http://localhost:8082/database/status
After performing these steps you will have: successfully installed the database connector and retrieved data from the built-in test database - Create a tenant.
- Create a designer user in the tenant
- Download the Database Connector Application, then upload it to your designer user. This application includes some example forms that demonstrate the power of the Database Connector using built-in databases.
| Excerpt |
|---|
|
Standalone Mode:- Download the Standalone connector zipfile here.
- Unzip the database.zip file to a location of your choice. We will refer to this directory as <db-home>
- Start the connector using plain java command or execute one of the files in this directory to install the DB Connector as a Windows service or *nix console instance:
- Choose one of these methods to start the connector:
- Method 1: Using java in a command window
- Navigate to the <db-home> directory.
- Type java -jar database.war
- Method 2: for Windows OS
- Install the DB Connector as a Windows service by double clicking the Install-Service.bat file. Click the Start DBConnector Service.bat to start the service.
- Method 2 for *nix OS
- Execute the DB Connector.sh shell script for *nix operating systems.
- Test the connector installation by copying this URL directly into your browser:
http://localhost:8081/database/status
- Note the standalone connector runs on port 8081 by default. The port number can be changed when you configure the DB Connector in the next step. Use port 8081 to verify that the Db Connector is up and running for now.
- Verify that query validation page is loaded with status Passed for the built-in database BIRT and myStore querysets.
- Download the Database Connector Application and upload it to the designer user in your Cloud tenant for some example forms that demonstrate the power of the Database Connector using built-in databases.
|