Bending MySQL Connector/J to Your Liking

A unique feature of MySQL Connector/J is that it has multiple extension points that allow end-users to extend and change behavior without changing the core code.

Users can inject functionality into the driver that allows their code to sit in-between query processing so that they can manipulate statements and/or the result sets they return, plug into the connection lifecycle, including transaction demarcation and to provide custom sockets and logging implementations.

In this session Mark Matthews will demonstrate how to take advantage of these APIs to demonstrate the following:

• Diagnose application performance problems by wrapping query execution with custom code
• Inject result set filtering for security reasons
• Use statement interceptors to provide a client-side cache
• Rewrite queries on the fly
• Customize connection settings outside the control of a connection pool
• Hook method calls to transaction demarcation for load balancing purposes