| Warning |
|---|
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 ! |
| Info | ||
|---|---|---|
| ||
This routine is available starting with katl-commons 2SIL Engine™ 2.6.5. |
Syntax
databaseAvailable(dbstring [, sqlstring])
...
| Excerpt |
|---|
Checks if the database is available. Optionally, it can check also the availability of the results for the SQL passed in as the second parameter. |
Parameters
Parameter name | Type | Required | Description |
|---|---|---|---|
dbstring | string | yes |
Datasource JNDI name or the datasource name. For |
Jira database, this is set to "jdbc/JiraDS" by default |
, if exported |
. | ||
sqlstring | string | no |
SQL string. |
Return type
boolean (true/false)
...
| Code Block | ||
|---|---|---|
| ||
TextField=databaseAvailable("InexistentTestDB", "select pname from project");//will set `TextField` value to `false`, because the database resource does not exist |
Notes
| Note |
|---|
To see how you should configure the data source , check the corresponding configuration chapter: SQL data sources |
...
configuration chapter. |
See also
| Filter by label (Content by label) | ||||||||
|---|---|---|---|---|---|---|---|---|
|
...