MogDB JDBC Changelog

MogDB JDBC Changelog mainly contains new features, improvements, BUG fixes and other changes. Please read the details below carefully to understand any changes.

Version 5.0.0.7 (2024-04-15)

Fixed

• Fix DB Parameter compat_oracle_txn_control and url autosave/ setSavepoint issue

  • autosave decides whether to send savepoint based on kernel transaction status
  • Using the setSavepoint method does not consider the compat_oracle_txn_control parameter and the same logic as before

5.0.0.6

2024-03-28

Fixed

• Fix db kernel parameter compat_oracle_txn_control and jdbc setAutoCommit(true) not commit issue

5.0.0.5

2024-03-20

Add

• Adapt kernel parameter enable_plsql_return_hold_cursor scenario to fetchSize
• Adapt kernel parameter compat_oracle_txn_control does not send start trans under setAutoCommit(false)

Fixed

• Fixed int2vector/oidvector/oidvector_extend/int2vector_extend query data problem
• Fixed the scenario where hibernate sets the Clob length to 0

5.0.0.4

2024-01-10

Add

• feature JDBC supports read/write splitting routing based on SQL statements at the statement level
• I8G7TQ JDBC support cleanupSavepoints
• I7WQOW JDBC support uint1/uint2/uint4/uint8

Fixed

• I8FJTX The blob type returns an exception
• I8GEZY JDBC to connect compatible B database , an error is reported in the execution trigger syntax and the statement is truncated
• I8I0AW you cannot insert double-quoted column names into uppercase databases
• I8AJBK When JDBC inserts data in batches, the preparedStatementCacheQueries parameter does not take effect, and the cachedplan data on the database side rises rapidly

Changed

• I89ZZU Adapt kernel parameter enable_plsql_return_hold_cursor ParseSQL supports symmetric block comments (C style)
• [] Control whether to actively close the stored procedure return cursor according to the kernel parameter enable_plsql_return_hold_cursor
• [] Add parameter enableUsrpwdCaseInsensitive to control whether the connection user name and password are case-insensitive according to the kernel parameter enable_usrpwd_case_insensitive
• []Adapt Oracle begin end anonymous block SQL statement execution

5.0.0.3

2023-11-16

Add

• I8G9XM jdbc return Type value for openGauss cursor type is inconsistent with Oracle and needs to be compatible
• I8G9SY jdbc calls procedure to register the parameter as double, but the database return type is NUMERIC, and an error occurs
• I8G9N7 jdbc calls procedure to register the parameter as char, but the database return type is varchar, and an error occurs

Fixed

• I8D6H1 When a field in the struct is null, there will be exceptions in parsing and generating
• I8B89Q UTF8Encoding has defects
• I8C2X3 errMessageForQuery does not consider the length issue
• I84URC In the jdbc driver, there is a problem with the "/" division operator in the SQL statement.

Changed

• I81MKF PgStruct cannot handle data containing special characters or special formats in input or output
• I82Z5W The JDBC driver supports processing returning statements during batch insertion

5.0.0.2

2023-10-12

Add

• I7IGAY When CallableStatement registers the parameter type as Types.STRUCT, CallableStatement.execute() reports an error
• I7WYWS supports JDBC standard createStruct interface
• I7VHXI The information obtained by PgObject through PgArray through PgObject.getArrayValue() does not meet expectations.
• I7QQ05 It is recommended to support the option parameter in the PG native JDBC driver connection string.
• I7JDF9 jdbc calls a custom function. The out parameter and return value are of numeric type 0, and the return results are inconsistent.

Fixed

• I7W41A benchmarksql and database cannot be tested normally using unix domain sockets when they are on the same machine
• I7PJFQ The driver under Druid reported an IO exception
• I7PAP9 When using mybatis to convert java.util.Date to Timestamp, the data cannot be filtered correctly.

Changed

• I7WXRI The problem of the upper limit of the number of bind variables needs to be fixed (incorporated into pgjdbc’s fix)
• I7OP8Y In JDBC batch mode, the bound variable type takes the first batch OID optimization
• I7I9DQ There is ambiguity in _getNameStatement in typecache