Database package updates

Review the updates in released versions of the Database package such as new and enhanced features as well as fixes and limitations. The page also lists the release dates of each version, and the compatible Control Room and Bot Agent versions.

Versions summary

The following table lists the versions of Database package released either with an Automation 360 release or as a package-only release (in descending order of release dates). Click the version link for information about updates in that package version.

Version Release date Release type Bot Agent version Control Room build
5.5.3 15 July 2025 Package-only; post Automation 360 v.37 release 21.88 or later 10204 or later
5.5.2 4 June 2025

随着 Automation 360 v.37(沙盒)版本的发行(与 macOS 相关的支持)

21.88 or later 10204 or later
5.4.0 17 June 2024 With Automation 360 v.33 (Sandbox) release 21.88 or later 10204 or later
5.3.0 22 March 2024 Package-only; post Automation 360 v.32 (Sandbox) release 21.88 or later 10204 or later
vma1698660419945_00007.html#rxc1682768318574__a360.31-database-ga 6 December 2023 With Automation 360 v.31 (Sandbox) release 21.88 or later 10204 or later
5.1.0 16 August 2023 Package-only; post Automation 360 v.29 release 21.88 or later 10204 or later
4.12.2 6 June 2023 With Automation 360 v.29 (Sandbox) release 21.88 or later 10204 or later
Note:
  • To download an individual package (updated in an Automation 360 release where you want only the package), use this URL:

    https://aai-artifacts.my.automationanywhere.digital/packages/<package-file-name>-<version.number>.jar

  • For Database package, the naming convention is: bot-command-database-<version.number>.jar

    For example, bot-command-database-5.2.1.jar

For detailed steps on downloading a package and manually adding it to the Control Room, see 将 packages 添加到 Control Room.

5.5.3

  • Compatible Bot Agent version: 21.88 or later
  • Compatible Control Room version: 10204 or later Fix
When you run a bot using the Database Connect action and use Excel as a database for a longer period, the bot execution no longer gets stuck.

Previously, in such cases, the bot execution would get stuck, causing the automation to halt until it was terminated manually.

Service Cloud case ID: 02190017

5.5.2

  • Compatible Bot Agent version: 21.88 or later
  • Compatible Control Room version: 10204 or later
What's new

平民开发者和专业自动化专家现在可以在他们的设备上开发和运行 macOS 平台上的自动化。 此 package 已增强,以支持 macOS,确保统一的开发和可移植性体验。

5.4.0

  • Compatible Bot Agent version: 21.88 or later
  • Compatible Control Room version: 10204 or later
Fix

You create a bot using the Database Connect action with the ODBC connection string, use Excel as a database, then use the Read from action, using Select * into [sheet2] from [sheet1] statement, the bot no longer stuck and now displays an appropriate error message.

Service Cloud case ID: 02113073

5.3.0

  • Compatible Bot Agent version: 21.88 or later
  • Compatible Control Room version: 10204 or later
Fix
The Database package jar file is installed successfully through Cloud updates.

Previously, the scheduled cloud update of packages failed to install the Database package jar file due to an error.

5.2.1

  • Compatible Bot Agent version: 21.88 or later
  • Compatible Control Room version: 10204 or later
What's changed

软件包内部更新

进行小幅更新,以支持 API 任务。

5.1.0

  • Compatible Bot Agent version: 21.88 or later
  • Compatible Control Room version: 10204 or later
Note:package 版本也可在 Automation 360 v.30 版本中使用。
What's new
Database package enhancements (Service Cloud case ID: 01881930, 01981681, 00743352, 01938224, 01946530, 01938224)
The following enhancements have been added to the Database package for Pro and Citizen Developers.
  • Ability to share the Database session across parent and child bots.
    • You can now create a new global session using the Database > Connect action and pass this session from a parent to child bots or reuse this session in other actions of the Database package. This feature ensures data consistency in each bot because you perform the database operations on a standard set of data.
    • You can create a new session variable of the type database session to store the database sessions.
    • The existing session name field has been renamed to Create Database session.
  • In default mode, you can now define connection strings with variables to substitute credentials such as username and password or any other security-related data in the Connect action. You can map these variables with credential vault values to ensure that sensitive information is not exposed in the connection string.
  • You can now connect to any database with the JDBC connection string for the user-defined database option. This helps to significantly reduce development time and maintenance overhead because you are no longer required to automate processes that involve other databases.

对数据库使用连接action

What's changed
Changes to storing the database schema in Disconnect action (Service Cloud case ID: 00743352, 01938224, 01946530, 01938224)

In the Disconnect action, if you select the Keep database schema in cache until bot finishes running option and then try to create a new database session after the Disconnect action, while keeping the same session name as the previous one, an error occurs, and the new database session is not created. To avoid this, leave the Keep database schema in cache until bot finishes running option unchecked.

断开 action

Fixes
For the Insert/Update/Delete action in the Database package, the 'Stream Closed' error is no longer displayed when you run a large SQL query (up to 65K ASCII text) over an ODBC connection.

Service Cloud case ID: 01991720

Fixed the vulnerabilities reported in the security scan.

Service Cloud case ID: 01967285

4.12.2

  • Compatible Bot Agent version: 21.88 or later
  • Compatible Control Room version: 10204 or later
Fix
Fixed the vulnerabilities reported in the security scan.

Service Cloud case ID: 01967285