anybody has a tool to extract field and table names out of mysql into xml, i.e. a free-marker usable data format

Hi,

As described in http://bugs.mysql.com/1307, just entering field names as
strings into prepared-statements and ResultSet processing is nuisance in
java-relational DB implementations because such errors normally are not
detected at compile time, but only at run-time.

If there was a way to extract the field and table names in a fmpp-able
manner, this would be significant efficiency gain!

Anybody on the list has a recommendation, please share!

Regards

	Ralf

P.S.: I am using a similar approach with struts with great success:
1) I use an xml file to maintain my error list. An fmpp script then produces
the ErrorConstants.java with the two (!) error constants per string required
by struts as well as the file that manages the error texts
2) similarly, I store the strings used both in the *Action.java to store
into the session as well as in the jsp's to retrieve the beans also in an
xml. This xml again is used to create a GUIConstants.java file as well as
gc_const.ftl (since I pre-process all my jsp's with fmpp)



-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf