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)


28
29
30
31
32
33
34
35
# File 'lib/spiderfw/model/storage/db/connectors/oci8.rb', line 28

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

#disconnect(conn) ⇒ Object



24
25
26
# File 'lib/spiderfw/model/storage/db/connectors/oci8.rb', line 24

def disconnect(conn)
    conn.logoff
end

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



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

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