%XDBC.Gateway.JDBC.Connection

class %XDBC.Gateway.JDBC.Connection extends %XDBC.Gateway.Connection

FOR INTERNAL USE - do not invoke directly

Property Inventory

java
jdbcConnection

Method Inventory

%OnClose()
Close()
Commit()
CreateStatement()
GetAutoCommit()
GetJdbcConnection()
GetMetaData()
GetSchema()
GetTransactionIsolation()
IsClosed()
IsReadOnly()
IsValid()
PrepareCall()
PrepareStatement()
Rollback()
SetAutoCommit()
SetReadOnly()
SetSchema()
SetTransactionIsolation()

Parameters

parameter CONCURREADONLY = 1007;

parameter CONCURUPDATEABLE = 1008;

parameter FOREIGNCONNECTIONCLASS = com.intersystems.xdbc.gateway.ForeignConnection;

parameter TRANSACTIONNONE = 0;

A constant indicating that transactions are not supported.

parameter TRANSACTIONREADCOMMITTED = 2;

parameter TRANSACTIONREADUNCOMMITTED = 1;

parameter TRANSACTIONREPEATABLEREAD = 4;

parameter TRANSACTIONSERIALIZABLE = 8;

parameter TYPESCROLLFORWARDONLY = 1003;

parameter TYPESCROLLINSENSITIVE = 1004;

parameter TYPESCROLLSENSITIVE = 1005;

Properties

property java as %External.JavaGateway;

Property methods: javaGet(), javaGetSwizzled(), javaIsValid(), javaNewObject(), javaSet()

property jdbcConnection as %Net.Remote.Object;

Property methods: jdbcConnectionGet(), jdbcConnectionGetSwizzled(), jdbcConnectionIsValid(), jdbcConnectionNewObject(), jdbcConnectionSet()

Methods

method %OnClose() as %Status

Inherited description: This callback method is invoked by the %Close() method to provide notification that the current object is being closed.

The return value of this method is ignored.

method Close()

Releases this Connection object's database and resources immediately instead of waiting for them to be automatically released

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

classmethod GetJdbcConnection(connectionInfo As %Library.DynamicObject) as %XDBC.Gateway.JDBC.Connection

method GetMetaData() as DatabaseMetaData

Retrieves a DatabaseMetaData object that contains metadata about the database to which this Connection object represents a connection

method GetSchema() as %String

Retrieves this Connection object's current schema name

method GetTransactionIsolation() as %Integer

Retrieves this Connection object's current transaction isolation level

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, resultSetType As %Integer = ..#TYPESCROLLFORWARDONLY, resultSetConcurrency As %Integer = ..#CONCURREADONLY) 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 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)