|
Parameter
|
Type
|
Description
|
|
INPUT
|
|
|
|
iInfoType
|
int
|
Option – see Table 73. |
|
OUTPUT
|
|
|
|
sInfoValue
|
StringBuffer
|
Buffer into which to return the data. |
|
RETURN
|
|
|
|
|
int
|
OADS_SUCCESS – if the requested option is supported.
OADS_ERROR – error occurred in obtaining the requested information.
|
|
iInfoType
|
Description
|
|
OADS_CONN_INFO_AUTOCOMMIT
|
An integer value indicating whether auto commit is on or off.
SQL_AUTOCOMMIT_OFF (0) – Auto-commit is off. Transactions must be explicitly committed.
SQL_AUTOCOMMIT_ON (1) – Auto-commit is on. The data source will implicitly commit transactions after a statement is executed.
|
|
OADS_CONN_INFO_CLIENT_ADDRESS
|
Connection level information. Returns the local IP address of the client as a string of the form "ddd.ddd.ddd.ddd" (for example, "100.23.24.25"). The value is a string of maximum 128 characters. This option can be used while running in client-server mode to implement a client IP-based authentication scheme.
|
|
OADS_CONN_INFO_CLIENT_APPLICATION
|
Connection level information indicating the name of the client application on this connection. The value is an ASCII string of maximum length 128.
|
|
OADS_CONN_INFO_CURRENT_QUALIFIER
|
The current qualifier/database. If not applicable, it returns an empty string.
|
|
OADS_CONN_INFO_CLIENT_PUBLIC_ADDRESS
|
Connection level information. Returns the public IP address of the client as a string of the form "ddd.ddd.ddd.ddd" (for example, "100.23.24.25"). The value is a string of maximum 128 characters. This option can be used while running in client-server mode to implement a client IP-based authentication scheme.
|
|
OADS_CONN_INFO_CLIENT_TYPE
|
Connection level information indicating the OpenAccess SDK client type for this connection. The value is a short integer. The possible values are:
• DAM_CLIENTTYPE_ODBC
• DAM_CLIENTTYPE_JDBC
• DAM_CLIENTTYPE_OLEDB
• DAM_CLIENTTYPE_NET
|
|
OADS_CONN_INFO_TXN_ISOLATION
|
An integer value indicating the transaction isolation level.
SQL_TXN_READ_UNCOMMITTED (1) – Dirty reads, non-repeatable reads, and phantom reads are possible.
SQL_TXN_READ_COMMITTED (2) –Dirty reads are not possible. Non-repeatable reads and phantom reads are possible. This is the default.
SQL_TXN_REPEATABLE_READ (4) – Dirty reads and reads that cannot be repeated are not possible. Phantoms are possible.
SQL_TXN_SERIALIZABLE (8) – Transactions can be serialized. Dirty reads, non-repeatable reads, and phantoms are not possible.
|