Connection management

There are two options to connect to a JSON data store. The first option is through a single-mode connection, which is explicitly established with the provided connection information. The second option is through a shared connection pool.

By default, a connection pool is used. Operations such as insert() and update() attempt to obtain a connection from the pool, perform the operation with that connection, and return it to the pool when done. For details, see the information about the nosql.connectionPoolSize property.

For connections in single-mode, the JSON API allows control of transactional behavior when you are working with JSON documents. Therefore, it is possible to combine multiple operations in a transaction, control auto-commit behavior, and trigger a rollback if errors occur. The transaction APIs are not applicable for the fire and forget mode. For details, see the information about connecting to a Db2 database.