Just wondering if there is any built-in support of caching database rows in JDBC. Currently, if there is some rows to be accessed repeatedly, to reduce the number of SQL calls, I will manually create a Map containing the rows with the Map's key=PK of the table. But maintaining the cache manually looks tedious so just want to know if JDBC already providing help in this area.
One advantage of this approach is that I also have an API that allows you to easily query and sort the array that is in cache (A limited sql syntax but still very handy).
For more info go to http://www.fdsapi.com. There are a couple powerpoints to the left that discuss ArraySQL. I also have a class called ResultSetConverter that puts a ResultSet into an Object. [ May 26, 2005: Message edited by: steve souza ]