Issues

Select view

Select search mode

 
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

Components

Affects versions

Priority

Created December 20, 2010 at 10:02 PM
Updated September 3, 2014 at 9:17 PM
Resolved December 20, 2010 at 10:53 PM

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.

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)))

Loading...