skip to main content
Using the driver : Using connection properties : Client information properties
  

Try DataDirect Drivers Now

Client information properties

The following table summarizes connection properties which can be used to return client information.
Table 12. Client information properties
Property
Characteristic
Defines accounting information. This value is stored locally and is used for database administration/monitoring purposes.
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.
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.
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.
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.
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.
Specifies the user ID. This value is stored locally and is used for database administration/monitoring purposes.
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.
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.