Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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).
If relative paths are given, they are assumed relative to the FD_ARTIFACTS_DIR directory.
If this property is not specified, all properties files in the FD_ARTIFACTS_DIR directory will be processed.

Outputs

Output Name

Required

Description

FDWLS_OUT_IS_RESTART_REQUIRED

No

A boolean value that indicates whether the server needs to be restarted to finish applying the configuration changes. You could use this in a workflow condition.

...

Tip
titleBackslash in Properties file

If you want \ (backslash) in any property value, use \\ or \u005c. This is Java properties file load syntax.


Code Block
languagetextbash
themeRDark
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
# This format is also supported for datasource properties.
DS1.properties.oracle.net.CONNECT_TIMEOUT=30000

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 for datasource properties.
DS1.properties.oracle.net.CONNECT_TIMEOUT=30000
DS2.properties.key1=value1
DS2.properties.key2=value2
DS2.systemProperties.key3=value3
DS2.systemProperties.key4=value4

...

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.

FanEnabledTrue 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, TwoPhaseCommit

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

...