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

Tuesday, September 16, 2003, 10:12:49 PM, Ralf Hauser wrote:

> 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!

Yes, however, FMPP has no out-of-the-box DB data loaders (yet!), so you
have to invent in Java. That is, you have to write some FMPP data
loaders. If you can do it with Java (JDBC), then it's really not hard to
wrap that functionality into data loader and/or FreeMarker transform, so
it will be fmpp-able.

> 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)

I see you are a heavy-weight FMPP user... :)

-- 
Best regards,
 Daniel Dekany




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