How many sources does your query involve? If there is only single source involved then there may not be a transaction involved. For checking it is the case try adding autoCommitTxn=ON and use autoCommit = true on your jdbc connection. This should force a transaction on every query. Note you would have to define XA datasource for your connection to your source.
As per the sourceCommandID, this is sequence id as to how many source requests that to Teiid engine is making to a source in the scope of a given query, also serves as identifier of that source query.
Thanks for your prompt reply. I have a couple of quick questions. With the above settings I am able to see the following attributes getting logged.
time, requestId, txID, sessionId, applicationName, principal, vdbName, vdbVersion, sql.
Could you please point me to more documentation on "requestId", "txID", "sessionId" ? If you cannot point to specific references, any explanation from you would be of tremendous help.
Now in the log for the txID, I see the structure given below. Could you shed more light on this txID's BasicAction structure ? What does it mean by ActionStatus:RUNNING ?
txID=TransactionImple < ac, BasicAction: 0:ffff22ee5453:-228bbdba:5076064a:222 status: ActionStatus.RUNNING >
Thanks for your help.
requestId = Request ID. Every query you submit has unique identifier it shows that
txID = Transaction ID, if distributed trasaction started then it show that number
sessionId = Session ID; Every connection gets a unique sesion id; A user identified with it
applicationName = You can assign a custom name during the connection to identify a the type connection
principal = Name of user logged in
txnId = string form of javax.transaction.Transaction object. I am not sure what internal status really mean. Running = txn active?