hi felix, these topics have been discussed extensively in the dev list. check out e.g. http://thread.gmane.org/gmane.comp.apache.jackrabbit.devel/6166/focus=6172
cheers stefan On 4/19/06, Felix Satyaputra <[EMAIL PROTECTED]> wrote: > Hi All, > > I've got a question about DbFileSystem and > SimpleDbPersistenceManager. It seems that these two > classes are holding on to the single db connection and > the bunch of prepared statement initialised during > startup (please correct me if I am wrong). > > Is there a reason behind this? If the database > connection and prepared statements are pooled (using > dbcp, for example), would it break any compatibility > with the JCR specs? > > If using connection pool would not break JCR > compatibility, isn't it better to just create > connection and prepared statements on the go? We then > can configure jdbc url and driver which points to > pooled connection like dbcp and proxool. The db pool > then can handle reusing connection and prepared > statements. > > Any thoughts are appreciated. > > Cheers, > > Felix > > > > ___________________________________________________________ > To help you stay safe and secure online, we've developed the all new Yahoo! > Security Centre. http://uk.security.yahoo.com >
