The following table summarizes connection properties which can be used to return client information.

Table 1. Client information properties
Property Characteristic

AccountingInfo

Defines accounting information. This value is stored locally and is used for database administration/monitoring purposes.

Action

The current action (Select, Insert, Update, or Delete, for example) within the current module. This property sets the hostprocess column in the sysprocesses table and is used for database administration/monitoring purposes.

ApplicationName

The name of the application to be stored in the database. This property sets the program_name column in the sysprocesses table in the database.

BatchMechanism

Determines the mechanism that is used to execute batch operations.

If set to nativeBatch, the driver uses the native Oracle batch mechanism. The native batch mechanism does not return individual update counts for each statement or parameter set in the batch

If set to singleStatement, the driver uses the JDBC 3.0-compliant batch mechanism.

ClientHostName

The host name, or workstation ID, of the client machine to be stored in the database. This property sets the hostname column of the sysprocesses table in the database.

ClientID

Additional information about the client to be stored in the database. This property sets the CLIENT_IDENTIFIER column of the sysprocesses table in the database.

ClientUser

Specifies the user ID. This value is stored locally and is used for database administration/monitoring purposes.

Module

The module name to be stored in the database. This property sets the MODULE column of the sysprocesses table in the database and is used for database administration purposes.

ProgramID

The driver name and version information on the client to be stored in the database. This property sets the hostprocess column in the sysprocesses table.