How do I verify that my JDBC session timeout is in effect?
Article ID: KB0081063
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | v 7.0.0 and higher |
Description
How do I verify that my JDBC session timeout is in effect?
Issue/Introduction
How do I verify that my JDBC session timeout is in effect?
Resolution
The JDBC session timeout is decided by the following setting in Studio :
Administration >> Configuration >> Server >> Client Drivers >> Session >> "Default Session Timeout"
You can verify that the timeout is in effect by running a query on the SYS_SESSIONS table (to list the JDBC sessions), and looking at the TIMEOUT_DURATION column in the results. The TIMEOUT_DURATION column should contain the value that you set for the Default Session Timeout, in milliseconds.
Below is an example for a Default Session Timeout of 18 seconds.
SELECT *
FROM /services/databases/system/SYS_SESSIONS ss
WHERE ss.SESSION_TYPE = 'JDBC'
Result:
STATUS : TIMED_OUT
TIMEOUT_DURATION : 18000
ACTIVE_REQUESTS : 0
Administration >> Configuration >> Server >> Client Drivers >> Session >> "Default Session Timeout"
You can verify that the timeout is in effect by running a query on the SYS_SESSIONS table (to list the JDBC sessions), and looking at the TIMEOUT_DURATION column in the results. The TIMEOUT_DURATION column should contain the value that you set for the Default Session Timeout, in milliseconds.
Below is an example for a Default Session Timeout of 18 seconds.
SELECT *
FROM /services/databases/system/SYS_SESSIONS ss
WHERE ss.SESSION_TYPE = 'JDBC'
Result:
STATUS : TIMED_OUT
TIMEOUT_DURATION : 18000
ACTIVE_REQUESTS : 0
Feedback
Yes
No
Powered by
