Hi Alan, No problem. Yes the cacheResultSetMetadata=false is in the host string in the xml file.
Charlie On Feb 24, 11:48 am, Alan Holden <[email protected]> wrote: > Not much help. I'm running MySQL version 5.0.51. > > Within your bluedragon.xml file, have you checked the <hoststring> node > of your datasource to insure that the URL contains > "cacheResultSetMetadata=false" ? > > It seems like the newer 5.5 mySQL engine may have changed what it's > returning. Perhaps this page might help AW estimate possible > causes:http://dev.mysql.com/doc/refman/5.5/en/news-5-5-9.html > > Sorry if I'm late to this thread and repeating stuff. > > Al > > On 2/24/2011 11:01 AM, Skellington wrote: > > > > > Hi Alan, > > What version of MySQL are you using? My production MySQL DB is 5.0.x > > and this works just fine as well. But my development DB is 5.5.9 and > > this does not work. > > > Charlie > > > On Feb 24, 10:42 am, Alan Holden<[email protected]> wrote: > >> FWIW - This works on my system: > > >> <cfquery datasource="redacted" name="qTables"> > >> SHOW TABLES > >> </cfquery> > >> <cfdump var="#qtables#"><cfabort> > > >> I'm running a Tomcat distro: > >> Open BlueDragon Product Version 1.4a > >> Open BlueDragon Build Date 2010-08-07 01:00:38 GMT > >> Operating System Ubuntu Linux i386 (2.6.24-19-server) > >> Application Server Apache Tomcat/6.0.20 > >> Java Virtual Machine Sun Microsystems Inc. 1.6.0_17 > >> MySQL 4/5 (MySQL) > >> Per-Request Connections: no > >> Cache Result Set Metadata: no > >> WEB-INF/lib/mysql-connector-java-5.1.12-bin.jar -- official tag/function reference: http://openbd.org/manual/ mailing list - http://groups.google.com/group/openbd?hl=en
