1. REST API for Server Manager Guide
  2. jdbjpooledconnections

jdbjpooledconnections

API Name

jdbjpooledconnections

Description

Displays the details of JDBj Pooled Database connections of the HTML Server.

REST Methods

GET

Precondition

Server Manager and Agent must be running.

Input Params

instanceName Note (Release 9.2.4.3): Add these additional parameters if there are duplicate instance names: agentHostName, jdeHome.

Sample Request

This is the sample request if you have multiple instance names: https://jdesmc.example.com:8998/manage/mgmtrestservice/ jdbjpooledconnections?instanceName=tqa_923_lnx_jas_jdejas_ 21502&agentHostName=jdejas.example.com&jdeHome=/slot/oracle/jde_agent_jas/SCFHA

Return

HTTP status 200 is returned.

Sample Response

{ "instanceName":"JasVohs8009", "jdbjPooledDatabaseConnections": { "totalPooledConnections":"30", "jdbjPooledDbConnectionList": [ { "webserver":"JasVohs8009_MS1", "jdbjConnectionURL":"JDEORCL_ SY920", "pooledDbConnectionCount": "5" }, { "webserver": "JasVohs8009_MS1", "jdbjConnectionURL":"jdeorcl_SY920", "pooledDbConnectionCount":"5" }, { "webserver":"JasVohs8009_MS1", "jdbjConnectionURL": "jdeorcl_PY920", "pooledDbConnectionCount": "5" }, { "webserver":"JasVohs8009_MS1", "jdbjConnectionURL": "jdeorcl_JDE", "pooledDbConnectionCount": "5" }, { "webserver": "JasVohs8009_MS1", "jdbjConnectionURL":"jdeorcl_OL920", "pooledDbConnectionCount":"5" }, { "webserver": "JasVohs8009_MS1", "jdbjConnectionURL":"jdeorcl_DD920", "pooledDbConnectionCount": "5" } ] }}

Exception

Throws an exception if the operation fails for any reason.