Help Center> Data Warehouse Service (DWS)> Management Guide> Cluster Connection> Using the JDBC and ODBC Drivers to Connect to a Cluster> JDBC Version Description
Updated on 2024-06-20 GMT+08:00
View PDF

JDBC Version Description

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.