Help Center/ GaussDB(DWS)/ User Guide/ Connecting to a GaussDB(DWS) Cluster/ Using a Third-Party Database Adapter for GaussDB(DWS) Cluster Connection/ Using the JDBC and ODBC Drivers to Connect to a Cluster/ JDBC Version Description
Updated on 2024-10-21 GMT+08:00
View PDF
Share

JDBC Version Description

Version 8.3.1.200

New features
  • JDBC load balancing can automatically detect the live CN list.
    • The cnListRefreshSwitch parameter is added to enable automatic detection of the live CN list. The default value is off.
    • The cnListRefreshDelay parameter is added to specify the delay for enabling automatic detection of the live CN list. The default value is 1,800,000 milliseconds. This parameter only works when cnListRefreshSwitch is set to on.
    • The cnListRefreshPeriod parameter is added to specify the period for automatically detecting the live CN list. The default value is 1,800,000 milliseconds. This parameter only works when cnListRefreshSwitch is set to on.
  • JDBC supports certificate revocation.

    The sslCrl parameter is added to specify the path of the revoked certificate. By default, this parameter is left blank.

  • JDBC supports database reconnection.
    • The autoReconnect parameter is added to specify whether to enable automatic database reconnection. The default value is false.
    • The reConnectCount parameter is added to specify the number of automatic reconnection times. The default value is 10. This parameter takes effect when autoReconnect is set to true. If the number of connection attempts exceeds this parameter's value, reconnection will fail.

Version 8.3.0.202

  • New features:

    The tcpKeepAlive configuration is added. When tcpKeepAlive is set to true, the following parameters take effect:

    Default value:

    1. TCP_KEEPIDLE=30: The detection starts after the connection is idle for 30 seconds.
    2. TCP_KEEPCOUNT=9: A total of nine detections are performed.
    3. TCP_KEEPINTERVAL=30: The detection interval is 30s.

      The JDK varies according to the operating system. Some platforms, such as Windows, Red Hat, and SUSE, may not support this parameter.

  • Fixed vulnerability:

    CVE-2024-1597

Version 8.3.0.201

  • Fixed bug:

    Multiple functions cannot be automatically split when they are executed at a time.

Version 8.3.0

  • Fixed bug:

    loadBalanceHosts=false does not take effect.

Version 8.2.1.300

  • Fixed bug:

    The NVARCHAR array type is incompatible.

  • Fixed vulnerability:

    CVE-2022-41946

Version 8.2.1.1

The defaultQueryMetaData parameter is added to specify whether to query SQL metadata by default. The default value is false.

JDBC supports the raw type, which requires the querying of metadata. If you want to use JDBC to perform operations on the raw type, set defaultQueryMetaData to true.

If this parameter is enabled, prepareStatement is incompatible with the syntax create table as. You can replace it by Statement.

Version 8.2.1

  • Fixed bug:
    1. An error is reported when reWriteBatchedInserts is used to insert data in batches.
    2. "Invalid input syntax for type oid: 03032VLM" is reported when data is imported from Spark to GaussDB(DWS).

Version 8.2.0

  • New feature: Compatibility with the Oracle Raw data type. The usage is as follows:
    • Insertion or Modification 
      1
2
3
4
      		 
      byte[] bytes = oracleResultSet.getBytes(2)
prepareStatement.setBytes(bytes)
// Or
prepareStatement.setObject(bytes)
    • Query 
      1
2
      		 
      resultSet.getBytes()
resultSet.getObject()
  • Fixed bug:

    The field length obtained by the getColumnDisplaySize() method is incorrect.

  • Fixed vulnerabilities:

    CVE-2022-26520

    CVE-2022-31197

Version 8.1.3.100

  • New features

    The nvarchar2 object can be obtained through resultSet.getNString.

  • Fixed vulnerabilities:

    The dependency package fastjson is upgraded to 1.2.83.

Version 8.1.3

Upgrade to the open source version 42.2.23.

  • New features
    • The nvarchar2 type is supported.
    • The nvarchar2 object can be obtained through resultSet.getObject.
  • Fixed vulnerabilities

    CVE-2022-21724

    For JDBC 8.1.3 and later versions, JDK 1.8 is required.

Version 8.1.1.300

  • New features
    • The nvarchar2 type is supported.
    • The nvarchar2 object can be obtained through resultSet.getObject.
  • Fixed vulnerabilities

Version 8.1.1.100

  • New features

    By default, the driver reports the OS user. To disable this function, you can set connectionExtraInfo=false.

    1
    		 
    jdbc:postgresql://host:port/database?connectionExtraInfo=false
  • Fixed vulnerabilities

    Jackson was upgraded.