Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

define the datasources in use in this grid. Further specified in [database detail

Class

database

Property

datasource.names

Formal specification

datasource.names = source identifier [, source identifier]

Required

yes in case gd.table is given

Default


Version

1.0, support for MS SQL Server added on 1.13

Comment

The datasource names can be used in the different gd.query.ds and col.xyz.query.ds properties. When you define a gd.table (Deprecated) property (where you want to store data of the grid), you have to define a gridds data source. You can define multiple sources for retrieving data. There is one special datasource jira. This datasource doesn't need to be explicitely defined as the plugin does it for you. It represents the database where JIRA is storing its data. In version 1.1 of the plugin we support following databases 

  • Oracle 
  • Mysql 
  • Postgres 
  • MS SQL Server
  • SYBASE
     
    Note that in 1.12 we introduced Datasource Specifications which provides a simple form to define datasources and reuse them in multiple grids.

Example

datasource.names=gridds 
ds.gridds.connection.type=mysql 
ds.gridds.connection.url=jdbc:mysql://localhost:3306/igrid_test?useUnicode=true&characterEncoding=UTF8&jdbcCompliantTruncation=falseds.gridds.connection.username=igrid_tester 
ds.gridds.connection.password=igrid_tester 

Reference

gd.query.ds 
col.xyz.query.ds 
ds.xyz.connection.type = sqlserver
ds.xyz.connection.type = mysql 
ds.xyz.connection.type = postgres 
ds.xyz.connection.type = sybase
ds.xyz.connection.type = oracle

  • No labels