Connection management

There are two options to connect to the Db2® JSON 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, and 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 topic about the nosql.connectionPoolSize property.

For connections in single-mode, the Db2 JSON API allows control of transactional behavior when you are working with JSON documents. So, 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 topic about connecting to a Db2 JSON database.