SQLData Script Library architecture

You can integrate the SQLData Script Library into ArchestrA by using synchronous or asynchronous scripting. The SQLData Script Library contains the following public objects:

• aaDBAccess

• aaDBConnection

• aaDBTransaction

• aaDBCommand

• aaDBRow

You can find details about these objects as well as their methods, properties, and enumerations in the remaining chapters in this guide.

The following figure shows connection pooling in the SQLData Script Library. Although each script generates its own connection object in the script library, scripts with identical connection strings are allocated to the same connection pool. The result is fewer connections to the database.

The following figure shows a conceptual diagram of the relationships among the various components of the SQLData script library.

Note that aaDBRow is one mechanism provided by aaDBCommand to read and modify data returned from the SQL query. The other mechanisms are implemented as methods of aaDBCommand.