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]