skip to main content
Getting Started : Advanced Features : Using Client Information : How Databases Store Client Information : Storing Client Information
  
Storing Client Information
Your application can store client information associated with a connection using any of the following methods:
*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. See the individual driver chapters for a detailed description of each property. See Using the Drivers for information about specifying connection properties using a URL or a JDBC data source.
*Using the following JDBC methods:
Connection.setClientInfo(properties)
Connection.setClientInfo(property_name, value)
Refer to "JDBC Support" in the DataDirect Connect Series for JDBC Reference for more information about these JDBC methods.
*Using the JDBC extension methods provided in the com.ddtek.jdbc.extensions package. Refer to "JDBC Extensions" in the DataDirect Connect Series for JDBC Reference for more information about the com.ddtek.jdbc.extensions package.
Table 10. Database Locations for Storing Client Information
Property
Description
Database
Location
AccountingInfo
Additional information that may be used for accounting or troubleshooting purposes, such as an accounting ID
DB2
CURRENT CLIENT_ACCTNG register (DB2 for Linux/UNIX/Windows) or CLIENT ACCTNG register (DB2 for z/OS and DB2 for i)
Informix
Local cache
MySQL
Local cache
Oracle
CLIENT_INFO column in the V$SESSION table
PostgreSQL
Local cache
Progress OpenEdge
N/A
Microsoft Windows Azure SQL Database
N/A
Microsoft SQL Server
Local cache
Apache Hive
Local cache
Greenplum
Local cache
Sybase
Local cache
Action
The current action (Select, Insert, Update, or Delete, for example) within the current module
DB2
N/A
Informix
N/A
MySQL
N/A
Oracle
CLIENT_INFO column in the V$SESSION table
PostgreSQL
N/A
Progress OpenEdge
N/A
Microsoft Windows Azure SQL Database
N/A
Microsoft SQL Server
N/A
Sybase
N/A
Apache Hive
NA
Greenplum
N/A
ApplicationName
Name of the application currently using the connection
DB2
CURRENT CLIENT_APPLNAME register (DB2 for Linux/UNIX/Windows) or CLIENT APPLNAME register (DB2 for z/OS and DB2 for i). For DB2 V9.1 and higher for Linux/UNIX/Windows, it is also stored in the APPL_NAME column in the SYSIBMADM.APPLICATIONS table.
Informix
Local cache
MySQL
Local cache
Oracle
dbms_session value. In addition, it is also stored in the PROGRAM column in the V$SESSION table.
PostgreSQL
Local cache
Progress OpenEdge
N/A
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.
Sybase
clientapplname and program_name column in sysprocesses table
Apache Hive
Local cache
Greenplum
Local cache
ClientHostName
Host name of the client on which the application using the connection is running
DB2
CURRENT CLIENT_WRKSTNNAME register (DB2 for Linux/UNIX/Windows) or CLIENT WRKSTNNAME register (DB2 for z/OS and DB2 for i)
Informix
Local cache
MySQL
Local cache
Oracle
MACHINE column in the V$SESSION table
PostgreSQL
Local cache
Progress OpenEdge
N/A
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.
Sybase
clienthostname and hostname column in the sysprocesses table
Apache Hive
Local cache
Greenplum
Local cache
ClientID
Additional information about the client to be stored in the database
DB2
N/A
Informix
N/A
MySQL
N/A
Oracle
For Oracle9i R1 (9.0.1) and higher, the CLIENT_IDENTIFIER column in the V$SESSION table
PostgreSQL
N/A
Progress OpenEdge
N/A
Microsoft Windows Azure SQL Database
N/A
Microsoft SQL Server
N/A
Sybase
N/A
Apache Hive
N/A
Greenplum
N/A
ClientUser
User ID for whom the application using the connection is performing work
DB2
CURRENT CLIENT_USERID register (DB2 for Linux/UNIX/Windows) or CLIENT USERID register (DB2 for z/OS and DB2 for i)
Informix
Local cache
MySQL
Local cache
Oracle
OSUSER column in the V$SESSION table
PostgreSQL
Local cache
Progress OpenEdge
N/A
Microsoft Windows Azure SQL Database
N/A
Microsoft SQL Server
Local cache
Sybase
clientname column in sysprocesses table
Apache Hive
Local cache
Greenplum
Local cache
ProgramID
Driver name and version on the client
DB2
CLIENT_PRDID value. For DB2 V9.1 and higher for Linux/UNIX/Windows, it is located in the SYSIBMADM.APPLICATIONS table.
Informix
Local cache
MySQL
Local cache
Oracle
PROCESS column in the V$SESSION table
PostgreSQL
Local cache
Progress OpenEdge
N/A
Microsoft Windows Azure SQL Database
N/A
Microsoft SQL Server
For Microsoft SQL Server 2000 and higher, the hostprocess column in the sysprocesses table. For Microsoft SQL Server 7, local cache.
Sybase
hostprocess column in the sysprocesses table
Apache Hive
Local cache
Greenplum
Local cache
Module
The module name to be stored in the database
DB2
N/A
Informix
N/A
MySQL
N/A
Oracle
The MODULE column in the V$SESSION table
PostgreSQL
N/A
Progress OpenEdge
N/A
Microsoft Windows Azure SQL Database
N/A
Microsoft SQL Server
N/A
Sybase
N/A
Apache Hive
N/A
Greenplum
N/A