Open topic with navigation
A pseudo table.
SYSTEM.LOCALCONNECTIONS is similar to the pseudo table
SYSTEM.CONNECTIONS, except it only lists connections to the same transaction engine (TE) to which the current client is connected. The
SYSTEM.LOCALCONNECTIONS pseudo table does not include some columns that are defined for the
SYSTEM.CONNECTIONS pseudo table.
Caution: Client applications should never contain code that accesses
SYSTEM pseudo tables as they are subject to, and furthermore likely to, change from release to release.
SQL statement being executed. If the connection is currently active,
but no statement is executing, the
|RUNTIME||bigint||The duration of the statement execution specified in microseconds.|
|USER||string||The SQL user for the database connection.|
|SCHEMA||string||The current SQL schema for the database connection.|
|NUMPARAM||integer||The number of SQL parameters specified in the query. This is
Parameter string — A string representing the parameters specified in the query. The string representing each parameter is of the format:
Each parameter string is separated by a space. For example:
NUMPARAM PARAMS --------- ---------------------------- 2 0/string/'hello' 1/integer/
|CONNID||integer||A unique identifier for the connection.|
|OPEN||integer||The number of open statements created using this connection.|
identifier, unique only to the specific connection, that represents the
|OPENRESULTS||integer||The number of open result sets for this connection.|
|TRANSID||bigint||The identifier for the transaction being run on the connection. This value can be used to query
|TRANSRUNTIME||bigint||The duration of the current open transaction on the connection, specified in microseconds.|
A bitwise mapping of the following values
Specifies the transaction isolation level for the connection:
Specifies the IP address for the connecting client. As of NuoDB 2.3.2, the TE will supply this with information from the socket it uses for communicating with the client.
Prior to NuoDB 2.3.2, you could set this with a connection property called
the process ID (pid) for the connecting client. This may be set
automatically by the driver (as of NuoDB 2.3.2 this is true for the C++,
.NET, and Python drivers.) Otherwise, this must be given as the client
|CLIENTINFO||string||Specifies the client information for the connecting client. This must be given as the client connection property