Connection factors

Edit online

The factors determining whether a connection is reused are the following:

  • the database type
  • the connection string (if applicable), datasource, or database name
  • the user ID
  • the OnFailure setting (Commit or Rollback)
  • the Transaction > Scope setting
  • the SourceRule > FetchAs setting
  • whether -CCARD or -CSTMT are specified within the adapter's command

Also, whether a connection will be part of a global transaction is determined by the usage of the Global Transaction (-GTX) adapter command in the Command setting.