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 |
...
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) |
...
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 |
...