module Sequel::JDBC::SqlAnywhere::DatabaseMethods

Private Instance Methods

last_insert_id(conn, opts=OPTS) click to toggle source

Use @@IDENTITY to get the last inserted id

# File lib/sequel/adapters/jdbc/sqlanywhere.rb, line 44
def last_insert_id(conn, opts=OPTS)
  statement(conn) do |stmt|
    sql = 'SELECT @@IDENTITY'
    rs = log_connection_yield(sql, conn){stmt.executeQuery(sql)}
    rs.next
    rs.getLong(1)
  end
end