Database Connections
The Database Connections screen displays a list of all the connections that are currently open to databases and the driver of origin. For each connection the currently active request will be displayed.
Column definitions
Connection Headers
- Data Source - the name used in JDesignerPro to identify this database.
- Connection - the JDBC connection parameters used to make the database connection.
- Last Connection - the time of the last request made using this connection.
- Idle for - the amount of time since the last request was made.
- #Requests - the total number of requests that the user has made.
- Status - the current status of this connection (Active or Inactive).
Request Headers
- Request - the type of request (Either SQL, Invoke or some other task specific to JaggServer such as listing the files in a directory).
- Request Detail - the actual details of this request. In the case of an SQL the SQL command will be shown. In the case of Invoke the method being invoked will be shown.
- Last Connection - the time that this request was started.
- Duration - the amount of time that this request has been running.
- Priority - the thread priority of this request.
- Status - the current status of this request. This is either Active or Held.
Controlling Connections
Closing a connection
To close a connection click once on it. A popup menu will be displayed. Choose Close Connection. The connection will then be closed. If a request for this database comes in a new connection will automatically be opened by JaggServer and subsequently displayed on this screen when it is refreshed.
Adjusting the screen refresh interval
To adjust how often the connection list is refreshed click on a connection and choose Refresh Every from the popup menu. Then select the desired interval. The connections screen will then automatically refresh at the new interval. The screen will only refresh if it is visible. If another tab in the menu system is selected refreshing will not occur until the Server Manager is reselected and the Database Connections tab is selected. The screen will also automatically refresh each time the Database Connections tab is selected. Note that refreshing the screen continuously can cause an unnecessary load on the server. The default refresh rate is 60 seconds.
Controlling Requests
Holding and releasing a request
To hold a request that is currently running click once on it. A popup menu will be displayed. Choose Hold from the menu. The request is now held. To release the request click on it and choose Release from the popup menu. It is now once again active.
Killing a request
To kill a request that is currently active or held click once on it. A popup menu will be displayed. Choose Kill from the menu. The request will be killed. Note that there is no confirmation dialog when killing requests.
Adjusting the request priority
To adjust the request priority click once on the request. A popup menu will be displayed. Choose Set Priority and choose the desired priority. 10 is the highest priority, 1 is the lowest. That is, requests running at priority 10 will receive more system resources than those running at a lower priority.
Displaying details of a request
To display a detailed description of a request click once on the request. A popup menu will be displayed. Choose Display Details from the menu. The detail for the request will be display in the lower half of the screen. To hide the request details press the Hide Details button at the bottom of the screen.