There are a few reasons I don't use JDBC metadata. 1) In 6.1 it's not supported. No way around this.
2) To use the same technique as 6.1 in 7 it's not supported. Or, to use the admin password, you'd have to have that in plain text on disk but wont work in 6.1. 3) Not all drivers support the same level of JDBC metadata as others. So even though you could, in theory, use JDBC, it still doesn't give you all the information you need. 4) It's not hard to write the dbms adaptors. I've gone down this road a few times. Each time I come out with the same answer: It's a bad idea. Doug -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cliff Meyers Sent: Monday, April 10, 2006 10:58 AM To: [email protected] Subject: Re: [Reactor For CF] JDBC Metadata Paul, I know this technique isn't "supported" by MM but I've seen it pop up in a number of places: http://coldfusion.sys-con.com/read/45569.htm <cfscript> dss = CreateObject("java", "coldfusion.server.ServiceFactory"); dss = dss.getDataSourceService(); conn = dss.getDataSource("yourDSN"); conn = conn.getConnection("username","password"); mdata = conn.getMetaData(); </cfscript> <cfdump var="#mdata#"> It seems like it would help simplify the metadata code considerably if it were to be used in Reactor. -Cliff On 4/10/06, Paul Kenney <[EMAIL PROTECTED]> wrote: > I have spent the last week or so going through all the archives, and there > is very little (almost none) discussion of retrieving the database metadata > via JDBC. My thinking is that right now, in order to add a new database type > one has has to implement an ObjectDao class and a Convention class. It seems > that if JDBC was used to retrieve the metadata, the need for a specific > ObjectDao classes who's sole purpose is to get the metadata for each DB > object might simply go away in favor of a single class. > > The main problem I see at this point is getting a JDBC connection url based > on a CF dsn value without too much trouble (or the password for the CF > admin). > > Any thoughts? > > Thanks > > -- > Paul Kenney > [EMAIL PROTECTED] > http://www.pjk.us -- Reactor for ColdFusion Mailing List -- > [email protected] -- Archives at > http://www.mail-archive.com/reactor%40doughughes.net/ -- Reactor for ColdFusion Mailing List -- [email protected] -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/ -- Reactor for ColdFusion Mailing List -- [email protected] -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/
