Dick, Don't have an answer for ya but a question...what metadata are you trying to get exactly? Table names, column names, PKs, FKs, datatypes, etc.??
The reason I ask is couldn't this be returned by a SQL query instead. I know with SQL server I'm able to get all this information with just a cfquery. Seems like going to java to accomplish this task may be overkill... Just curious...chris -----Original Message----- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 30, 2002 1:13 PM To: CF-Talk Subject: [SOT] Returning a ResultSet form Java to CFMX 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 Get the mailserver that powers this list at http://www.coolfusion.com
