We will need some help in troubleshooting the issue in setting the client information in v$session, for columns 'program' or 'client_info'
We defined resource in GlobalNamingResources in our sever.xml. I added connectionProperties attribute to set some client specific information in v$session.program and v$session.client_info columns. But v$session.program or v$session.client_info doesn't show the value configured in Resource.
This is how <Resource> tag look like in server.xml
<Resource
name="jdbc/ILOraclePool"
auth="Container"
factory="oracle.ucp.jdbc.PoolDataSourceImpl"
type="oracle.ucp.jdbc.PoolDataSource"
description="main DB"
connectionFactoryClassName="oracle.jdbc.pool.OracleDataSource"
connectionPoolName="ILOraclePool UCPPool"
url="jdbc:oracle:thin:@oaka-scan.ilnx.com:9101/dev2db"
user="user123"
password="user123"
initialPoolSize="3"
minPoolSize="1"
maxPoolSize="5"
connectionProperties="v$session.PROGRAM=Client1, v$session.CLIENT_INFO=Client1a" />
We are using following versions
Oracle Database : 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
Tomcat : 6.0.43
JDK : 1.7.0_80
Oracle UCP : 11.2.0.3
OJDBC7