Module: Spider::Model::Storage::Db::Connectors::OCI8::ClassMethods

Defined in:
lib/spiderfw/model/storage/db/connectors/oci8.rb

Instance Method Summary collapse

Instance Method Details

#connection_alive?(conn) ⇒ Boolean

Returns:

  • (Boolean)


24
25
26
27
28
29
30
31
# File 'lib/spiderfw/model/storage/db/connectors/oci8.rb', line 24

def connection_alive?(conn)
    begin
        conn.autocommit?
        return true
    rescue
        return false
    end
end

#disconnect(conn) ⇒ Object



20
21
22
# File 'lib/spiderfw/model/storage/db/connectors/oci8.rb', line 20

def disconnect(conn)
    conn.logoff
end

#new_connection(user, pass, dbname, role) ⇒ Object



13
14
15
16
17
18
# File 'lib/spiderfw/model/storage/db/connectors/oci8.rb', line 13

def new_connection(user, pass, dbname, role)
    conn ||= ::OCI8.new(user, pass, dbname, role)
    conn.autocommit = true
    conn.non_blocking = true
    return conn
end