Page History
Introduction
Three Two types of datasources can be configured in the Java web applicationRuntime: JDBC , ODBC and JNDI. A datasource must be defined in the
Include Page | ||||
---|---|---|---|---|
|
...
UI Text Box | ||
---|---|---|
| ||
When configuring the datasources for both the ProcessCaseDao and the AggregateDao, please make sure they have separate datasources. Using the same datasource is known to cause errors. |
Using the properties file
Configuring a JDBC datasource
Configuring a JDBC datasource named datasource_name must be done by setting the following mandatory properties:
...
Info |
---|
Using the development plugin settings always creates the optional settings in the properties file. See more details in the development plugin section. |
...
Configuring an ODBC datasource
Configuring an ODBC datasource named datasource_name must be done by setting the following mandatory properties:
Code Block | ||
---|---|---|
| ||
blueriq.connection.datasource_name.sql.type=odbc blueriq.connection.datasource_name.sql.database= blueriq.connection.datasource_name.sql.username= blueriq.connection.datasource_name.sql.password= |
Configuring a JNDI datasource
Configuring a JNDI datasource named datasource_name must be done by setting the following mandatory properties:
...
The procedure of creating a JNDI datasource is container-specific. Please consult the documentation of the application server running the application on how to create a JNDI datasource.
Using the development plugin
Assuming the development tools component is installed, the Settings widget can be started by using the button in the top right corner of the dashboard (see Using the development dashboard).
The Connections tab will show all the available connections. Managing the database connections is done in the Sql section.
To add a new connection, use the New Sql connection section at the bottom of the page, provide a name for the new connection and click Add new connection. Creating a new JDBC connection named datasource_name should yield the following result:
Info |
---|
Using the tooltips provides extra information about what each setting does. |
...
.