Issues

Select view

List view

Detail view

Select search mode

Basic

JQL

To add support to setup jdbc connection properties
CORE-805
Resolved issue: CORE-805
Use server id to reference connection credentials in Maven plugin
CORE-784
Resolved issue: CORE-784
modifyColumn does not create a not null restriction
CORE-719
Resolved issue: CORE-719
Issue with checking for database lock when two processes are started at the same time
CORE-632
Resolved issue: CORE-632
Unable to rollback by tag using maven
CORE-589
Resolved issue: CORE-589
UpdateSQL needs to append a "/" to the end of createProcedure for Oracle
CORE-573
Resolved issue: CORE-573
Liquibase.bat : Incorrect classpath logic
CORE-555
Resolved issue: CORE-555
Sybase ASE 15 database not being identified correctly
CORE-537
Resolved issue: CORE-537
Postgre support does not handle reserved words correctly (e.g. call-limit)
CORE-519
Resolved issue: CORE-519
Support diff and generate changelog operations from maven plugin.
CORE-516
Resolved issue: CORE-516
Disable foreign key checks insted of dropping all foreign keys before dropping all database objects
CORE-498
Resolved issue: CORE-498
Add ability to move changeSets from one databaseChangeLog file to another
CORE-497
Resolved issue: CORE-497
Implement maven Map syntax for changeLogParameters configuraton
CORE-496
Resolved issue: CORE-496
Add maven plugin configuration parameter for skipping running liquibase
CORE-495
Resolved issue: CORE-495
Add possibility for the maven test output directory to be included in the class loader for obtaining the Liquibase property and DatabaseChangeLog files.
CORE-494
Resolved issue: CORE-494
Change Log Properties not working on command line in 1.9.4
CORE-468
Resolved issue: CORE-468
Problems with rollback on sqlFile changes
CORE-465
Resolved issue: CORE-465
SQLAnywhere rename column fails (syntax error)
CORE-463
Resolved issue: CORE-463
updateSQL does not like tableExists pre-condition IF the MySQL database contains a View
CORE-462
Resolved issue: CORE-462
Wrong datatypes for timestamps generated with generateChangeLog
CORE-461
Resolved issue: CORE-461
bogus version number of maven plugin
CORE-460
Resolved issue: CORE-460
Version 1.9.4 is missing a version tag in SCM
CORE-459
Resolved issue: CORE-459
The append content of the modifySql element is also appended to the rollback of the change set
CORE-457
Resolved issue: CORE-457
createIndex refactoring does not create index in specified schema for DB2 dialect
CORE-456
Resolved issue: CORE-456
Liquibase converts TIMESTAMP to DATETIME on MySQL
CORE-450
Resolved issue: CORE-450
Add defaultSchema parameter to Servlet Listener because of bug with DB2 database if currentSchema connection parameter is set
CORE-448
Resolved issue: CORE-448
Strip Comments from SQL changeset is not working properly
CORE-447
Resolved issue: CORE-447
Bug in renameColumn in 1.9.4
CORE-442
Resolved issue: CORE-442
MSSQL Server supports only <CR><LF> (\r\n) as end line delimiters
CORE-426
Resolved issue: CORE-426
Liquibase cannot remove changeset from log table if logical or physical path name contains DOS-style path delimiters
CORE-425
Resolved issue: CORE-425
Add remarks support to addColumn
CORE-420
Resolved issue: CORE-420
Allowing ASC and DESC in index definitions
CORE-419
Resolved issue: CORE-419
onError/onFail preconditions flag not checked for changelog-wide preconditions
CORE-418
Resolved issue: CORE-418
renameColumn is escaping the new column name
CORE-417
Resolved issue: CORE-417
Column escaping incorrect for sybase
CORE-414
Resolved issue: CORE-414
Sybase should return "Numeric" for "int"
CORE-413
Resolved issue: CORE-413
Liquibase maven Plugin throws NullPointerException when calling update goal
CORE-412
Resolved issue: CORE-412
Javascript Error in generated dbDocs due to double quotes.
CORE-410
Resolved issue: CORE-410
sqlFile endDelimeter="" does not work
CORE-408
Resolved issue: CORE-408
Custom Changelog table name not used in older mysql databases (patch attached)
CORE-404
Resolved issue: CORE-404
ModifyColumn Tag is broken (patch attached)
CORE-403
Resolved issue: CORE-403
liquibase-hibernate integration is not practical
CORE-395
Resolved issue: CORE-395

42 of 42

To add support to setup jdbc connection properties

Fixed

Description

There is a valuable feature to setup custom properties of a JDBC database connection when it is creating.
For example, you can not use Oracle Wallets feature with Oracle Thin JDBC driver without property oracle.net.wallet_location set up to a proper value.

Environment

any

Details

Reporter

Sviatoslav Abramenkov

Components

Affects versions

Priority

Major

Created December 20, 2010 at 10:02 PM

Updated September 3, 2014 at 9:17 PM

Resolved December 20, 2010 at 10:53 PM

Configure

Activity

Show:

Sviatoslav Abramenkov September 3, 2014 at 9:17 PM

What exactly your setup is?
What I added is handling of a command line option --driverPropertiesFile.
Argument to this option is location of a text file in the file system that contains usual properties pairs in format name=value on each line - as you can see from the code change, I used standard Properties class and its method load() to load the properties.
Sorry for late reply.

J August 13, 2014 at 11:56 AM

Hi,

I am trying to setup the same thing for our environment, can you provide more details? I havent been able to get it working.

Thanks

Sviatoslav Abramenkov December 20, 2010 at 10:53 PM

Commited into trunk, revision 1969.
Now support for custom properties for a JDBC connection has been added.
To use it together with Oracle wallets feature by "jdbc:oracle:thin:" URLs, use following setup:
java -Doracle.net.tns_admin="path/to/directory/which/contains/tnsnames.ora" -cp "liquibase-version.jar" liquibase.commandline.Main --driver=oracle.jdbc.OracleDriver --classpath="$Orahome/jdbc/lib/ojdbc5.jar:$Orahome/jlib/oraclepki.jar:$Orahome/jlib/osdt_core.jar:
$Orahome/jlib/osdt_cert.jar" --url=jdbc:oracle:thin:/@connection_alias --logLevel=finest --logFile=liquibase.logFile --changeLogFile=changelog.xml --driverPropertiesFile="/path/to/file/with/required/database/connection/properties" update

file with database connection properties should contain required property that points to the directory where Oracle Wallet files are located:
oracle.net.wallet_location=(SOURCE=(METHOD=FILE)(METHOD_DATA=(DIRECTORY=/directory/where/my/wallets/are)))