OBLOADER & OBDUMPER V4.3.5

OBLOADER & OBDUMPER V4.3.5 supports more scenarios of multi-database logical migration. This version adds the multi-database import and export feature, improves the compatibility and stability by aligning the CSV parsing with the RFC 4180 specification, optimizes the automatic column mapping, and fixes some known issues. These improvements enhance the stability and usability of OBLOADER & OBDUMPER.

New features

• Supports importing tables with hidden columns during direct load. This solves the problem where tasks fail when importing tables with hidden columns.

• Supports importing data files with column orders and numbers different from those of the table definitions during direct load. This solves the problem where users need to manually preprocess data when the column orders or numbers in the source data files do not match those in the target tables.

• Supports importing multiple tables in one direct load task. This solves the problem where users need to initiate separate import tasks for each table, which is tedious and inefficient.

• Supports batch import and export of objects and data across databases and schemas. This solves the problem where users need to configure and execute multiple tasks when migrating or backing up multiple databases or schemas.

• Supports parsing CSV data in full compliance with the RFC 4180 specification. This solves the problem where data is misaligned or import fails when parsing CSV files with complex content, such as quoted strings, line breaks, or escape characters.

• Supports importing and exporting data of the ROWID and UROWID types in Oracle compatible mode of OceanBase Database. This solves the problem where users cannot import or export tables with columns of the ROWID and UROWID types in Oracle compatible mode of OceanBase Database.

• Supports the --ignore-escape option in CUT data import scenarios to disable escape processing. This solves the problem where field content is incorrectly modified or parsing fails when the system forcibly parses escape sequences in the import of raw text data containing delimiters or special characters but without escape processing.

Bug fixes

• Fixed the issue where null strings cannot be written to JSON columns.

• Fixed the issue where the commit time is always calculated as 0 during direct load.

• Fixed the issue where an error "No statements are parsed" is returned when importing stored procedures containing \ or \\.

• Fixed the issue where an error "No statements are parsed" is returned when importing stored procedures containing #.

• Fixed the issue where the error message "Dependencies are missing" is ambiguous during schema import.

• Fixed the issue where import fails due to foreign key constraints when importing table objects.

• Fixed the issue where data content becomes distorted during direct load of binary data in MySQL compatible mode of OceanBase Database.

• Fixed the issue where an error OB_ERR_DATA_TOO_LONG is returned during direct load of bit, binary, and varbinary data in MySQL compatible mode of OceanBase Database.

• Fixed the issue where the semicolon at the end of a view is included in the comment when exporting views with comments at the end in Oracle compatible mode of OceanBase Database, preventing the view from being imported again.

• Fixed the issue where a syntax error occurs when creating a user with a hashed password in MySQL compatible mode of OceanBase Database.

• Fixed the issue where using --table * or --all cannot reference the corresponding control file during export.

• Fixed the issue where data after empty lines in CUT files is ignored during import.

• Fixed the issue where database information is omitted during export of user-defined objects in Oracle compatible mode of OceanBase Database.

• Fixed the issue where a null exception is thrown when exporting POS files without specifying the position() method in the control file.

• Fixed the issue where materialized views are exported along with table objects during export.

• Fixed the issue where errors related to materialized view logs may occur during export of table objects.

• Fixed the issue where a syntax error occurs when using --all to export user objects with % wildcards in MySQL compatible mode of OceanBase Database.

• Fixed the issue where an error is returned when confirming whether to overwrite the generated encrypted file in secure-gen.

• Fixed the issue where Parquet files cannot be exported in --query-sql mode.

• Fixed the issue where the --type-body option is invalid.

• Fixed the issue where an error "The column type is null" is returned when exporting SQL files in --query-sql mode.

• Fixed the issue where the --exclude-table parameter is ineffective when using wildcards to match table objects in --table.

• Fixed the issue where temporary tables with hidden columns such as SYS_SESSION_ID cannot be imported.

• Fixed the issue where the --max-errors and --max-discards parameters do not take effect for partitioned tables or when the partition calculation component is enabled.

• Fixed the issue where an error is returned instead of a normal exit when importing an empty directory or file.

• Fixed the issue where no error is returned when importing POS files with misaligned data.

• Fixed the issue where an error "start > length()" is returned when exporting Chinese data in --pos mode.

Vulnerability fixes

• Upgraded the jackson-core component to fix the CVE-2025-52999 and CVE-2025-49128 vulnerabilities.

• Upgraded the commons-io component to fix the CVE-2024-47554 vulnerability.

• Upgraded the commons-lang3 component to fix the CVE-2025-48924 vulnerability.

• Upgraded the protobuf-java component to fix the CVE-2024-7254 vulnerability.

• Upgraded the commons-compress component to fix the CVE-2024-26308, CVE-2024-25710, and CVE-2023-42503 vulnerabilities.

• Upgraded the commons-configuration2 component to fix the CVE-2024-29133 and CVE-2024-29131 vulnerabilities.

• Upgraded the bcprov-jdk15on component to fix the CVE-2024-30171, CVE-2024-29857, and CVE-2023-33201 vulnerabilities.

Dependency library upgrades

• Upgraded the jackson component from V2.14.0 to V2.15.2.

• Upgraded the commons-io component from V2.11.0 to V2.16.1.

• Upgraded the commons-lang3 component from V3.12.0 to 3.18.0.

• Upgraded the parquet-common component from V1.12.3 to V1.15.1.

• Upgraded the parquet-jackson component from V1.12.3 to V1.15.1.

• Upgraded the parquet-hadoop component from V1.12.3 to V1.15.1.

• Upgraded the aircompressor component from V0.21 to V2.0.2.

• Upgraded the protobuf-java component from V3.19.6 to V3.25.5.

• Upgraded the commons-compress component from V1.22 to V1.26.2.

• Upgraded the commons-configuration2 component from V2.8.0 to V2.10.1.

• Upgraded the bcprov-jdk15on component from V1.70 to bcprov-jdk18on V1.78.1.

• Removed the jdom component.

• Removed the ion-java component.

• Removed the htrace-core component.