Hi This is what i want to achieve by keeping the SQL statement outside java code, I can change the SQL statement with out having to compile the java program. The resltset will be returned to another java program So ClassA calls ClassB, ClassB reads my.xml file, which has a SQL statement, ClassB will execute it and return resultset to ClassA
Ashish --- "David G. Friedman" <[EMAIL PROTECTED]> wrote: > Ashish, > > Where do you want your resultSet returned? You can > use Hibernate(.org) in a > webapp or stand-alone (even command line) program. > It uses XML > configuration files. If you're looking to start the > data layer and have it > run a prepared statement to put into memory for > later use, you could do that > as well. If you did that in Struts, I'd suggest > using the Hibernate plugIn > then add something at the end of the Init() method > so it loads your query > and stores the results in the application scope for > all visitors to access. > Hibernate supports named queries with and without > parameters. > > Regards, > David > > -----Original Message----- > From: Ashish Kulkarni > [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 27, 2004 1:02 PM > To: [EMAIL PROTECTED] > Subject: [OT] SQL in XML file > > > Hi > Is there any code out there or any one worked on a > framework, where we can define SQL statements in XML > file and at runtime java program will read this XML > file, build the SQL if prepared statement and > execute > it and return a ResultSet > > What may be the points to be taken into > consideration > if i have to write a new one > Ashish > > > > __________________________________ > Do you Yahoo!? > Yahoo! Mail Address AutoComplete - You start. We > finish. > http://promotions.yahoo.com/new_mail > > --------------------------------------------------------------------- > 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] > > __________________________________ Do you Yahoo!? Yahoo! Mail Address AutoComplete - You start. We finish. http://promotions.yahoo.com/new_mail --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
