OceanBase Developer Center (ODC) V3.2.0 released in September 2021 provides you with a public resource console and updated features such as connection management. The following table describes the modules and features updated in this iteration.
Updated modules and features
| Item | Description |
|---|---|
| Connection management | The Private Connection and Public Connection tabs are added to the Web ODC homepage. Each tab respectively lists the information of the private connections that you have created and the public connections that you have the access permission. For more information about connection-related operations, see Manage private connections and Manage public connections. |
| Public resource management | The updated Web ODC provides a public resource console that enables you to Manage users, Manage public connections, and configure System settings. The ODC administrator can use the console to manage users, grant permissions, and allocate resources. For example, the administrator can create and manage users and roles, create and manage public connections and resource groups, and set the delimiter, transaction commit mode in MySQL or Oracle mode, and maximum number of rows in the result set. |
| Workspace | * SQL window * The following features are added to the Results tab: * Column mode: In Column Mode , you can view and adjust the order of the selected data row. You can also zoom in to view the details. * Right-click operations: You can select result sets as needed and right-click them to select SQL or CSV as the data export format. * Edit: The ResultMetaData is obtained during the execution of an SQL statement to indicate whether the result set can be edited. Note Due to the limited features of the current OBServer version, you cannot edit the result sets that involve SET and ENUM fields in single-table and single-view queries. * Execution Record tab: The trace_id field is added. * Execution Plan tab: By default, the plan details are displayed in plain text. You can click View Formatted Plan to switch to the formatted view of the plan. * IN value conversion: You can click IN Value Conversion to convert the batch copied data into the in ('A','B') format. * Snippet * Snippet length: updated to not exceeding 2000 characters. * Snippet description: updated to optional. * Snippet list: The display mode is updated. If you specified an additional note in the description field, the note is displayed. Otherwise, the first 30 characters of the code snippet are displayed. |
| Tools | * Data export and import * Web ODC: The size of exported or imported data in one batch is increased from 250 MB to 2 GB. The file retention period on the server is also updated. * ODC Client: No limit on the size of exported or imported data. You can import and export data directly from the local disk. * Asynchronous execution * SQL Entry: You can click IN Value Conversion to convert the batch copied data into the in ('A','B') format. * Delimiter: The delimiters are supported. * Query Result Limit: You can set the number of data rows in the query result. Value range: (1,1 million). * Data mocking: The upper limit of the mock data volume is increased to 1 million. |
| Tasks | Choose Task Center  Asynchronous Execution  View . If a task contains the SELECT statement, you can find the Query Results and Download Results buttons on the Task Details page after the query is complete. |
| Database objects | * Functions * Create a function * A quick access toolbar is added, enabling you to add, delete, and move up and down the parameters. * You can click a row number to select a row and display the quick access toolbar that allows you to add, delete, and adjust the orders of the parameters. * Right-click operations: You can drag the pointer to select an entire row or a cell, and right-click it to copy the parameter. * Manage functions * The Code section is renamed as DDL. * New icons: In the Parameters section, a Refresh icon is added. In the DDL section, the Edit, Search, and Refresh icons are provided. You can click the Edit icon to go to the PL object editing page. On this page, the Confirm Modification button is moved to the upper-right corner. * Stored procedure objects * Create a stored procedure: The updates are the same as those of the preceding function creation feature. * Manage stored procedures: The updates are the same as those of the preceding function management feature. * Program packages * Create a package: The process is provided with a quick access toolbar. You can click Next: Verify SQL Statement to go to the Create Package page. * Manage packages: The Edit, Find, and Refresh buttons are added. * Sequences * Create a sequence: The process is provided with a quick access toolbar. You can click the Next: Verify SQL Statement to go to the Create Sequence page. * Manage sequences: * The Code tab is renamed DDL, and a Refresh button is added. * The Edit and Refresh buttons are added to the Basic Information tab. |
| Session | On the Session Properties tab, click Edit to modify a single variable. After you edit the variable, click OK . On the SQL Confirmation page, click Execute to apply the modification. |
| Deployment guide | New methods are added to install, run, and mount Docker containers. |
| FAQ | Updated solution: ODC V3.2.0 allows you to customize ports when the installation or startup of the ODC client fails and a port conflict occurs. New solutions for the following exceptions: * When the ODC client fails to be installed or run, the system prompts that the software package is damaged. * The result set of the query contains garbled characters. * The DDL statement is incomplete in the table structure. |
| Personal settings | You can configure your preferences in the Personal Settings section, including the delimiter, transaction commit mode, and maximum number of rows in the result set. Personal settings take effect permanently after modification. |
| Tips for new features | Choose Help > New Features to open a dialog box that introduces the new ODC features. The dialog box appears when the user logs on to ODC for the first time. |