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 <[EMAIL PROTECTED]> wrote: > Or use hibernate :D . > > > > On Wed, 07 Jul 2004 09:56:06 +0300, Andrew Stepanenko > <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
