Column | TDV JDBC Data Type | Nullable | Description |
SOURCE_ID | INTEGER | The data source’s resource ID. | |
SOURCE_NAME | VARCHAR(255) | The data source’s resource name. | |
SOURCE_TYPE | VARCHAR(60) | The data source’s data source type—for example, MySql. | |
SOURCE_CATEGORY | VARCHAR(60) | The data source category. Value can be RELATIONAL, FILE, or SERVICE. | |
OWNER_ID | INTEGER | The data source’s resource owner ID. | |
OWNER | VARCHAR(255) | The data source’s resource owner name. | |
PARENT_PATH | VARCHAR(65535) | Yes | The path of the data source resource. Can be NULL for system-owned data sources. |
STATUS | VARCHAR(20) | Data source current status: | |
DISABLED—Data source disabled. UP—Data source enabled and running. DOWN—Data source down when last tested. NOT_TESTED—Data source not tested; status unknown. | |||
NUM_REQUESTS | INTEGER | The number of requests processed since the server started. | |
ACTIVE_REQUESTS | INTEGER | The number of requests currently in progress. | |
MAX_CONN | INTEGER | The maximum size of the data source’s connection pool. | |
NUM_CURRENT_CONN | INTEGER | The current size of the data source’s connection pool. | |
NUM_IN_USE_CONN | INTEGER | The number of data source connections currently in use. | |
NUM_LOGINS | INTEGER | The number of times new connections were opened since the server started. | |
NUM_LOGOUTS | INTEGER | The number of times connections were closed since the server started. | |
BYTES_TO | BIGINT | The estimated number of bytes sent to the data source since the server started. | |
BYTES_FROM | BIGINT | The estimated number of bytes retrieved from the data source since the server started. | |
MESSAGE | VARCHAR(65535) | Yes | A message about the data source. NULL if no message is available. |