- style
createOrUpdateDataSources
Creates or updates the data sources that are defined by properties files. The properties files will be processed for property replacement using ${{VARIABLE_NAME}}
format. See the Appendix for more information about property replacement.
Environment/Instance Properties
Property Name | Required | Description |
---|---|---|
FDWLS_WEBLOGIC_HOME | Yes | WebLogic Home Directory. (e.g. /u01/oracle/products/fmw/wlserver) |
FDWLS_DOMAIN_NAME | Yes | WebLogic Domain Name. |
FDWLS_ADMIN_LISTEN_ADDRESS | Yes | The listener address of the WLS admin server. (e.g. localhost) |
FDWLS_ADMIN_LISTEN_PORT | Yes | The port of the WLS admin server. (e.g. 7001) |
FDWLS_ADMIN_USE_SSL | No | Indicates whether the admin server is using SSL. |
FDWLS_ADMIN_USER | Yes | The user name for the WLS admin server. |
FDWLS_ADMIN_PASSWORD | Yes | The password for FDWLS_ADMIN_USER. |
FDWLS_ADMIN_DOMAIN_DIRECTORY | No | WebLogic Domain Directory for AdminServer. Used when the admin server runs from a different domain folder than managed servers |
FDWLS_DOMAIN_DIRECTORY | Yes | WebLogic Domain Directory for managed servers. |
Project Properties
Property Name | Required | Description |
---|---|---|
|
|
|
Inputs
Input Name | Required | Description |
---|---|---|
FILE_PATH_TO_PROPERTIES | No | Comma-separated Paths to the properties file(s) or folders containing properties files. |
Outputs
Output Name | Required | Description |
---|---|---|
FDWLS_OUT_IS_RESTART_REQUIRED | No | A |
Artifacts
This operation consumes properties-file artifacts.
Endpoint Selection
This operation will select all available endpoints associated to the environment instance which have a resource type of WLS Admin Server
. Since the admin server only runs on one server, it is expected that for a given domain, there will only be one endpoint with a resource type set to WLS Admin Server
.
Endpoint Execution
This operation will execute on the Admin Server endpoint selected using the WLS Admin Server
resource type.
Special Considerations
If FILE_PATH_TO_PROPERTIES
is not specified, the FD_ARTIFACTS_DIR
folder will be used. If a relative path is specified, the path will be relative to the FD_ARTIFACTS_DIR
directory.
WebLogic configuration files including Data Sources are backed up to FD_TEMP_DIR/configbackup
before modifications. As with all files in the endpoint working directory, these files will be saved for 3 days before being deleted.
It is important to set up the properties files like the examples below.
Example Folder Structure
- Properties file can be named as per your requirements. See Properties File Format.
- datasources.properties – This is the main properties file. The path to it is referenced by FILE_PATH_TO_PROPERTIES.
- DEV/datasources.properties - optionally create a file here and override some properties with it per environment. The filename must match.
- PROD/datasources.properties - optionally have several environments.
- Sub folder names for environment overrides must be FlexDeploy environment code.
Example Property File
This sample file defines two simple data sources with a sub-set of the available properties.
DSList=DS1,DS2 DS1.DataSourceType=Generic DS1.URL=jdbc:oracle:thin:@localhost:1521:xe DS1.ConnectionClass=oracle.jdbc.OracleDriver DS1.DSName=DS1 DS1.User=${{FLX_DB_USER_FDADMIN}} DS1.Targets=MS1 DS1.JNDINames=jdbc/DS1 DS1.Password=${{FLX_DB_PASSWORD_FDADMIN}} DS1.MinCapacity=0 DS2.DataSourceType=Generic DS2.URL=jdbc:oracle:thin:@localhost:1521:xe DS2.ConnectionClass=oracle.jdbc.OracleDriver DS2.DSName=DS2 DS2.User=${{FLX_DB_USER_FDADMIN}} DS2.Targets=MS1 DS2.JNDINames=jdbc/DS2 DS2.Password=${{FLX_DB_PASSWORD_FDADMIN}} DS2.MinCapacity=0
Example Gridlink Datasource Property File
This sample file defines a GridLink datasource with a sub-set of the available properties. It could be combined with other datasources in one file, but is separate here for clarity.
DSList=gridlinkDS1 gridlinkDS1.DataSourceType=GridLink gridlinkDS1.ConnectionClass=oracle.jdbc.OracleDriver gridlinkDS1.DSName=testName1 gridlinkDS1.Targets=AdminServer gridlinkDS1.JNDINames=test/karl1 gridlinkDS1.TestConnectionsOnReserve=true gridlinkDS1.URL=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=databaseserverhostname)(PORT=1521)))(CONNECT_DATA=(SID=fmt01))) gridlinkDS1.DatabaseName=fmt01 gridlinkDS1.User=system gridlinkDS1.Password=************ gridlinkDS1.InitialCapacity=15 gridlinkDS1.MaxCapacity=50
Properties File Format
Multiple data sources can be defined in the properties file. The properties file must start with a list of data sources present in the format DSList=ds1,ds2,ds3
. Change ds1, ds2, ds3
to names that make sense for your project. Any number of data sources is acceptable. The properties files will be processed for property replacement using ${{VARIABLE_NAME}}
format. See the Appendix for more information about property replacement.
Required Properties
At a minimum, each data source must contain these properties:
Property Name | Description |
---|---|
DataSourceType | Generic or GridLink (GridLink is supported on WebLogic 12c+ only) |
URL | The full JDBC connection URL |
ConnectionClass | The JDBC driver |
DSName | The display name of the Data Source |
User | Database user name |
Password | Database Password |
JNDINames | Comma-separated list of JNDI names. (e.g. /jdbc/name1,/jdbc/name2) |
Optional Properties
These properties are optional. If the property is unsupported by the version of WebLogic you are running, it will be ignored. If not specified in your properties file, the WebLogic 12c defaults shown below will apply. This is also true on updating databases, so it is important to include all the properties you use if modifying an existing environment. You may use as many or as few as you like per data source.
Property Name | Defaults |
---|---|
ConnectionCreationRetryFrequencySeconds | 0 |
ConnectionHarvestMaxCount | 1 |
ConnectionHarvestTriggerCount | -1 |
ConnectionLabelingCallback | Property is unset if not specified. |
ConnectionReserveTimeoutSeconds | 10 |
CountOfRefreshFailuresTillDisable | 2 |
CountOfTestFailuresTillFlush | 2 |
CredentialMappingEnabled | false |
DRCPConnectionClassProperties | Property is unset if not specified. This is required for pooled connections, and ignored on non-pooled connections. |
FatalErrorCodes | Property is unset if not specified. |
GlobalTransactionsProtocol | The default is OnePhaseCommit If you would like to uncheck the Supports Global Transactions checkbox, set the value to None. |
HighestNumWaiters | 2147483647 |
IdentityBasedConnectionPoolingEnabled | false |
IgnoreInUseConnectionsEnabled | true |
InactiveConnectionTimeoutSeconds | 0 |
InitialCapacity | 1 |
InitSql | Property is unset if not specified. |
KeepConnAfterGlobalTx | false |
KeepConnAfterLocalTx | true |
KeepLogicalConnOpenOnRelease | false |
KeepXaConnTillTxComplete | true |
LoginDelaySeconds | 0 |
MaxCapacity | 15 |
MinCapacity | 1 |
NeedTxCtxOnClose | false |
OracleProxySession | false |
Partition | Property is unset if not specified. |
PinnedToThread | false |
RecoverOnlyOnce | false |
RemoveInfectedConnections | true |
ResourceGroup | Property is unset if not specified. |
ResourceHealthMonitoring | true |
RollbackLocalTxUponConnClose | false |
SecondsToTrustAnIdlePoolConnection | 10 |
ShrinkFrequencySeconds | 900 |
StatementCacheSize | 10 |
StatementCacheType | LRU |
StatementTimeout | -1 |
Targets | Property is unset if not specified. Provide comma-separated list of target names. E.g. DefaultServer, Cluster1, Server2, Server3. |
TestConnectionsOnReserve | false |
TestFrequencySeconds | 120 |
TestTableName | SQL ISVALID\r\n |
UseDatabaseCredentials | false |
UseXaDataSourceInterface | true |
WrapTypes | true |
XaEndOnlyOnce | false |
XaRetryDurationSeconds | 0 |
XaRetryIntervalSeconds | 60 |
XaSetTransactionTimeout | false |
XaTransactionTimeout | 0 |
GridLink Properties
These properties are used only for GridLink DataSources.
Property Name | Defaults |
---|---|
OnsNodeList | Property is unset if not specified. |
OnsWalletFile | Property is unset if not specified. |
OnsWalletPassword | Property is unset if not specified. |
- style