Skip to main content

%XDBC.Gateway.ODBC.Connection

class %XDBC.Gateway.ODBC.Connection extends %XDBC.Gateway.Connection

FOR INTERNAL USE - do not invoke directly

Property Inventory

Method Inventory

Properties

property connection as %ObjectHandle;
Property methods: connectionGet(), connectionIsValid(), connectionSet()
property enviroment as %ObjectHandle;
Property methods: enviromentGet(), enviromentIsValid(), enviromentSet()
property gateway as %ObjectHandle;
Property methods: gatewayGet(), gatewayIsValid(), gatewaySet()

Methods

method Close()
Call Close (ODBC Disconnect) on connection
method Commit()
Makes all changes made since the previous commit/rollback permanent and releases any database locks currently held by this Connection object
method CreateStatement() as Statement
Creates a Statement object for sending SQL statements to the database
method GetAutoCommit() as %Boolean
Retrieves the current auto-commit mode for this Connection object
method GetConnectionAttribute(Attribute As %Integer, IsInteger As %Boolean) as %String
method GetInfo(Type As %Integer) as %String
Get connection information specifyed by Type
method GetMetaData() as %XDBC.Gateway.ODBC.DatabaseMetaData
Retrieves a DatabaseMetaData object that contains metadata about the database to which this Connection object represents a connection
classmethod GetODBCConnection(connectionInfo As %Library.DynamicObject) as %XDBC.Gateway.ODBC.Connection
method GetSchema() as %String
Retrieves this Connection object's current schema name
method GetTablePriviligies(Schema As %String, Table As %String) as ResultSet
method GetTables(Catalog As %String, Schema As %String, Table As %String) as ResultSet
method GetTransactionIsolation() as %Integer
Retrieves this Connection object's current transaction isolation level
classmethod InitEnvironment() as %ObjectHandle
method IsClosed() as %Boolean
Retrieves whether this Connection object has been closed
method IsReadOnly() as %Boolean
Retrieves whether this Connection object is in read-only mode
method IsValid(timeout As %Integer = 0) as %Boolean
Returns true if the connection has not been closed and is still valid
method PrepareCall(sql As %String) as Statement
Creates a Statement object for calling stored procedures
method PrepareStatement(sql As %String) as Statement
Creates a statement object for sending parameterized SQL statements to the database
method Rollback()
Undoes all changes made in the current transaction and releases any database locks currently held by this Connection object
method SetAttribute(Attribute As %Integer, Value As %String, IsInteger As %Boolean) as %Status
method SetAutoCommit(autoCommit As %Boolean)
Sets this connection's auto-commit mode to the given state
method SetReadOnly(readOnly As %Boolean)
Puts this connection in read-only mode as a hint to the driver to enable database optimizations
method SetSchema(schema As %String)
Sets the given schema name to access
method SetTransactionIsolation(level As %Integer)
Attempts to change the transaction isolation level for this Connection object to the one given level is 1, 2, 4 (Connection.TRANSACTION_REPEATABLE_READ) or 8 (Connection.TRANSACTION_SERIALIZABLE)

Inherited Members

Inherited Methods

FeedbackOpens in a new tab