module Sequel::JDBC::DB2::DatabaseMethods

Private Instance Methods

convert_clob(r, i) click to toggle source
# File lib/sequel/adapters/jdbc/db2.rb, line 72
def convert_clob(r, i)
  if v = r.getClob(i)
    v = v.getSubString(1, v.length)
    v = Sequel::SQL::Blob.new(v) if use_clob_as_blob
    v
  end
end
last_insert_id(conn, opts=OPTS) click to toggle source
# File lib/sequel/adapters/jdbc/db2.rb, line 51
def last_insert_id(conn, opts=OPTS)
  statement(conn) do |stmt|
    sql = "SELECT IDENTITY_VAL_LOCAL() FROM SYSIBM.SYSDUMMY1"
    rs = log_connection_yield(sql, conn){stmt.executeQuery(sql)}
    rs.next
    rs.getLong(1)
  end
end
primary_key_index_re() click to toggle source

Primary key indexes appear to be named sqlNNNN on DB2

# File lib/sequel/adapters/jdbc/db2.rb, line 61
def primary_key_index_re
  /\Asql\d+\z/i
end
set_ps_arg(cps, arg, i) click to toggle source
Calls superclass method
# File lib/sequel/adapters/jdbc/db2.rb, line 38
def set_ps_arg(cps, arg, i)
  case arg
  when Sequel::SQL::Blob
    if use_clob_as_blob
      cps.setString(i, arg)
    else
      super
    end
  else
    super
  end
end
setup_type_convertor_map() click to toggle source
Calls superclass method
# File lib/sequel/adapters/jdbc/db2.rb, line 65
def setup_type_convertor_map
  super
  map = @type_convertor_map
  types = Java::JavaSQL::Types
  map[types::NCLOB] = map[types::CLOB] = method(:convert_clob)
end