Introduction
...
- Stage grid configurations from a test environment to a production environment
- Hide the password allowing to access the database
- Reuse a connection in multiple grids
...
Manage data
...
Accessing the function
sources
The data source administration pages can be found under the table grid add-on configuration pages.
| JIRA Version | Location of the table grid addon configuration pages |
|---|---|
| 5.x | Administration -> Plugins -> Table Grid Editor -> Data Sources admin |
| 6.x | Gear box in the top bar -> Add Ons -> Table Grid Editor -> Data Sources admin |
...
Create /
...
modify /
...
On the data sources admin form, all the defined data source specifications are listed
...
delete
You can add/modify/delete data source in the Data Source Admin under Add-ons - Table Grid Editor
Add a data source specification
When adding a data source specification, you You can select one of the supported databases when adding the data source. Depending on this choice
different parameters can be provided. Check with your database administrator in case of doubt.
...
| Note |
|---|
|
...
Test the connection
Use the You can test connection function to check if the configuration is correct.
...
| Note |
|---|
|
...
Modify a connection
- When modifying a connection, you will not be able to change its id.
- The password will only be updated if a new password is entered.
...
- You can update the connection password
- You cannot change the connection id when modifying
Delete a connection
- There is no check if a datasource specification is being referenced from grid configurations.
If a specification, which is in use, the referencing grid(s) will show a connection error the next time they are being used.
Using the data
...
sources in the grid configuration
The data source specification can be used in following properties
...
- Inner specifications are data source specifications which are defined in the grid configuration using the datasource.names
and dsand ds.xyz.connection properties as detailed on the database details - inner specifications page. - Admin specifications are data source specifications which are defined in the data sources admin forms.
- When an admin specification has the same id as an inner specification, the inner specification will have priority
- gridds is the default name where tables are stored when no gd.ds is specified. An admin specification with the name 'gridds'
will not be used. - jira is a reserved name.
- You can change datasource configuration directly in the Jira database: the configuration is stored in the database table called AO_272C37_DSSENTRY
Internal Java drivers to manage Data Source connections
...