List Connection Pool Command

Use the listConnectionpool command to create a list of connection pools in JSON format for a specific service instance.

Use the listConnectionpool command and the updateConnectionpool utility when you need to update more than one connection pool.

You execute the utility through a launcher script, datamodel.sh on UNIX and datamodel.cmd on Windows.

If the domain is installed in default folder then the location of the launcher script looks like the following:

Oracle_Home/user_projects/domains/Domain_Name/bitools/bin/datamodel.sh or datamodel.cmd on Windows

If the client install doesn't have domain names, the launcher script location is as follows:

Oracle_Home\bi\bitools\bin\datamodel.cmd

See What You Need to Know Before Using the Command for more information.

Syntax

The listConnectionpool command takes the following parameters:

listConnectionpool -SI <service_instance> -U <cred_username> [-P <cred_password>] [-S <hostname>] [-N <port_number>] [-V <true/false>] [-O <outputFile.json>] [-SSL] [-H]

Where

SI specifies the name of the service instance.

U specifies a valid user's name to be used for Oracle BI EE authentication.

P specifies the password corresponding to the user's name that you specified for U. If you do not supply the password, then you are prompted for the password when the command is run. Oracle recommends that you include a password in the command only if you are using automated scripting to run the command.

S specifies the Oracle BI EE host name. Only include this option when you are running the command from a client installation.

N specifies the Oracle BI EE port number. Only include this option when you are running the command from a client installation.

V specifies whether to include repository variables used in the connection pool. Note that the default is false.

O specifies the output file name with the .json suffix.

SSL specifies to use SSL to connect to the Oracle WebLogic Server to run the command. Only include this option when you are running the command from a client installation.

H displays the usage information and exits the command. Use -H or run .sh without any parameters to display the help content.

Example

datamodel.sh listConnectionpool -SI bi -U weblogic -P password -S server1.example.com -N 7777 -SSL -V true -O output.json

Sample JSON List Connection Pool Output

{    "Title":"List Connection Pools",
   "Conn-Pool-Info":[
       {
           "uid":"80ca62c5-0bd5-0000-714b-e31d00000000",
           "connPool":"SampleApp_Lite_Xml",
           "parentName":"\"Sample App Lite Data\"",
           "user":"VALUEOF(REPO_STATIC_VAR)_Tushar",
           "password":"B25F85BC2A170AD4349DEF26E4D1295D 7C2E35213306F12832914CBE7A9DD95561D771DED06484112B1FC6F27B6D0D58",
           "dataSource":"VALUEOF(NQ_SESSION.SERVICEINSTANCEROOT)/data/SampleAppLite"
       }
   ],
   "Variables-In-Conn-Pool":[
       {
           "uid":"40000000-3c25-155b-991a-0af2537d0000",
           "variable":"REPO_STATIC_VAR",
           "value":"'RepoStaticVariable'"
       }
   ]}