In this lesson, we are going to learn how lifecycle management objects interact with jOOQ. There are a variety of SPIs (Service Provider Interfaces) which allow for managing the lifecycle of various entities within jOOQ. These SPIs can be injected via a Configuration object.
We’ll see how to use the ConnectionProvider, how jOOQ generates and executes SQL statements in the context of a concrete SQLDialect and how Settings are used to provide jOOQ with information about general query rendering and execution behaviour.