Versions Compared

Old Version 2

changes.mady.by.user svitlana

Saved on

compared with

New Version Current

changes.mady.by.user Hung Techlead

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Panel
borderColorblack
bgColorlightgrey
Excerpt

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


Code Block
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