Hello Hibernate does something like that, you may want to Have a look at it.. Alternatively, I have done a similar thing for my own webapp, Where I have a 'persistence layer' that reads an xml config File where I list all sql statements and mapping between Columns and DTO fields (I user reflections for populating DTOs..) I am using digester to build a Map out of the XML.. Not so difficult, however if there is a tool that does it For you (Hibernate for example), it will save you time :-)
My 2 cents... Regards marco -----Original Message----- From: Ashish Kulkarni [mailto:[EMAIL PROTECTED] Sent: 27 October 2004 18:02 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]