6.4 Provide the Resource Manager Connection Details

For every transaction participant application that uses a resource manager to store the application data, enter the connect string, user name, and password to access the resource manager in the application's YAML file. Skip this section if your application does not use a resource manager.

Enter the connection string to access the resource manager as the value for the databaseUrl property. The format in which you provide the connection string depends on the type of the database that you use and the language of the application's source code. Connection strings are provided in this section only for your reference. Refer to the database-specific documentation for the latest information.

Format of the Connection String for Java Applications

For all Java applications, such as JAX-RS, Spring-REST, Hibernate, or EclipseLink, enter the connection string in one of the following formats depending on the type of the database.

• If you are using a database that uses a credential wallet, such as Oracle Autonomous Transaction Processing, use the following format to enter the connection string:

  jdbc:oracle:thin:@tcps://<host>:<port>/<service_name>?wallet_location=<wallet_dir>

  You can find the required details, such as protocol, host, port, and service name in the tnsnames.ora file, which is located in folder where you have extracted the wallet. See Download Client Credentials (Wallets) in Using Oracle Autonomous Database on Shared Exadata Infrastructure.

  For example:

  jdbc:oracle:thin:@tcps://adb.us-phoenix-1.oraclecloud.com:1521/sales.adb.oraclecloud.com?wallet_location=Database_Wallet

• If you are using a non-autonomous Oracle Database, a database that does not use a credential wallet, use the following format to enter the connection string:

  jdbc:oracle:thin:@<publicIP>:<portNumber>/<databaseUniqueName>.<hostDomainName>

  For example:

  jdbc:oracle:thin:@123.213.85.123:1521/CustDB_iad1vm.sub05031027070.customervcnwith.oraclevcn.com

  Where, CustDB_iad1vm.sub05031027070.customervcnwith is the unique name of the database or the service name.

• If you are using Oracle Database Cloud Service with Oracle Cloud Infrastructure, see Create the Oracle Database Classic Cloud Service Connection String in Using Oracle Blockchain Platform.
• If you are using Oracle RAC database, see About Connecting to an Oracle RAC Database Using SCANs.
• If you are using MySQL database, use the following format to enter the connection string:

  jdbc:mysql://<database-host>:<database-port>/<database-name>

  For example:

  jdbc:mysql://10.0.10.59:3306/department_nonxa_ds

  For more information, refer to MySQL documentation.

• If you are using PostgreSQL database, use the following format to enter the connection string:

  jdbc:postgresql://<postgres-host>:<postgres-port>/<database-name>

  For example:

  jdbc:postgresql://postgres-deployment-postgresql.postgres.svc.cluster.local:5432/department

  For more information, refer to PostgreSQL documentation.

• If you are using MongoDB database, use the following format to enter the connection string:

  mongodb://<mongodb-host>:<mongodb-port>/?replicaSet=rs0

  For details, refer to the MongoDB documentation.

Format of the Connection String for Node.js Applications

For Node.js XA transaction participant applications, MicroTx library is tested with Oracle Database 19.x and Oracle RAC 19c.

If you are establishing a connection between a Node.js application and an Oracle database, provide the connection string in the format specified at Embedded Connect Descriptor Strings.