OceanBase Developer Center (ODC) V3.3.1 released in May 2022 adds the features that allow you to configure whitelists and session expiration periods, and updates a series of features such as password verification, query result restriction, SQL execution time, PL compilation error information, CLOB content edit, MetaDB version restriction, and help center. The following table describes the updates of modules and features in this release.
Updated modules and features
| Feature | Module | Description |
|---|---|---|
| Workspace | SQL window | * The command line window supports ARM, and the built-in OBClient has been upgraded to the stable version V1.2.8. * Supports executing PL statements and code blocks with / in their content. * The compilation error information displayed includes the PL row number and the position at which the error occurred. * On the DB tab of the Execution Records page, you can view the full-link time consumption information about SQL statement execution. * On the Results tab: * In Oracle mode, you can directly edit text data of the CLOB, BLOB, or RAW type, edit hexadecimal data, and upload files that are not greater than 200 KB in size. * In MySQL mode, you can directly edit text data of the XLOB type such as BLOB, MEDIUMBLOB, or TINYBLOB, edit hexadecimal data, and upload files. * RAW types are displayed in string format, and the sys_guid value no longer needs to be viewed in hex mode. |
| Workspace | PL object | * Optimize package list refresh performance. * Type object supports compile exception flags. |
| Deployment guide | Preparations for deployment | * Web ODC supports all MetaDB versions. * The base image is hardened by replacing CentOS 7 with Anolis OS 8. * Security vulnerabilities in images and JAR packages are fixed. * The whitelist configuration feature is added for defense against server-side request forgery (SSRF) attacks: To configure a whitelist, connect to MetaDB of ODC as the deployment administrator, access this connection, and execute UPDATE config_system_configuration SET `value`='x.x.x.x' WHERE `key` = 'odc.connect.host-white-list';. The whitelist can contain multiple IP addresses separated with commas, but does not support CIDR blocks. |
| Deployment guide | Load and run an ODC image | Web ODC allows you to configure an expiration period for HTTP sessions by using environment variables. For more information, see the description of the ODC_APP_EXTRA_ARGS parameter in the running image. |
| Upgrade guide | Preparations for upgrade | * Web ODC supports all MetaDB versions. * The base image is hardened by replacing CentOS 7 with Anolis OS 8. * Security vulnerabilities in images and JAR packages are fixed. |
| Upgrade guide | Load and run an ODC image | Web ODC allows you to configure an expiration period for HTTP sessions by using environment variables. For more information, see the description of the ODC_APP_EXTRA_ARGS parameter in the running image. |