This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes JDBC database connection Cache Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC database connection Cache " Watch "JDBC database connection Cache " New topic
Author

JDBC database connection Cache

JP Bar
Greenhorn

Joined: Feb 17, 2009
Posts: 2
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.

Thanks in advance!
ujjwal soni
Ranch Hand

Joined: Mar 28, 2007
Posts: 403
You can use IBATIS persistance framework. It supports caching for select queries, it supports many features for caching. It can be configured via SQLMAP.xml file.


Cheers!!!

Ujjwal B Soni
<baroda>
<gujarat>
<india>
<919998971048>


Cheers!!!
Ujjwal B Soni <baroda, gujarat, india> <+919909981973>
"Helping hands are better than praying lips......"
ujjwal soni
Ranch Hand

Joined: Mar 28, 2007
Posts: 403
It also supports native SQL & it returns in java.util.List or hashmap. I think it would be much reliable & easy if you use it in your project.

XML-based Object/Relational mapping and persistence framework as well as a data access abstraction layer. [Open source]
ibatis.apache.org

Cheers!!!

Ujjwal B Soni
<baroda>
<gujarat>
<india>
<919998971048>
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC database connection Cache
 
Similar Threads
c3p0 configuration
Connection
Should I use Hibernate?
Does jboss support pool of preparedstatement?
Netbeans Usage