datasource.names

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: Support versions: Microsoft SQL Server (6.5, 7, 2000, 2005, 2008, 2012)

  • 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