Registering the External Service Database
Use the ACC commands to register and update the external services.
To perform the initial registration of the service, run the following command in API Portal Cloud Controller:
register external service db url="jdbc:postgres://servername:port:databasename"
driverClassName=org.postgresql.Driver jmxEnabled=true maxActive=100 maxIdle=15 logAbandoned=true
rollbackOnReturn=true maxWait=10000 removeAbandoned=false defaultAutoCommit=false username=User Name
password=Paswordhost=servername
For example,
register external service DB host=machinename
url="jdbc:postgresql://machinename:5432/postgresdb"
driverClassName=org.postgresql.Driver jmxEnabled=true maxActive=100 maxIdle=15 logAbandoned=true
rollbackOnReturn=true maxWait=10000 removeAbandoned=false defaultAutoCommit=false
username=aris password=*ARIS!1dm9n#
The above command returns an external service identifier. For example, it returns the service Id as db0000000000. The service Id value increments everytime you register the database.
To get a list of all the external services that are currently registered, run the following command:
list external services
To review the properties of individual registered services, run the following command:
show external service serviceId