Is it possible to identify which client is performing operations on a database from the client identifier, which can be set via Oracle extensions?

book

Article ID: KB0092966

calendar_today

Updated On:

Products	Versions
TIBCO ActiveMatrix BusinessWorks	-
Not Applicable	-

Description

Resolution:
Passing a client identifier, which can be set via the Oracle extensions (http://docs.oracle.com/cd/B19306_01/network.102/b14266/apdvprxy.htm#i1010372), is not currently supported in BW.

Other options:

There is a Hawk method named ListDbConnections. This has been given as one of the TIBCO Hawk Microagent Methods in the BW documentation (https://docs.tibco.com/pub/activematrix_businessworks/5.11.0-november-2012/doc/html/tib_bw_administration/wwhelp/wwhimpl/common/html/wwhelp.htm#href=admin.5.73.htm&single=true) .

+++++++++++++++++

ListDbConnections:

Description:

Returns a list of all open and idle JDBC connections that have been opened by a single instance of ActiveMatrix BusinessWorks engine. This is the only function which you can get the opened connection in one BW engine. The output of that method looks like the following:

Connection-State Connection-Name User-Name Connection-Owner Idle-Time

Active /JDBC Connection.sharedjdbc tibco JDBC Call Procedure for 1000Job-1000 0