Create a Data Source for a DB System Database
Use the model Yaml templates to create a data source for an Oracle Cloud Infrastructure Database.
Following is an example of model Yaml template for app deployment with single-instance (SI) DB System data source properties:
Note:
The template files are located at/u01/shared/scripts/pipeline/templates
on the administration host.
resources:
JDBCSystemResource:
hellods:
Target: '@@ENV:RESOURCE_PREFIX@@-cluster'
JdbcResource:
JDBCDataSourceParams:
JNDIName: jdbc/hellods
JDBCDriverParams:
DriverName: oracle.jdbc.OracleDriver
URL: '@@SECRET:@@ENV:DOMAIN_UID@@-datasource-secret:url@@'
PasswordEncrypted: '@@SECRET:@@ENV:DOMAIN_UID@@-datasource-secret:password@@'
Properties:
user:
Value:
oracle.net.CONNECT_TIMEOUT:
Value: '120000'
SendStreamAsBlob:
Value: true
JDBCConnectionPoolParams:
InitialCapacity: 1
MaxCapacity: 1
TestTableName: SQL ISVALID
TestConnectionsOnReserve: true
You must set up the database to create a schema user before you create the data source and update . See Prerequisites to Create a Data Source.