JDBC Connection

Connections log data includes domain connections for JDBC connection types to backend data sources, if enabled. Check the detail pane for additional columns that may be available. Enable Payload to see payload data that may be available.

  • Time – the time and date stamp for the log entry.
  • Application ID – the unique identifier assigned to the registered application. Values may include a number, blank, or HWC, depending on the client type.
  • Application Connection ID – the unique identifier for a user application connection.
  • User ID – the ID of the user associated with the application ID. The user under the domain logs should be in the format "username@securityConfiguration".
  • Stage – the current stage of processing - START or FINISH.
  • Package – the name of the package to which the subscription belongs.
  • MBO – the mobile business object used.
  • Operation – the MBO operation.
  • Connection – the managed connection used.
  • Thread ID – the identifier for the thread used to process the request.
  • Node ID – the server node on which the request is received.
  • Error – the error message if any.
  • Transaction ID – a unique ID that represents a transaction (one cycle of request-response) performed by the client or application.
  • Root Context ID – a unique ID that represents a client/server session. A session can be thought of as a block that includes multiple requests from the client to the server.
Note: Payload and detail columns:
  • Input Parameters – the parameters used in a JDBC endpoint operation (payload). This will vary by operation.
  • Query – the SQL statement used in a JDBC endpoint operation (payload). This will vary by operation.
  • Device ID – the core and administrative (MMS) device ID.
  • Domain – the core and administrative (MMS) domain name.
  • Endpoint Name – the core and administrative (MMS) endpoint name.
  • Database Product Name – the remote database product name, such as "SQL Anywhere".
  • Database Product Version – the remote database version, such as "11.0.1.2044".
  • Driver Name – the database driver used, such as: "jConnect™ for JDBC™".
  • Driver Version – the database driver version, such as "jConnect™ for JDBC™/7.07 GA(Build 26666)/P/EBF19485/JDK 1.6.0/jdbcmain/Wed Aug 31 03:14:04 PDT 2011".
  • Database User Name – the database user account.
Parent topic: Connection Log