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]
