Using the driver connection properties listed in the following table. This table lists the connection properties your application can use to store client information and where that client information is stored for each database. For information about specifying connection properties using a URL or a JDBC data source, refer to the user's guide for your driver
Using the following JDBC methods:
Connection.setClientInfo(properties)
Connection.setClientInfo(property_name, value)
Using the JDBC extension methods provided in the com.ddtek.jdbc.extensions package. See "JDBC Extensions" for more information about the com.ddtek.jdbc.extensions package.
|
Property
|
Description
|
Database
|
Location
|
|
AccountingInfo
|
Additional information that may be used for accounting or troubleshooting purposes, such as an accounting ID
|
Amazon Redshift
|
Local cache
|
|
Apache Hive
|
Local cache
|
||
|
Apache Spark SQL
|
Local cache
|
||
|
Oracle
|
CLIENT_INFO column in the V$SESSION table
|
||
|
Microsoft Windows Azure SQL Database
|
N/A
|
||
|
Microsoft SQL Server
|
Local cache
|
||
|
Action
|
The current action (Select, Insert, Update, or Delete, for example) within the current module
|
Amazon Redshift
|
N/A
|
|
Apache Hive
|
N/A
|
||
|
Apache Spark SQL
|
N/A
|
||
|
Oracle
|
CLIENT_INFO column in the V$SESSION table
|
||
|
Microsoft Windows Azure SQL Database
|
N/A
|
||
|
Microsoft SQL Server
|
N/A
|
||
|
ApplicationName
|
Name of the application currently using the connection
|
Amazon Redshift
|
Local cache
|
|
Apache Hive
|
Local cache
|
||
|
Apache Spark SQL
|
Local cache
|
||
|
Oracle
|
dbms_session value. In addition, it is also stored in the PROGRAM column in the V$SESSION table.
|
||
|
Microsoft Windows Azure SQL Database
|
N/A
|
||
|
Microsoft SQL Server
|
For Microsoft SQL Server 2000 and higher, program_name column in the sysprocesses table. For Microsoft SQL Server 7, local cache.
|
||
|
ClientHostName
|
Host name of the client on which the application using the connection is running
|
Amazon Redshift
|
Local Cache
|
|
Apache Hive
|
Local cache
|
||
|
Apache Spark SQL
|
Local cache
|
||
|
Oracle
|
MACHINE column in the V$SESSION table
|
||
|
Microsoft Windows Azure SQL Database
|
N/A
|
||
|
Microsoft SQL Server
|
For Microsoft SQL Server 2000 and higher, hostname column in the sysprocesses table. For Microsoft SQL Server 7, local cache.
|
||
|
ClientID
|
Additional information about the client to be stored in the database
|
Amazon Redshift
|
N/A
|
|
Apache Hive
|
N/A
|
||
|
Apache Spark SQL
|
N/A
|
||
|
Oracle
|
For Oracle9i R1 (9.0.1) and higher, the CLIENT_IDENTIFIER column in the V$SESSION table
|
||
|
Microsoft Windows Azure SQL Database
|
N/A
|
||
|
Microsoft SQL Server
|
N/A
|
||
|
ClientUser
|
User ID for whom the application using the connection is performing work
|
Amazon Redshift
|
Local cache
|
|
Apache Hive
|
Local cache
|
||
|
Apache Spark SQL
|
Local cache
|
||
|
Oracle
|
OSUSER column in the V$SESSION table
|
||
|
Microsoft Windows Azure SQL Database
|
N/A
|
||
|
Microsoft SQL Server
|
Local cache
|
||
|
ProgramID
|
Driver name and version on the client
|
Amazon Redshift
|
Local cache
|
|
Apache Hive
|
Local cache
|
||
|
Apache Spark SQL
|
Local cache
|
||
|
Oracle
|
PROCESS column in the V$SESSION table
|
||
|
Microsoft Windows Azure SQL Database
|
N/A
|
||
|
Microsoft SQL Server
|
For Microsoft SQL Server 2000 and higher, the hostprocess column in the sysprocesses table.
|
||
|
Module
|
The module name to be stored in the database
|
Amazon Redshift
|
N/A
|
|
Apache Hive
|
N/A
|
||
|
Apache Spark SQL
|
N/A
|
||
|
Oracle
|
The MODULE column in the V$SESSION table
|
||
|
Microsoft Windows Azure SQL Database
|
N/A
|
||
|
Microsoft SQL Server
|
N/A
|