You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@struts.apache.org by Ben Taylor <be...@gmail.com> on 2005/02/02 01:37:07 UTC

Database Access

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!

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org


Re: Database Access

Posted by Larry Meadors <la...@gmail.com>.
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 <be...@gmail.com> wrote:
> So you use one approach or the other?
> 
> 
> On Tue, 01 Feb 2005 18:43:41 -0600, Vic <vi...@friendvu.com> 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: user-unsubscribe@struts.apache.org
> > For additional commands, e-mail: user-help@struts.apache.org
> >
> >
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> For additional commands, e-mail: user-help@struts.apache.org
> 
>

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org


Re: Database Access

Posted by Ben Taylor <be...@gmail.com>.
So you use one approach or the other?


On Tue, 01 Feb 2005 18:43:41 -0600, Vic <vi...@friendvu.com> 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: user-unsubscribe@struts.apache.org
> For additional commands, e-mail: user-help@struts.apache.org
> 
>

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org


Re: Database Access

Posted by Vic <vi...@friendvu.com>.
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: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org