Spring query(PSC, PSS RSE) missing from JdbcOperations

JdbcTemplate.query(PSC, PSS RSE) is the only public query method on JdbcTemplate that is not on JdbcOperations.

Comment From: jhoeller

This is intentional: The query methods on JdbcOperations take a PreparedStatementCreator or a PreparedStatementSetter... but not both at the same time since a user is only meant to specify one or the other. The combined method on JdbcTemplate is primarily an internal delegation convenience that happens to be publicly exposed on the template class as well.

Comment From: marschall

I have a use case that would benefit from having both a PreparedStatementCreator and a PreparedStatementSetter. If you want to use Oracle explicit statement caching you need to use different methods for creating and closing a PreparedStatement, this can be achieved with a PreparedStatementCreator. I would be nice if the binding of parameters would not also have to be implemented in this class and could instead be moved to a dedicated PreparedStatementSetter.