I have tried jdbc, hibernate, and iBATIS for data access. For me, it was a matter of finding a balance between simplicity (low-level jdbc resouce management sucks), power (how can I optimize this SQL statement?), flexibilty (do not dictate to me how to write applications), and testability (mocking ResultSet objects is a PITA).
I am now using iBATIS for 99.999% of all new development (oracle ref cursors are still a thorn in my side). The DAO+SQLMaps combination is really (IMO) the sweet spot (and it is an Apache project, if that means anything to you). http://incubator.apache.org/projects/ibatis.html Larry On Wed, 2 Feb 2005 10:58:34 +0000, Ben Taylor <[EMAIL PROTECTED]> wrote: > So you use one approach or the other? > > > On Tue, 01 Feb 2005 18:43:41 -0600, Vic <[EMAIL PROTECTED]> wrote: > > See if this helps: > > > > http://wiki.apache.org/struts/DaoRelated > > > > .V > > > > Ben Taylor wrote: > > > > >Can anyone tell me the best way to setup / manage database connections > > >using Struts? > > > > > >I've read a couple of books on Struts and they talk about using a > > >processbean though I am unsure how this is linked with things like > > >iBATIS (http://www.ibatis.com/), or the Struts DataSource manager (as > > >both mentioned on http://struts.apache.org/faqs/database.html). > > > > > >Any advice / suggestions would be appreciated. > > > > > >Cheers! > > > > > > > > > > -- > > Forums, Boards, Blogs and News in RiA <http://www.boardVU.com> > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]