Managing the Database Connection

%BooleanOpens in a new tab

This read-only property indicates if the adapter is currently connected.

%StringOpens in a new tab

An optional set of SQL connection attribute options. For ODBC, they have the form:

attr:val,attr:val

For example, AutoCommit:1.

For JDBC, they have the form

attr=val;attr=val

For example, TransactionIsolationLevel=TRANSACTION_READ_COMMITTED.

Set this property in the OnInit() method of your business operation or business service to specify the options to use at connection time.

%NumericOpens in a new tab

This property specifies the number of seconds to wait on each connection attempt. The default value is 5.

%NumericOpens in a new tab

This property specifies whether to stay connected to the remote system:

• For information on how the SQL inbound adapter uses this setting, see Specifying Other Runtime Settings for the SQL Inbound Adapter.

• For information on how the SQL outbound adapter uses this setting, see Specifying Other Runtime Settings for the SQL Outbound Adapter.

%StringOpens in a new tab

This data source name specifies the external data source to connect to. The following example shows the name of a DSN that refers to a Microsoft Access database:

accessplayground

Method Connect(pTimeout As %Numeric = 30) As %Status

Connects to the data source given by the current value of the DSN property.

Method Disconnect() As %Status

Disconnects from the data source.

Method TestConnection()

Tests the connection to the data source.