Module Sequel::JDBC::HSQLDB::DatabaseMethods
In: lib/sequel/adapters/jdbc/hsqldb.rb

Instance methods for HSQLDB Database objects accessed via JDBC.

Methods

Included Modules

::Sequel::JDBC::Transactions

Public Instance methods

HSQLDB uses the :hsqldb database type.

[Source]

    # File lib/sequel/adapters/jdbc/hsqldb.rb, line 12
12:         def database_type
13:           :hsqldb
14:         end

The version of the database, as an integer (e.g 2.2.5 -> 20205)

[Source]

    # File lib/sequel/adapters/jdbc/hsqldb.rb, line 23
23:         def db_version
24:           @db_version ||= begin
25:             v = get{DATABASE_VERSION(){}}
26:             if v =~ /(\d+)\.(\d+)\.(\d+)/
27:               $1.to_i * 10000 + $2.to_i * 100 + $3.to_i
28:             end
29:           end
30:         end

HSQLDB uses an IDENTITY sequence as the default value for primary key columns.

[Source]

    # File lib/sequel/adapters/jdbc/hsqldb.rb, line 18
18:         def serial_primary_key_options
19:           {:primary_key => true, :type => :integer, :identity=>true, :start_with=>1}
20:         end

[Validate]