Matt, I really hate to be a bother. Have you had a quick sec to give this a quick test? I would really like to migrate ( pressure from infrastructure folks ) to MySQL 5.5.x?
Thanks, Charlie On Mar 2, 9:01 am, Skellington <[email protected]> wrote: > 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
