groovy jdbc oracle

gistfile1.txt

1. download ojdbc7.jar (http://bugmenot.com/view/oracle.com)
2. script oracle.groovy:

  def host = "host"
  def port = "1521"
  def db = "dbname"
  def url = "jdbc:oracle:thin:@"+host+":"+port+":"+db
  def username = "username"
  def password = "password"
  @GrabConfig(systemClassLoader=true)

  driver = "oracle.jdbc.driver.OracleDriver"
  import groovy.sql.*

  sql = Sql.newInstance(url,username,password,driver);

  sql.eachRow('''select table_name from all_tables
   ''', { link ->
      println link
  })
3. groovy -cp ojdbc7.jar oracle.groovy