JDBC SQL Connection

  3 minute read  

Note: This section is not applicable to the AEM Cloud Connector.

The JDBC SQL Connection section of the Configuration page configures the JDBC SQL connection to the Connector database.

The options in this section configure the JDBC SQL connection to the Connector database. The Connector supports the MySQL, Microsoft SQL Server, Oracle, and PostgreSQL databases.

Important: Every Adobe Experience Manager server with the Connector installed needs its own Connector database. Mirrored or load-balanced servers can point to the same Connector database.

Configuration Option Description
JDBC SQL Driver class Enter the appropriate configuration parameter for your database implementation:
  • For Microsoft SQL Server, enter: com.microsoft.sqlserver.jdbc.SQLServerDriver.
  • For MySql, enter: com.mysql.jdbc.Driver.
  • For Oracle, enter: oracle.jdbc.driver.OracleDriver.
  • For PostgreSQL, enter: org.postgresql.Driver.
JDBC Connection URL Enter the appropriate configuration parameter for your database implementation:
  • For Microsoft SQL Server, the URL should look like:
    jdbc:sqlserver://192.168.1.66:1433;databaseName=ctctranslation;.
  • For MySQL Server, the URL should look like:
    jdbc:mysql://192.168.1.90:3306/ctctranslation?characterEncoding=UTF-8.
  • For Oracle, the URL should look like:
    jdbc:oracle:thin:@//192.168.1.66:1521/CTCTRANSLATION.
  • - For PostgreSQL, the URL should look like:
    - jdbc:postgresql://localhost:5432/ctctranslation?charSet=utf-8 if SSL is not required
    - jdbc:postgresql://localhost:5432/ctctranslation?charSet=utf-8&ssl=true if SSL is required

    • Note: You can use the DNS name or IP address of the server where the PostgreSQL database resides.
    Login name The name for logging in to the SQL database.
    Login password The password for logging in to the SQL database.

    General notes: In the examples above, 192.168.1.66 is the IP address of the database server. Alternatively, you can enter the domain name of the database server.

    Notes for MySQL users: Ensure that characterEncoding=UTF-8 is configured for MySQL. 3306 is the default port of MySQL Server. If your database server uses a different port, change the port number in the example to match your port number.

    Note for Microsoft SQL Server users:

    • 1433 is the default port of the Microsoft SQL Server. If your database server uses a different port, change the port number in the example to match your port number.

    • The Connector versions 4.0.3 and higher do not support Microsoft SQLServer 2008 and 2008 R2 versions.

    Note for Oracle users: 1521 is the default port of the Oracle DB Server. If your database server uses a different port, change the port number in the example to match your port number.

    • To verify the JDBC connection and credentials, click the Test button. After testing, a message box indicates whether your configuration passed the test. This message box also displays a list of all Adobe Experience Manager instances that access this Connector database, and when the database was last accessed, which facilitate troubleshooting.
    Upgrading the database while upgrading your version of the Connector

    If upgrading the database fails while upgrading your version of the Connector, the Errors and SQL Scripts buttons are displayed:

    • Click Errors to view the related error messages.

    • Click SQL Scripts to download the generated SQL scripts. A DBA can then run the scripts.