I thought I would share my settings that I use to help save anyone else pulling their hair out
# The path to our downloaded jdbc driver saved mine in /bin, driver ojdbc6.jar also works.
#Best location can be /vendor folder
jdbc_driver_library => "ojdbc7.jar"
# ORACLE Driver Class
jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
# ORACLE jdbc connection string to our database, ORACLE jdbc:oracle:thin:@hostname:PORT/SERVICE
jdbc_connection_string => "jdbc:oracle:thin:@hostname:PORT/SERVICE"
# The user and password we wish to execute our statement as
jdbc_user => "DBUSERNAME"
jdbc_password => "DBPASSWORD"
# our SQL query
statement => "select * from AWESOMETABLE"
#optional extras I use
type => "Database"
tags => ["awesome", "import"]
Hope that helps