Chris
The short answer: any or all the MetaData.
The long answer:
Back in the CF 4.5 MS-SQL 6.5 days, I wrote a utility program that will
extract this info from MS databases (Access & SQL-Server)
Now, I want to update/expand this to use other databases (MySQL,
PostgreSQL, Sybase, Oracle, etc), and to run under CFMX.
One of the key features of this "utility" is that, through a stub
program, it can manipulate databases on remote sites, where you don't
have administrative privileges to the dbs. The stub program can be
written in any language that supports WDDX.
For example, you can copy entire databases from one shared host to
another shared hose, or from one RDBMS to another.
So, I want to make the utility as general as possible supporting:
all CF platforms for the main program
all possible languages for the stub program
all versions of CF from 4.5 on
as many RDBMSs as possible (especially adding those with JDBC
drivers).
BTW, I run on CFMX on Mac OS X, and likely will use, mainly, a
combination of MySQL, PostgreSQL, Sybase_ASE, and Oracle, because these
all run on OS X, Linux and win platforms.
In addition I will interface SQL-Server and MS-Access on win, real or
emulated (for development). These, because they are so ubiquitous.
Dick
On Saturday, November 30, 2002, at 01:45 PM, Chris Kief wrote:
> 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
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
