Advanced JDBC Configuration and Diagnostics
Since Payara Server 18.104.22.168 and Payara Server Micro 22.214.171.124
Payara Server and Payara Micro 161 comes integrated with new capabilities 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 new powerful features have been introduced.
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 statements and its execution time 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 data sources can now be configured on application scoped data sources deployed via deployment descriptors or annotations.
See Advanced Connection Pool Properties for detailed information.
See the JDBC Connection Validation page in the core documentation for information on changes between GlassFish Server and Payara Server’s JDBC Connection Validation.