Oracle jdbc driver: implicit statement cache or setPoolable (true)?

Question

Oracle 11.2.x JDBC Driver:

Should I rely on the implicit statement cache, or should I call setPoolable (true) for every Statement I create? What are the differences, advantages and disadvantages of both methods?

Answer 1

Caching Statement improves performance by caching executable statements that are reused, for example, in a loop or in a method that is called repeatedly.

When you enable Implicit Statement caching, JDBC automatically caches a prepared or called statement when you call the close method of this statement object.

setPoolable (true) .

, Statement.

Oracle Oracle 11.2.