Caching in JDBC [closed]

Question

I want to use caching with JDBC.
How can I achieve that?
Are there any built-in mechanisms or do I have to use 3rd party solutions?
What is best practise for caching with JDBC.

Thank You, Jack

EDITED: what about CachedRowSet? http://docs.oracle.com/javase/tutorial/jdbc/basics/cachedrowset.html

Answer 1

There is few options now:

• JDBC-Cache-Driver
• DbdaTestDriver

Answer 2

try ehcache. JDBC does not have caching by itself, but ehcache is pretty good. if you want a more robust cluster safe cache, try oracle coherence. I typically do not put a cache at first and run some performance tests, only if tests indicate a need for a cache is when I put one.