SQL data sources

Owned by No Reply
Last updated: Oct 22, 2021 by Jonathan Muse

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 !

SQL Data Source Configuration

Starting with version 4.0 datasource definition got a lot easier. You may choose either to define your datasource as a JNDI or directly from the user interface. Defining the datasource pool from our UI does not declare that datasource as JNDI datasource, and therefore it will not be accessible by other apps, unless, of course, they are based on our own SIL Engine™ app.These pages represent a guide for SQL connection pool definition, declared either in the Apache's Tomcat context.xml (JNDI) or directly via our pages and dialogs.  

Datasources defined directly in our apps will have prevalence over the JNDI names already defined. If you have a JNDI data source named 'mydata' and you define a database source named 'mydata' via the interface, the latest will be used.

 Summary