Looking for the documentation on the newest versions of SIL Engine and the Simple Issue Language for Jira 8 for Server/Data Center? Click here !
Adding a Datasource
To create a data source from the user interface, access the Datasources menu in cPrime Add-ons section, then click Add Datasource.
Fill out the necessary fields:
Name of the datasource, identifying uniquely ( * ) your data source
The database type
The JDBC URL, with the syntax the driver understands
Username and password for the database, if applicable
Optionally, you may control the pool parameters:
Validation query - The SQL query that will be used to validate connections from the pool.
Initial size - Number of initial connections.
Max Active - Maximum number of active connections that can be allocated at the same time.
Max Idle - The maximum number of connections that can remain idle in the pool.
Min Idle - The minimal number of connections that can remain idle in the pool.
These are DBCP parameters that are used when defining any JNDI datasource. Once you have configured your datasource, you are ready to test it. Any error is picked up and shown in this dialog so you can review the parameters, make the changes and test again. When it works, just save it, your new datasource is ready to be used.
The identification of the datasource is unique only among these ones, defined in the Kepler suite. As we explained, the name here takes precedence over any JNDI name that happens to be the same.
JDBC Driver must be already loaded (for instance placed in Jira's lib folder).
At the moment, there's no possibility to monitor the performance of the SQL pool, so you will have to rely on external tools, specific to your database / operating system.
The datasources screen lists all your datasources and allows to edit, test and remove operations to be performed on each datasource. Note that there's no warning when removing a datasource that is in use by your SIL™ programs, so take care when performing destructive operations. Changes in the datasources are picked up immediately.
By default, JIRA runs in Tomcat, so the following example applies to Tomcat only. To learn how to define data source, refer to the application server manual.
Ensure that you have the SQL driver in JIRA_HOME/lib directory. The driver should be proper for the type of the (external to JIRA) database in use.
Open the JIRA_HOME/conf/context.xml file in a text editor. Enter your data source there, for instance, between the existing tags <Context> </Context>: Hsqldb
<!-- Optional, but highly recommended, add here the limits for your SQL database connection pool -->
maxTotal="20" maxIdle="5" maxWaitMillis="-1"
Restart your Jira. You should be now ready to use the data source you just defined.
If you want to use a column alias in a select sql and use that alias instead of a column name you should add "?useOldAliasMetadataBehavior=true" as a configuration parameter in your JDBC url. This is due to a change in My SQL JDBC driver implementation starting with version 5.1.
For MS Sql Server 2000 the instance name should be omitted from the url even if you are connecting to a named instance. Thus, the url attribute should be: url="jdbc:jtds:sqlserver://localhost:1433/somedb".