The DB Query Resource Adaptor lets SLEE services initiate JDBC queries to external databases and receive the results. Its features include:

  • synchronous (blocking) or asynchronous (event-driven) operation

  • transaction support

  • connection pooling

  • a connection checking facility

Security Notices

For interface management with DB Query Resource Adaptor, follow these guidelines:

Adhere to principles of Zero Trust.

We recommend that you adhere to principles of Zero Trust while designing, commissioning, and modifying your deployment. Zero Trust includes authenticating and authorizing traffic whenever possible, giving the least amount of access required to sessions and entities, and assuming that a security breach could originate from anywhere. A Zero Trust security model helps mitigate the effect of a breach if a device or network is compromised. For more information on Zero Trust principles, see Zero Trust Model - Modern Security Architecture | Microsoft Security.

This documentation uses Transport Layer Security (TLS) certificates to refer to X.509 certificates used with the TLS protocol. Outside of this product’s documentation, you may see TLS certificates referred to as SSL/TLS certificates or just SSL certificates. These terms are often used interchangeably, even though Secure Sockets Layer (SSL) is a distinct protocol from TLS.

DB Query Resource Adaptor uses Java Database Connectivity (JDBC) for database connections. For information about connection security, such as the TLS support, check the documentation for the JDBC driver that you use.

Establish trust domains and configure security controls on trust boundaries.

You must establish trust domains around your devices and network and configure security controls on the trust boundaries such as firewalls, network security groups, and rate limiting, even when you control the devices on both sides of the boundary.

Replace certificates at least once per year.

We recommend that you replace certificates at least once per year, including removing the old certificates from your system. This is known as rotating certificates. You might need to rotate your certificates more frequently if they expire after less than one year, or if organizational policies require it.

Product Documentation

Changelog
New features, improvements and bug fixes included in each software release.

Acknowledgements
Acknowledgements of third-party content used in this product.


DB Query Resource Adaptor Guide
Describes the resource adaptor architecture, along with installation, configuration and general usage documentation.

Database Query Resource Adaptor Type API
Javadoc for the DB Query Resource Adaptor Type.

DB Query Resource Adaptor Compatibility Guide
Resource adaptor compatibility with Metaswitch and third-party software.

Documentation for other versions of the DB Query Resource Adaptor is also available.