Page Comparison

This section lists the prerequisites and steps for applying this patch.

...

1. Go to …<ConnectServerInstallFolder>\AdeptiaServer\ServerKernel\etc location.
2. Open AgentContext.xml file.

3. Set the following properties based on your environment.

   Tip
   If you are going to use a separate backend database for the Agent, you need to create the database and update this file with new database property. Or, you can use the existing backend database of Adeptia Connect and use its properties to update this file.

   Under "dataSourceAgent" section, update the following properties:
   
   
   
   

   1. Update the property "jdbcUrl", for example, in case of MySQL being used as a backend database, the format of jdbcUrl will be jdbc:mysql://<hostname>:<port no.>/<DB Name>?useSSL=false.
      Here,
      Hostname: Name/IP address of the database server.
      Port No.: Port number of the database.
      Database name: Name of the database.

      Note
      If you are using SQL or Oracle as a backend database, the format of jdbcUrl will be: SQL jdbc:sqlserver://<hostname>:<port no.>;DataBaseName=<DB Name> Oracle jdbc:oracle:thin:@<hostname>:<port no.>:<DB Name>

      
      

   2. driverClass: Update the driver class name, for example, "com.mysql.cj.jdbc.Driver" if MySQL database is used. 
      

      Note
      If you are using SQL or Oracle as a backend database, update the value of driverClass as: SQL com.microsoft.sqlserver.jdbc.SQLServerDriver Oracle oracle.jdbc.OracleDriver

      
      

   3. user: Enter the user name.
   4. password: Enter the password.
   5. dataSourceName: Enter the backend database name.

4. Under "AgentEntityManagerFactory" section, update the "hibernate.dialect" property.
   

   Note
   "hibernate.dialect" property for each database is as follows: MySQL org.hibernate.dialect.MySQL5InnoDBDialect SQL org.hibernate.dialect.SQLServerDialect Oracle org.hibernate.dialect.Oracle10gDialect

5. Save the file.

Changes in hubConfiguration.properties file

...