Help Center/ DataArts Studio/ FAQs/ DataArts Migration (CDM Jobs)/ How Do I Select an Appropriate Driver When Configuring a Connection to a Dameng Database?
Updated on 2026-06-25 GMT+08:00
View PDF
Share

How Do I Select an Appropriate Driver When Configuring a Connection to a Dameng Database?

Dameng provides different driver versions that include function updates. The support for JDBC varies depending on the driver version. You must select an appropriate version to ensure that CDM can properly migrate data.

Possible Causes

The naming rules for the drivers of Dameng databases have changed.

The naming rules for the JDBC driver JAR packages of Dameng databases before Q3 2024 are as follows:

  • DmJdbcDriver16.jar adapts to JDK 1.6.
  • DmJdbcDriver17.jar adapts to JDK 1.7.
  • DmJdbcDriver18.jar adapts to JDK 1.8.

In Q3 2024, JDK 11 was added, and the original JAR packages were renamed. The new naming rules for the JDBC driver JAR packages are as follows:

  • DmJdbcDriver6.jar adapts to JDK 1.6.
  • DmJdbcDriver7.jar adapts to JDK 1.7.
  • DmJdbcDriver8.jar adapts to JDK 1.8.
  • DmJdbcDriver11.jar adapts to JDK 11.

Currently, CDM is compatible with JDK 8. You must select DmJdbcDriver18.jar or DmJdbcDriver8.jar.

Solution

  1. Check the driver version of the Dameng database.

    Open the driver file. In the META-INF directory, find the MANIFEST.MF file that contains the basic information about the driver, including its version.

    The following figure shows the DmJdbcDriver8.jar driver file downloaded from the Dameng official website on March 27, 2026. The driver version is 8.1.4.170.

    Figure 1 Driver file
  2. Determine the JDBC connection string format used by CDM.

    According to the Dameng official documentation, Dameng databases support three types of JDBC connection strings. The following two types are used for the connections in CDM:

    A single node: jdbc:dm://{{host}}:{{port}}/{{db}}[?p1=v1]
Multiple nodes: jdbc:dm://DMDW/{{db}}?DMDW=({{host[0]}}:{{port}},...,{{host[n-1]}}:{{port}})[?p1=v1] [&p2=v2][&…]…

    In the preceding connection string formats, the values of host, port, and db are the values of Database Server, Port, and Database Name specified during the data connection creation.

  3. Select the Dameng driver and configure the data connection.

    Test the JDBC connection formats supported by five driver versions from 8.1.1 to 8.1.5 for Dameng V8 databases.

    1. Test the Dameng primary and standby databases of version 0x 7000d.
    2. Test the following six connection formats:
      • Multi_ipPort
      • Multi_ipPort+schemaName
      • Multi_ipPort+dbName
      • ipPort
      • ipPort+schemaName
      • ipPort+dbName
    3. The test result is as follows.
      Figure 2 Test result
    4. 8.1.1.x versions support six connection formats. Version 8.1.2 only supports the ipPort format. Version 8.1.3 and later versions only support the ipPort and ipPort+schemaName formats.

Summary

  • You can use the DmJdbcDriver18 driver whose version is 8.1.1.x or 8.1.3.x.
  • You can use the DmJdbcDriver8 driver downloaded from the Dameng official website. In this case, you need to enter the tablespace name for Database Name.
  • Do not use a driver whose version is 8.1.2.x.