I am playing around with a Java program that gets DatabaseMetadata --
thanks to some help from Joe Eugene.
Much of the MetaData is retrieved from the JDBC Driver and returned in
the form of a java.sql.ResultSet , for example:
ResultSet tableRS = md.getTables(null,null,null,"TABLE");
returns information about all the tables in a database.
And:
ResultSet columnRS= md.getColumns(null,null,"someTableName",null);
returns information about all the Columns in a particular Table.
The Java example I am working with, traverses the ResultSet, extracts
the desired information, converts it to a String and appends it to a
StringBuffer.
The StringBuffer is returned to the CFMX program -- and it is a list
representation of a multi-demension ResultSet..
To do anything with the returned information, you must traverse the
list, being aware that every n list elements represent a row in the
original ResultSet.
It appears that half the effort could be eliminated by simply returning
the ResultSet to the CFMX program, and traverse (format) it there.
Is this possible?
Does anyone have a simple example of a Java program that returns a
ResultSet?
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
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
