-
Notifications
You must be signed in to change notification settings - Fork 0
Advanced JDBC Configuration And Diagnostics (Payara 4.1.1.161)
#Advanced JDBC Configuration and Diagnostics. Payara Server and Micro 161 (4.1.1.161) onwards
Payara Server 161 (4.1.1.161) and Payara Micro 161 introduce new capabilites for advanced JDBC connection pool configuration and diagnostics.
Many performance problems in Enterprise Applications can be traced to slow database access or database connectivity problems. To help prevent and diagnose database access problems we have introduced a number of powerful new features.
Connection pools can be configured to log a warning whenever a database query exceeds a defined threshold. This enables your operations team to rapidly diagnose performance problems and identify poorly performing SQL.
See Slow-SQL-Logger for detailed information.
Connection pools can be configured to log all JDBC calls made to the connection pool including the SQL and execution times of the call. This is especially useful in development to understand the SQL generated via frameworks like JPA and see what the performance characteristics look like. As the tracing is done at the connection pool level all direct SQL or other data access technologies are captured.
See Log-JDBC-Calls for detailed information.
It is also possible to use the Payara Server apis used to implement both the Payara Server Slow SQL Logging and JDBC tracing capabilities to create custom diagnostic and tracing functionality via SQL Trace Listeners.
See SQL Trace Listeners for detailed Information.
All connection pool properties available on the administration console for Payara Server global datasources can now be configured on application scoped datasources deployed via deployment descriptors or annotations.
See Advanced Connection Pool Properties for detailed information.
All these powerful capabilities available on Payara Server can also be used in Payara Micro to create robust enterprise ready microservices.