Using oracle_driver.properties file

If you need to set custom properties for your Oracle JDBC connections, these can be added to an oracle_driver.properties file.

For example, if you would like to set a custom property for SSL_SERVER_ON_MATCH=false follow the below steps. (Note: for this particular property you would also need to setup a TCPS protocol using TNS Names file.)

1. In the <install_dir>/repl folder add a file called oracle_driver.properties

2. Add your properties to this file, eg. SSL_SERVER_DN_MATCH=false

3. In the <install_dir>/repl/hammer.sh file add a line for VMARGS="${VMARGS} -DORACLE_DRIVER_PROPERTIES=${INSTALL_DIR}/oracle_driver.properties". Placement will be as below:

   VMARGS=-Dlogback.configurationFile="${INSTALL_DIR}/logging-config.xml" VMARGS="${VMARGS} -Dfile.encoding=UTF-8 -DMSSQL_DRIVER_PROPERTIES=${INSTALL_DIR}/mssql_driver.properties" VMARGS="${VMARGS} -DLIQUIBASE_LOG_LEVEL=INFO" VMARGS="${VMARGS} -DORACLE_DRIVER_PROPERTIES=${INSTALL_DIR}/oracle_driver.properties"

4. Test the setting by running hammer testConnect <dbDef> on either your linux machine or Git Bash client.

   1. You should see the below in your <project_dir>/daticaldb.log, eg.

      09:11:17.445 [main] DEBUG c.d.h.repl.command.CommandsManager - Executing REPL command: testConnect 09:11:17.479 [main] DEBUG c.d.h.c.c.DatabaseBuilder - createDatabaseObject... 09:11:17.512 [main] DEBUG c.d.h.c.c.DatabaseBuilder - attempting to load driver oracle.jdbc.OracleDriver using OSGi DriverConsumer 09:11:18.378 [main] DEBUG c.d.h.c.c.DatabaseBuilder - driverObject is 'oracle.jdbc.OracleDriver' 09:11:18.379 [main] DEBUG c.d.h.c.c.DatabaseBuilder - attempting connection with URL 'jdbc:oracle:thin:@//cs-oracledb.liquibase.net:1521/ABC_DEV' 09:11:18.379 [main] DEBUG c.d.h.c.c.DatabaseBuilder - connection properties are: 09:11:18.379 [main] DEBUG c.d.h.c.c.DatabaseBuilder - 'password' = '***redacted***' 09:11:18.379 [main] DEBUG c.d.h.c.c.DatabaseBuilder - 'v$session.program' = 'Datical Client' 09:11:18.379 [main] DEBUG c.d.h.c.c.DatabaseBuilder - 'defaultRowPrefetch' = '1000' 09:11:18.379 [main] DEBUG c.d.h.c.c.DatabaseBuilder - 'user' = 'liquibase_user' 09:11:18.379 [main] DEBUG c.d.h.c.c.DatabaseBuilder - 'SSL_SERVER_DN_MATCH' = 'false' 09:11:18.379 [main] DEBUG c.d.h.c.c.DatabaseBuilder - connection successful 09:11:18.528 [main] DEBUG c.d.h.c.c.DatabaseBuilder - Open 1 : successful connection to database URL jdbc:oracle:thin:@//cs-oracledb.liquibase.net:1521/ABC_DEV 09:11:18.528 [main] INFO c.d.hammer.core.DatabaseDefUtil - Database Platform (DEV): Oracle 19.0 (Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

1. In the <install_dir>/repl folder add a file called oracle_driver.properties

2. Add your properties to this file, eg. SSL_SERVER_DN_MATCH=false

3. In the <install_dir>/repl/hammer.bat file add a line for -DORACLE_DRIVER_PROPERTIES="%INSTALL_DIR%oracle_driver.properties". Placement will be as below:

   SET VMARGS=-Dfile.encoding=UTF-8 -Declipse.launcher="%INSTALL_DIR%hammer.bat" -Dlogback.configurationFile="%INSTALL_DIR%logging-config.xml" -DLIQUIBASE_LOG_LEVEL=INFO -DMSSQL_DRIVER_PROPERTIES="%INSTALL_DIR%mssql_driver.properties" -DORACLE_DRIVER_PROPERTIES="%INSTALL_DIR%oracle_driver.properties"

4. Test the setting by running hammer testConnect <dbDef> on your Windows client using CMD line.

   1. You should see the below in your <project_dir>/daticaldb.log, eg.

      08:57:43.549 [main] DEBUG c.d.h.repl.command.CommandsManager - Executing REPL command: testConnect 08:57:43.586 [main] DEBUG c.d.h.c.c.DatabaseBuilder - createDatabaseObject... 08:57:43.623 [main] DEBUG c.d.h.c.c.DatabaseBuilder - attempting to load driver oracle.jdbc.OracleDriver using OSGi DriverConsumer 08:57:44.555 [main] DEBUG c.d.h.c.c.DatabaseBuilder - driverObject is 'oracle.jdbc.OracleDriver' 08:57:44.555 [main] DEBUG c.d.h.c.c.DatabaseBuilder - attempting connection with URL 'jdbc:oracle:thin:@//cs-oracledb.liquibase.net:1521/ABC_DEV' 08:57:44.555 [main] DEBUG c.d.h.c.c.DatabaseBuilder - connection properties are: 08:57:44.555 [main] DEBUG c.d.h.c.c.DatabaseBuilder - 'password' = '***redacted***' 08:57:44.555 [main] DEBUG c.d.h.c.c.DatabaseBuilder - 'v$session.program' = 'Datical Client' 08:57:44.555 [main] DEBUG c.d.h.c.c.DatabaseBuilder - 'defaultRowPrefetch' = '1000' 08:57:44.555 [main] DEBUG c.d.h.c.c.DatabaseBuilder - 'user' = 'liquibase_user' 08:57:44.555 [main] DEBUG c.d.h.c.c.DatabaseBuilder - 'SSL_SERVER_DN_MATCH' = 'false' 08:57:44.556 [main] DEBUG c.d.h.c.c.DatabaseBuilder - connection successful 08:57:44.685 [main] DEBUG c.d.h.c.c.DatabaseBuilder - Open 1 : successful connection to database URL jdbc:oracle:thin:@//cs-oracledb.liquibase.net:1521/ABC_DEV 08:57:44.685 [main] INFO c.d.hammer.core.DatabaseDefUtil - Database Platform (DEV): Oracle 19.0 (Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

1. In the <install_dir> root folder add a file called oracle_driver.properties

2. Add your properties to this file, eg. SSL_SERVER_DN_MATCH=false

3. In the <install_dir>/datical.ini file add a line for -DORACLE_DRIVER_PROPERTIES=./oracle_driver.properties. Placement will be as below:

   -DMSSQL_DRIVER_PROPERTIES=./mssql_driver.properties -DORACLE_DRIVER_PROPERTIES=./oracle_driver.properties -DLIQUIBASE_LOG_LEVEL=INFO

4. Test the setting by using the GUI → <project> → Selecting a dbDef → Edit Connection → Test Connection.

   1. You should see the below in your <install_dir>/daticaldb.log, eg.

      09:36:59.336 [main] DEBUG c.d.h.c.c.DatabaseBuilder - createDatabaseObject... 09:36:59.337 [main] DEBUG c.d.h.c.c.DatabaseBuilder - attempting to load driver oracle.jdbc.OracleDriver using OSGi DriverConsumer 09:36:59.826 [main] DEBUG c.d.h.c.c.DatabaseBuilder - driverObject is 'oracle.jdbc.OracleDriver' 09:36:59.826 [main] DEBUG c.d.h.c.c.DatabaseBuilder - attempting connection with URL 'jdbc:oracle:thin:@//cs-oracledb.liquibase.net:1521/ABC_DEV' 09:36:59.826 [main] DEBUG c.d.h.c.c.DatabaseBuilder - connection properties are: 09:36:59.826 [main] DEBUG c.d.h.c.c.DatabaseBuilder - 'password' = '***redacted***' 09:36:59.827 [main] DEBUG c.d.h.c.c.DatabaseBuilder - 'v$session.program' = 'Datical Client' 09:36:59.827 [main] DEBUG c.d.h.c.c.DatabaseBuilder - 'defaultRowPrefetch' = '1000' 09:36:59.827 [main] DEBUG c.d.h.c.c.DatabaseBuilder - 'user' = 'liquibase_user' 09:36:59.827 [main] DEBUG c.d.h.c.c.DatabaseBuilder - 'SSL_SERVER_DN_MATCH' = 'false' 09:36:59.827 [main] DEBUG c.d.h.c.c.DatabaseBuilder - connection successful 09:36:59.941 [main] DEBUG c.d.h.c.c.DatabaseBuilder - Open 1 : successful connection to database URL jdbc:oracle:thin:@//cs-oracledb.liquibase.net:1521/ABC_DEV 09:37:01.156 [main] DEBUG c.d.h.c.c.DatabaseBuilder - Close 0 : jdbc:oracle:thin:@//cs-oracledb.liquibase.net:1521/ABC_DEV