dbconn.rb

class DbConnection
  require "jruby"  
  attr_reader :conn
  require 'jdbc/sybase-jconnect-5.5.jar'
  @@connection = nil
  def initialize
    java.lang.Thread.currentThread.setContextClassLoader(JRuby.runtime.jruby_class_loader)
    import java.sql.Statement
    import java.sql.Connection
    import java.sql.SQLException
    import java.sql.Types
    import java.sql.DriverManager
    DriverManager.registerDriver Java::com.sybase.jdbc2.jdbc.SybDriver.new
    @conn = DriverManager.getConnection("#{CONFIG['database']['url']}?user=#{CONFIG['database']['username']}&password=#{CONFIG['database']['password']}")
  end
  
  def query(sql, limit=CONFIG["global_options"]["maximum_results"])
    stmt = @conn.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY)
    stmt.setFetchSize(limit)
    rs = stmt.executeQuery(sql)
    return rs
  end
  
  def self.create
    unless @@connection
      @@connection = self.new
    end
    @@connection
  end
  
  def close
    @conn.close
  end
end