struts-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Van <van.ri...@gmail.com>
Subject Re: EXTERNALIZE SQL QUERIES
Date Wed, 07 Jul 2004 15:25:08 GMT
iBATIS and Hibernate will both allow you to externalize your SQL
queries. If all you are looking for right now is a way to place your
SQL statements in separate data files that allows you to insert values
dynamically at run time, iBATIS is a much simpler solution which
easily handles that for you. I'm not discouraging you from using
Hibernate. It might even be the right solution for you long term for
other reasons. For just the capability you are asking for right now
though, using Hibernate would be overkill in my opinion.

- Mike Van Riper
  Silicon Valley Web Developers JUG
  https://sv-web-jug.dev.java.net/

On Wed, 7 Jul 2004 19:49:39 +0800, Peng Tuck Kwok <pengtuck@gmail.com> wrote:
> Or use hibernate :D  .
> 
> 
> 
> On Wed, 07 Jul 2004 09:56:06 +0300, Andrew Stepanenko
> <andrews@ceis.tane.edu.ua> wrote:
> > Срд, 2004-07-07 у 06:48, Shailender Jain написав:
> > > Hi,
> > >
> > > I am using struts framework for the development of my application.
> > > I want to externalize the  sql queries written in my application to an
> > > xml file.
> > >
> > > For e.g. if i have got a query
> > > insert into employee (id, name) values (1, 'shailender');
> > >
> > > This should be written in xml as
> > > insert into employee (id, name) values ($id, $name);
> > >
> > > Where id and name are variables in the application of type int and
> > > string.
> > >
> > > Also if the id and name are arrays then it should insert all the values.
> > >
> > > Is there any api available for doing this without putting much effort in
> > > learning the api.
> > >
> > >
> > > Regards
> > > Shailender Jain
> > >
> > Hi,
> > Take a look at iBATIS SQL Maps http://www.ibatis.com
> >
> > Regards,
> > Andrew Stepanenko.

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


Mime
View raw message