Erik, Oh, I have worked on a project where that was the pattern I designed for myself!! One accepted a connection for transactions, the other for self-contained singleton executions. Yup, it's a great pattern.
You raise an interesting point. I never thought about using a middle-man between my business tier and DAO. I'll have to think about that. And yes, I do use connection pooling -- good point! I guess there is not a performance gain in keeping the connection around at the instance level. Perhaps I am being scrupulous and trying to save time with the pool code, but that's ridiculous. It's better to put it back in the pool because at the millisecond level, many more threads could be using it in between my thread. And, I like the IBATIS idea described by Larry... but sorry, I love Hibernate :-) I don't use it yet, but I am on board whenever I get to use it. Thanks! Paul ____________________________________________________ Start your day with Yahoo! - make it your home page http://www.yahoo.com/r/hs --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]