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 Property Replacement Support for more information about property replacement.
...
Property Name | Property Code | Required | Description |
---|---|---|---|
Properties File Path | FILE_PATH_TO_PROPERTIES | No | Comma-separated list of paths to the properties file(s). |
Outputs
Output Name | Required | Description |
---|---|---|
FDWLS_OUT_IS_RESTART_REQUIRED | No | A |
...
- Properties file can be named as per your requirements. See See Example Properties File Formatbelow.
- 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.
...
Code Block | ||
---|---|---|
| ||
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 #This format is also supported. DS2.properties.name=value DS2.properties.name2=value2 DS2.systemProperties.name=value DS2.systemProperties.name2=value2 |
Example Gridlink
...
DataSource Property File
This sample file defines a GridLink datasource data source with a sub-set of the available properties. It could be combined with other datasources data sources in one file, but is separate here for clarity.
...
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 for Generic and Gridlink Datasources
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) |
Required Properties for Multi Data Source
...
DataSources
At a minimum, each data source must contain these properties:
Property Name | Description |
---|---|
DataSourceType | MultiDataSource |
DSName | The display name of the Data Source |
JNDINames | Comma-separated list of JNDI names. (e.g. /jdbc/name1,/jdbc/name2) |
DataSourceList | Comma-Separated list of DataSource display names (DSName property of those datasources) |
Optional Properties for Generic
...
and Gridlink DataSources
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. |
FanEnabled | True if Gridlink, False if Generic |
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. The options are : OnePhaseCommit, None, LoggingLastResource, EmulateTwoPhaseCommit |
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 |
Optional Properties for GridLink DataSources
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. |
Optional Properties for Multi Data Source DataSources
These properties are used only for Multi Data Source DataSources.
Property Name | Defaults |
---|---|
Notes | Property is unset if not specified. |
FailoverRequestIfBusy | false |
ConnectionPoolFailoverCallbackHandler | Property is unset if not specified. |
AlgorithmType | Failover |
TestFrequencySeconds | 120 |
Targets | Property is unset if not specified. Provide comma-separated list of target names. E.g. DefaultServer, Cluster1, Server2, Server3. |