Testing out Teradata JDBC / JRuby

test_jdbc_teradata.rb

require 'rubygems'
require 'jdbc/teradata'
require 'java'

begin
  Java::com.teradata.jdbc.TeraDriver
  userurl = "jdbc:teradata://10.0.1.2/DATABASE=database_name,DBS_PORT=1025,COP=OFF"
  connSelect = java.sql.DriverManager.get_connection(userurl, "username", "password")
  stmtSelect = connSelect.create_statement

  select = %q{
    SELECT code, name FROM table.bar;
  }

  rs = stmtSelect.execute_query(select)

  while (rs.next) do
    p rs.getObject("code")
    p rs.getObject("name")
  end

  stmtSelect.close
  connSelect.close
end