my dog learned polymorphism*
The moose likes JDBC and the fly likes Creating a DB Framework Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Creating a DB Framework" Watch "Creating a DB Framework" New topic
Author

Creating a DB Framework

sandy gupta
Ranch Hand

Joined: Jan 30, 2001
Posts: 228
I am working on Creating a DB Framework for Read Only Information and i would like to share some of the points that could be really helpful which have come up from the 3 days of research that i have put into it thus far.......I hope the next week and a half will yield even more information...............
I would really appreciate if some one would like to add their thoughts as to how i could make this better.
To Create a DB framework that is efficient as well as non-resource and CPU intensive, i will be using
a) Cached Prepared Statements: This is a feature that the Weblogic 7.0 provides in which the connection pool will cache the prepared statements so that the next time the same statement is executed on that pool, the overhead of preparing and parsing a statement is avoided. Will have to watch out for overkill in this case
b) Start Up Classes for Static DB Objects: Planning on getting some start up classes which will act as a cache for my static DB objects which are frequently accessed and hardly changed.
c) Of Course Connection Pools: What i plan to do is to get the handle to all the connections in a pool and then distribute them to applications and when the connections seem to be getting over, i use an asynchronous call to increase the connections and store them. I do not know for sure whether this is a good idea to be implemented. Advice.
d) Providing an API for functions that will let the users of this f/w get the RS for some of the generic methods and a control over the DB to an extent.
This is all that i could come up with till now...........Any more will be welcome
Ciao


Adios
 
wood burning stoves
 
subject: Creating a DB Framework