#!/usr/bin/jruby

require 'java'
require 'rubygems'
require '/home/ap/.henplus/lib/db2jcc.jar'
require '/home/ap/.henplus/lib/db2jcc_license_cu.jar'

url="jdbc:db2://127.0.0.1:50000/MYTESTDB"
user="db2inst1"
pass="itsasecret"

odriver = Java::JavaClass.for_name("com.ibm.db2.jcc.DB2Driver")
print "Connecting... "
conn = java.sql.DriverManager.getConnection(url, user, pass)
print "selecting... "
stmt = conn.createStatement
rs = stmt.executeQuery("select 'ABCD' FROM SYSIBM.SYSDUMMY1")
while (rs.next) do
  print rs.getString('1')
end
sleep 5
rs.close
stmt.close
conn.close()
puts " DONE"