Configuring the JDBC Database Connection

To set up your load-balanced cluster, you must first configure the database connection for the 3DOrchestrate servers.

Because the same database instance must be shared by all 3DOrchestrate servers in the cluster, only the manually preconfigured databases are allowed: preconfigured Oracle or preconfigured SQL Server. See Configuring the 3DOrchestrate Database. Derby database and deployment-utility-managed Oracle are not supported with load balancing.

Before you begin:
  • The reverse proxy server must be installed on the network and identified by its network socket—hostname (fully qualified name or IP address) and port (defaulting to 443 for HTTPS).
  • The load balancer must be installed on the network and identified by its network socket—hostname (fully qualified name or IP address) and port (no default).
  • The database instance for 3DOrchestrate must be installed on the network and all required JDBC connection information must be available.
See Also
Preconfiguring Oracle Manually
Preconfiguring SQL Server Manually
Deploying 3DOrchestrate in the Java Application Server
  1. Install the SIMULIA_3DOrchestration media on every network computer that will operate as a JMS broker or as one of the clustered 3DOrchestrate servers.

    Do not run the 3DOrchestrate deployment utility yet. You can verify that it has not yet run by checking that there is no /exe1/ subdirectory in the installation.

  2. Open a command-line prompt, and change the current directory to the base installation of the 3DOrchestrate server; for example: 

    C:\DassaultSystemes\R2020x\3DOrchestrate\

    This base directory is called <server_install_dir> throughout this guide.

  3. Start the 3DOrchestrate deployment utility GUI from the <server_install_dir> directory by executing the following command: 

    ./<os>/reffiles/SMAExeServer/deploy/smaexe-deploy.[bat|sh]

    For example, on Windows: 

    .\win_b64\reffiles\SMAExeServer\deploy\smaexe-deploy.bat

  4. In the Deploy tab, deactivate all of the preselected actions by clearing Configure all under Combined actions.
  5. Click the General Settings tab, and select either Oracle preconfigured or MSSQL preconfigured as the Database type.

    These are the only database configurations that can be used with load balancing.

    Do not change any other options here.

  6. Click the appropriate database configuration tab, either Oracle Settings Preconfigured or MSSQL Settings Preconfigured.

    Enter your JDBC connection information; for example, for Oracle:

    • Service Name (or SID)

    • Schema User Name

    • Schema User Password

    • Listener Host

    • Listener Port

    Warning: Make sure you enter the values exactly, without typos, because no automatic validation is done on these values.

  7. Click the main Deploy tab, and click Save Settings.

    This saves your settings in the default deploy.param file.

  8. Optional: If you are using a preconfigured Oracle database, you can test the JDBC connection. Select Create Tables or Clear All Tables, and click Execute.
  9. Close the deployment utility GUI by clicking the X in the upper right corner.