/
JDBC.Properties File Field

JDBC.Properties File Field

Starting October 11, 2024 (Zephyr Enterprise 8.2), the Zephyr Enterprise documentation moved from its current location on Atlassian to a dedicated, standalone Zephyr Enterprise documentation page. Please see: https://support.smartbear.com/zephyr-enterprise/docs/en/zephyr-enterprise/zephyr-installation-and-upgrade-guides/zephyr-on-premise-production-installation/jdbc-properties-file-field.html


ZEPHYR_HOME = Zephyr installation directory
ZEPHYR_DATA = It is the place where your zephyrdata folder is present which has the attachments NODE_DATA = Path to nodedata folder
db.driverClassName = driverClassName corresponding to your selected database
db.url = database URL
db.username = database username
db.password = database password
db.name = Zephyr database schema name example itcc
hibernate.dialect = hibernate.dialect based on your selected database
db.dversion.username = dversion username
db.dversion.password = dversion password
db.type = database type such as Mysql, Oracle or MSSQL
jdbc.characterEncoding = utf8
db.persistence.manager = org.apache.jackrabbit.core.persistence.bundle.MSSqlPersistenceManager

Needed only for oracle

db.dversion.connectionInitSql = ${dversion.connectionInitSql}
db.connectionInitSql = ${connectionInitSql}
db.validationQuery = ${validationQuery}
db.maxPoolSize = ${db.parametersdb.maxPoolSize}

Needed Only for backup and restore

server.port = Server port for backup and restore
backup.authorization = 8a8a9302d25c47
server.url = localhost

Needed by services-config.xml. Below is needed for SSL configuration

secured = false

Provide the correct keystore.file, keystore. password and keystore.alias if the secured property is true

keystore.file =
keystore.password =
keystore.alias =

Needed by repository

database.port = your database port
db.dversion.url = database dversion URL
db.dversion = diversion
db.installactionType = Based on the database choosen. For MSSQL it will be 4.
jarFileName = database jar name
repository.repositoryHome = C:/Program Files/Zephyr/repository
hibernate.searchindex.location = C:/Program Files/Zephyr/repository/dbindex

kettle properties, read in applicationContext-resources.xml

kettle.home = C:/Program Files/Zephyr/di/
kettle.database.host = localhost
kettle logging: nothing = 0, error = 1, minimal = 2, basic =3, detailed = 4, debug =5, rowlevel (extremely detailed) = 6
kettle.logging.level = 3
elastic.indices.query.bool.max_clause_count = 4096
#For ES running in transport mode please put these properties in <elasticsearch installation/config/elasticsearch.yml file

elastic.http.port = 9200
elastic.http.enabled = false
transport.nodes = http://localhost:9200
rest.enabled = true
enableMethodData = false
elastic.rest.prop.xpack.security.user = zephyr:elasticsearch password
zcloud.base.url = https://dev-predictive.zephyr4jiracloud.com
zcloud.auth.url = https://dev-predictive.zephyr4jiracloud.com/v1/api/auth

#Below field values populate when we first time install zephyr.

db.encPassword = WhOpkhkwfkheNzn00GKcoLKwaQg==
db.dversion.encPassword = WhkjhwrkhkhfekhkKwahawkjh
elastic.rest.prop.xpack.security.enc.user = elastic:elasticsearch(encrypted password)

Related content

Zephyr Supported Platforms
Zephyr Supported Platforms
Read with this
MySQL
More like this
Connecting to an External Database
Connecting to an External Database
More like this
Steps to change the JDBC Driver
Steps to change the JDBC Driver
More like this
MySQL
More like this
MySQL
More like this