JDBC Version Description

Table 1 JDBC version change history

Version

Description

Remarks

8.1.1.100

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

Disable reporting of the OS user:

     jdbc:postgresql://host:port/database?connectionExtraInfo=false

8.1.1.300

Fix vulnerabilities.

8.1.3

Upgrade to the open-source version 42.2.23. For JDBC 8.1.3 and later versions, JDK 1.8 is required.

8.1.3.100

The nvarchar2 object can be obtained through resultSet.getNString.
Fixed the following vulnerability:
The dependency package fastjson is upgraded to 1.2.83.

8.2.0

The Oracle Raw data type is supported.
Fixed the following bug:
The field length obtained by the getColumnDisplaySize() method is incorrect.

Compatibility with the Oracle Raw data type. The usage is as follows:

Insertion or modification

     byte[] bytes = oracleResultSet.getBytes(2)
prepareStatement.setBytes(bytes)
// Or
prepareStatement.setObject(bytes)

Query

     resultSet.getBytes()
resultSet.getObject()

8.2.1

Fixed the following bugs:

An error is reported when reWriteBatchedInserts is used to insert data in batches.
"Invalid input syntax for type oid: 03032VLM" is reported when data is imported from Spark to DWS.

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.

8.2.1.300

8.3.0

Fixed the following bug:

loadBalanceHosts=false does not take effect.

8.3.0.201

Fixed the following bug:
Multiple functions cannot be automatically split when they are executed at a time.

8.3.0.202

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

When tcpKeepAlive is set to true, the following parameters take effect:

TCP_KEEPIDLE=30 (default value): The detection starts after the connection is idle for 30 seconds.
TCP_KEEPCOUNT=9 (default value): A total of nine detections are performed.
TCP_KEEPINTERVAL=30 (default value): The detection interval is 30s.

8.3.1.200

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.