Cascading/cascading-dbmigrate — pull request #5 by mikestanley (2012-05-18 17:26:31+00:00)
Title: Added support for DriverManager Properties

This commit adds support for setting driver manager properties and passing them to the java driver manager (something that was necessary for migrating from Oracle).

I ran into various issues with Oracle and to work around them, I needed to set some arbitrary
driver properties. The DriverManager was buried in DBConfiguration. I created
a jobconf prefix "dbmigrate.driver." that lets you set arbitrary configuration values
in the job conf that will be used as driver properties. I then added convenience
methods all the way up to DBMigrateTap / DBOptions supporting class.

In clojure, we can now do something like this:
(let [opts (new cascading.dbmigrate.tap.DBMigrateTap$Options)]
(set! (. opts :minId) (long min)))
(set! (. opts :maxId) (long max)))
(set! (. opts :driverProps) {"oracle.jdbc.J2EE13Compliant" "true"})
opts))

you should also be able to add

{"dbmigrate.driver.oracle.jdbc.J2EE13Compliant" "true"}

to your job-conf.clj file if you choose.