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/
