Registering the External Service Database

1. In API Portal Cloud Controller, run the following commands:

register external service db url="jdbc:oracle:thin:@
servername:port/servicename"
driverClassName=oracle.jdbc.OracleDriver jmxEnabled=true maxActive=100
maxIdle=15 logAbandoned=true rollbackOnReturn=true maxWait=10000
removeAbandoned=false defaultAutoCommit=false
username=Application Username password=Application User password
host=servername

For example

register external service db url="jdbc:oracle:thin:@
machinename:1521/ORCL"
driverClassName=oracle.jdbc.OracleDriver jmxEnabled=true maxActive=100
maxIdle=15 logAbandoned=true rollbackOnReturn=true maxWait=10000
removeAbandoned=false defaultAutoCommit=false
username=dbuser107 password=dbuser107123
host=machinename

An external service identifier is returned once the above command is executed, for example, it returns the service id as db0000000000.