require 'java'

module JavaLang
include_package "java.lang"
end

module JavaSql
include_package 'java.sql'
end

import 'com.splicemachine.db.jdbc.ClientDriver'

begin
    conn = JavaSql::DriverManager.getConnection("jdbc:splice://localhost:1527/splicedb");
    stmt = conn.createStatement
    rs = stmt.executeQuery("select a, b from MYTESTTABLE")
    counter = 0
    while (rs.next) do
        counter+=1
        puts "Record=[" + counter.to_s + "] a=[" + rs.getInt("a").to_s + "] b=[" + rs.getString("b") + "]"
    end
    rs.close
    stmt.close
    conn.close()
    rescue JavaLang::ClassNotFoundException => e
        stderr.print "Java told me: #{e}n"
    rescue JavaSql::SQLException => e
        stderr.print "Java told me: #{e}n"
end