Use @@IDENTITY to get the last inserted id
# File lib/sequel/adapters/jdbc/sqlanywhere.rb, line 45 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