# File lib/sequel/adapters/jdbc/oracle.rb, line 84 def primary_key_index_re PRIMARY_KEY_INDEX_RE end
# File lib/sequel/adapters/jdbc/oracle.rb, line 40 def self.extended(db) db.instance_eval do @autosequence = opts[:autosequence] @primary_key_sequences = {} end end
Oracle exception handling with SQLState is less accurate than with regexps.
# File lib/sequel/adapters/jdbc/oracle.rb, line 50 def database_exception_use_sqlstates? false end
Default the fetch size for statements to 100, similar to the oci8-based oracle adapter.
# File lib/sequel/adapters/jdbc/oracle.rb, line 59 def default_fetch_size 100 end
# File lib/sequel/adapters/jdbc/oracle.rb, line 54 def disconnect_error?(exception, opts) super || exception.message =~ /\AClosed Connection/ end
# File lib/sequel/adapters/jdbc/oracle.rb, line 63 def last_insert_id(conn, opts) unless sequence = opts[:sequence] if t = opts[:table] sequence = sequence_for_table(t) end end if sequence sql = "SELECT #{literal(sequence)}.currval FROM dual" statement(conn) do |stmt| begin rs = log_yield(sql){stmt.executeQuery(sql)} rs.next rs.getInt(1) rescue java.sql.SQLException nil end end end end
Primary key indexes appear to start with sys_ on Oracle
# File lib/sequel/adapters/jdbc/oracle.rb, line 84 def primary_key_index_re PRIMARY_KEY_INDEX_RE end
# File lib/sequel/adapters/jdbc/oracle.rb, line 88 def schema_parse_table(*) sch = super sch.each do |c, s| if s[:type] == :decimal && s[:scale] == -127 s[:type] = :integer elsif s[:db_type] == 'DATE' s[:type] = :datetime end end sch end
# File lib/sequel/adapters/jdbc/oracle.rb, line 100 def schema_parse_table_skip?(h, schema) super || (h[:table_schem] != current_user unless schema) end
# File lib/sequel/adapters/jdbc/oracle.rb, line 109 def setup_type_convertor_map super @type_convertor_map[:OracleDecimal] = TypeConvertor::INSTANCE.method(:OracleDecimal) end
As of Oracle 9.2, releasing savepoints is no longer supported.
# File lib/sequel/adapters/jdbc/oracle.rb, line 105 def supports_releasing_savepoints? false end