I am implementing a generalized process to retrieve DatabaseMetadata
through the JDBC driver. This should support any RDBMS that has a JDBC
driver.
This requires use of a Java program because CFMX cannot be induced to
create a null (necessary for the interface to the DatabaseMetadata).
Thanks to a lot of help from others, the basics are working:
A CFMX template invokes the Java program, passing a request
The Java program retrieves the DatabaseMetadata.
The Java program returns the requested information (usually a
java.sql.ResultSet or a string) to the CFMX template
The CFMX template formats and presents the information.
The interface will invoke several different methods in the Java program,
for example:
Get the names of all the Tables in a particular database
Get the names all the columns in a specific database (in the order
defined)
Get the attributes of columns in a specific database
Get the ResultSet from executing a database query
OK?
My questions are:
What interface should I use -- the CFX custom tag or cfobject?
Can either be recompiled without recycling CFMX (to recognize
the latest class file)?
Is it more likely that a remote shared host would install one or the
other?
Is there a Java WDDX interface?
As Jochem has suggested, a better solution would be for MM to provide a
cfdatabasemetada tag, but until that is available I need to roll my own.
TIA
Dick
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
