DBAPI

# Changelog

# Individual Edition

# 4.0.29

  • 2025-10-21
  • [Fix] Client modifications not taking effect

# 4.0.28

  • 2025-09-09
  • [Fix] Incorrect response content-type in cluster mode
  • [Fix] Redis cache not updating after cluster mode restart

# 4.0.27

  • 2025-09-02
  • [Optimization] Performance optimization

# 4.0.26

  • 2025-08-11
  • [Optimization] UI optimization
  • [Fix] Fixed several bugs

# 4.0.25

  • 2025-07-26
  • [Optimization] Enhanced dynamic SQL tag functionality
    • Support for choose when otherwise tags
    • Support for bind tag
    • Support for set tag
    • Fixed several tag syntax bugs

# 4.0.24

  • 2025-07-22
  • [Fix] Unable to select files when importing groups before importing APIs
  • [Optimization] Disk log files retained for 15 days by default

# 4.0.23

  • 2025-07-04
  • [Fix] In cluster mode, modifying data sources and IP firewall synchronizes to cluster-related roles
  • [Fix] Fixed cache configuration error
  • [Fix] Fixed API import failure
  • [New] Standalone mode supports configuring UI webpage IP whitelist (dbapi.ui.allowed.ips)
  • [Optimization] IP firewall supports subnet configuration
  • [Optimization] UI optimization

# 4.0.22

  • 2025-06-21
  • [Optimization] Script optimization, JAVA_LOCATION parameter configurable
  • [Optimization] API log query pagination
  • [Optimization] UI optimization
  • [New] SQL keyword search for APIs
  • [Fix] Fixed script incompatibility with Ubuntu system

# 4.0.21

  • 2025-04-18
  • [Optimization] Client token logic optimization

# 4.0.20

  • 2025-04-16
  • [Optimization] JDBC data source connection pool initialization logic optimization
  • [New] Request test page can select client to quickly generate token URL

# 4.0.19

  • 2025-04-15
  • [Optimization] Startup script optimization
  • [New] Import/export client functionality
  • [Fix] Gateway/apiServer cannot access static resources in cluster mode

# 4.0.18

  • 2025-04-03
  • [Fix] Request test page URL cannot be manually modified
  • [Fix] JDK17 cannot start, optimized startup script

# 4.0.17

  • 2025-03-29
  • [Fix] PowerShell Chinese garbled characters
  • [Fix] Public API page request test not sending header Authorization
  • [Optimization] Linux can configure JVM memory parameters
  • [Optimization] Non-query SQL statements return affected row count
  • [Optimization] Version management optimization

# 4.0.16

  • 2025-02-22
  • [New] Parameter processing plugin

# 4.0.15

  • [Optimization] Frontend rebuild with VUE3
  • [Optimization] UI optimization
  • [Optimization] Import API maintains original status, does not change status to offline
  • [Optimization] Import API validates data source existence
  • [Optimization] Create or edit API validates user input
  • [Optimization] Backend adds global exception handling
  • [Optimization] Close file stream when importing configuration
  • [New] Modify client functionality
  • [New] Plugin packages and driver packages can be managed in extlib directory
  • [Fix] Partial data date format error, 12-hour format changed to 24-hour format

# 4.0.14

  • 2024-12-29
  • [Fix] Fixed tomcat vulnerability CVE-2024-56337, upgraded tomcat version to 9.0.98

# 4.0.13

  • 2024-12-08
  • [Optimization] Serial number calculation optimization

# 4.0.12

  • 2024-11-08
  • [UI] Request test opens new tab page
  • [UI] Data source description and password changed to optional
  • [Optimization] Login validity period changed to 10 days
  • [Optimization] API modification does not automatically go offline
  • [Optimization] Log optimization
  • [Fix] Maven antrun plugin fix

# 4.0.11

  • 2024-06-01
  • [Optimization] Improved logging

# 4.0.10

  • 2023-12-16
  • [Fix] API JSON Body parameter empty error
  • [Fix] Shell Code Demo error
  • [Optimization] Windows PowerShell script execution failure window does not exit
  • [Optimization] Improved logging

# 4.0.9

  • 2023-11-23
  • [Removal] Removed hive kylin driver packages, streamlined installation package

# 4.0.8

  • 2023-09-26
  • [Optimization] UI optimization
  • [Removal] Removed built-in plugins, streamlined installation package

# Enterprise Edition

# 4.3.12

  • 2025-11-02
  • [Optimization] Regular developers can view monitoring menu
  • [Optimization] Regular developers can view all data sources
  • [Optimization] Regular developers can authorize data sources to groups (only data sources they created)
  • [Optimization] Groovy scripts can use groovy's json package
  • [Optimization] API orchestration API node selection displays options by group
  • [Fix] API orchestration API node selection does not display offline APIs

# 4.3.11

  • 2025-10-21
  • [Fix] Client modifications not taking effect

# 4.3.10

  • 2025-10-16
  • [Fix] Data source cannot be deleted

# 4.3.9

  • 2025-09-09
  • [Fix] Incorrect response content-type in cluster mode
  • [Fix] Redis cache not updating after cluster mode restart

# 4.3.8

  • 2025-08-30
  • [Optimization] Parameter processing plugins support multiple configurations
  • [Optimization] Several performance optimizations

# 4.3.7

  • 2025-08-11
  • [New] SQL parameters support built-in variable __clientId
  • [Fix] Fixed missing global data transformation scripts when importing/exporting API configurations
  • [Optimization] Several UI improvements

# 4.3.6

  • 2025-07-26
  • [Optimization] Enhanced dynamic SQL tag functionality
    • Support for choose when otherwise tags
    • Support for bind tag
    • Support for set tag
    • Fixed several tag syntax bugs

# 4.3.5

  • 2025-07-20
  • [Optimization] Disk log files retained for 15 days by default
  • [New] Global data transformation scripts support Groovy language
  • [New] Global data transformation scripts support API parameters as built-in variable parameters
  • [New] Parameter validation scripts support Groovy language
  • [New] API orchestration API node parameters script, end node script, decision node script support Groovy language
  • [New] Support configuring automatic cleanup of database access logs
  • [Fix] Unable to select files when importing groups before importing APIs

# 4.3.4

  • 2025-07-06
  • [Optimization] Data source editing logic optimization
  • [Optimization] Several UI optimizations
  • [Fix] API import unable to select files

# 4.3.3

  • 2025-07-02
  • [Optimization] Removed taos-jdbcdriver package, streamlined installation package
  • [Fix] In cluster mode, modifying data sources, deleting data sources, resetting data source connection pools do not take effect in apiServer
  • [Fix] Redis cache incompatible after version upgrade in cluster mode

# 4.3.2

  • 2025-06-28
  • [Optimization] IP firewall supports subnet configuration
  • [Optimization] dbapi.ui.allowed.ips supports subnet configuration

# 4.3.1

  • 2025-06-21
  • [Optimization] UI optimization
  • [Optimization] Script optimization, JAVA_LOCATION parameter configurable
  • [Optimization] API log query pagination
  • [New] Search APIs by SQL keywords
  • [Fix] Fixed script incompatibility with Ubuntu system

# 4.3.0 (Not backward compatible)

  • 2025-05-18
  • [New] Client authorization by individual API
  • [New] Reset database connection pool

Note: This version's metadata is not backward compatible. If using MySQL as metadata database, execute the following statements in MySQL before upgrading:

ALTER TABLE client_auth ADD `type` VARCHAR ( 10 );
ALTER TABLE client_auth ADD `create_time` datetime;
ALTER TABLE client_auth CHANGE group_id resource_id VARCHAR(20);
update client_auth set type = 'group';

# 4.2.5

  • 2025-04-16
  • [Optimization] JDBC data source connection pool initialization logic optimization
  • [New] Request test page can select client to quickly generate token URL

# 4.2.4

  • 2025-04-15
  • [Optimization] Startup script optimization
  • [New] UI webpage access IP restriction configurable in standalone mode
  • [New] Import/export client functionality
  • [Fix] Gateway/apiServer cannot access static resources in cluster mode
  • [Optimization] Changed dbapi.host configuration item to dbapi.api.url.base

# 4.2.3

  • 2025-04-03
  • [Fix] Request test page URL cannot be manually modified
  • [Fix] IP firewall modification not taking effect immediately in cluster mode
  • [Fix] JDK17 cannot start, optimized startup script

# 4.2.2

  • 2025-03-31
  • [Fix] Non-admin users can see all data sources bug

# 4.2.1

  • 2025-03-29
  • [Fix] Clicking online, offline, copy, delete, version management, request test buttons on search API page causes errors
  • [Fix] PowerShell Chinese garbled characters
  • [Optimization] Linux can configure JVM memory parameters

# 4.2.0 (Not backward compatible)

  • 2025-03-15
  • [New] API orchestration
  • [New] API page request test host configurable
  • [Fix] Password modification failure
  • [Fix] Public API page request test not sending header Authorization
  • [Optimization] Code optimization, version number processing
  • [Optimization] Non-query SQL statements return affected row count

Note: This version's metadata is not backward compatible. If using MySQL as metadata database, execute the following statements in MySQL before upgrading:

ALTER TABLE api_config ADD `type` VARCHAR ( 20 );
ALTER TABLE api_config ADD `dag_data` text;
ALTER TABLE api_config ADD `graph_data` text;

# 4.1.10

  • 2025-02-22
  • [New] Parameter processing plugin

# 4.1.9

  • 2025-02-07
  • [Optimization] Frontend Rebuild with VUE3
  • [Optimization] UI optimization
  • [Optimization] Import API maintains original status, does not change status to offline
  • [Optimization] Import API automatically authorizes data sources to groups
  • [Optimization] Create or edit API validates user input
  • [Optimization] Backend adds global exception handling
  • [Optimization] Close file stream when importing configuration
  • [New] Client token expiration time customizable
  • [New] Copy API functionality
  • [New] Plugin packages and driver packages can be managed in extlib directory
  • [Fix] Partial data date format error, 12-hour format changed to 24-hour format

# 4.1.8

  • 2025-1-7
  • [Optimization] HTTP executor returns raw data format, not converted to string

# 4.1.7

  • 2024-12-29
  • [Fix] Fixed tomcat vulnerability CVE-2024-56337, upgraded tomcat version to 9.0.98

# 4.1.6

  • 2024-12-08
  • [Optimization] Serial number calculation optimization

# 4.1.5

  • 2024-11-09
  • [UI] Request test opens new tab page
  • [Optimization] API modification does not automatically go offline
  • [Optimization] Client token logic optimization
  • [Optimization] Log optimization

# 4.1.4

  • 2024-11-08
  • [UI] Data source description and JDBC data source password changed to optional
  • [Optimization] Login validity period set to 10 days
  • [Fix] Maven antrun plugin fix

# 4.1.3

  • 2024-07-21
  • [Fix] Fixed bug where client settings for permanent token validity prevent client information modification

If this bug occurs, execute the following statement in the metadata database before upgrading to version 4.1.3:

update client set expire_at = 253370736000000 where expire_at = 9223372036854775807 ;

# 4.1.2 (Not backward compatible)

  • 2024-05-27
  • [New] JS code for data format transformation

Note: This version's metadata is not backward compatible. If using MySQL as metadata database, execute the following statements in MySQL before upgrading:

CREATE TABLE api_transform_script (
    `api_id` VARCHAR(20) DEFAULT NULL,
    `type` VARCHAR(20) DEFAULT NULL,
    `script` text
) ENGINE = InnoDB DEFAULT CHARSET=utf8;

# 4.1.1

  • 2024-01-12
  • [New] JDBC data source configurable druid connection pool parameters

# 4.1.0 (Not backward compatible)

  • 2023-12-24
  • [New] API parameter validation functionality

Note: This version's metadata is not backward compatible. If using MySQL as metadata database, execute the following statements in MySQL before upgrading:

CREATE TABLE `api_param_rule` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `api_id` varchar(10) DEFAULT NULL,
  `script` text,
  `type` varchar(20) DEFAULT NULL,
  `message` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

# 4.0.9

  • 2023-12-16
  • [Fix] HTTP executor bug
  • [Fix] API JSON Body parameter empty error
  • [Fix] Shell Code Demo error
  • [Optimization] Windows PowerShell script execution failure window does not exit
  • [Optimization] Improved logging

# 4.0.8

  • [Optimization] Code optimization

# 4.0.7

  • [Removal] Removed hive kylin driver packages, streamlined installation package

# 4.0.6

  • [Optimization] UI optimization
  • [Removal] Removed built-in plugins, streamlined installation package

# 4.0.5

  • [Fix] Fixed system bugs

# 4.0.4

  • [Optimization] Code optimization
  • [New] Source code packaged as tar file

# 4.0.3

  • [Fix] Fixed API concurrency bug
  • [Optimization] Code optimization

# 4.0.2

  • [New] API rate limiting
  • [New] Client rate limiting
  • [New] Response encryption
  • [Removal] Removed netty access logs
  • [Optimization] Removed github logo
  • [New] API history saving and rollback
  • [Optimization] API modification prohibits changing executor type
  • [Optimization] Data source modification prohibits changing type