Hi!, I've a big project with WAS 6.1-JAVA 1.5-oracle with the next structure
-40 Projects (forms) very similar with similar querys, they only read from database (only select, nor update neither insert)
-1 Common project that manages all the database connections and is a shared library for the 40 projects.
My question is, which is the best method to cache those database connections?. I've one shared library for a lot of similar projects.
I've read a lot about cachedrowset, OSCache, spring, hibernate, JDBC Connection... but I think AOP like hibernate is not necessary, all the queries always return a pair value-key objects, what do you recommend me? I'm looking something that permits optimize database conection access more than object caching.