tag:blogger.com,1999:blog-5743359.post5798350328631812601..comments2023-11-02T05:03:34.235-04:00Comments on Tom Jordahl's musings: Faster MySQL JDBC driver for ColdFusionTomhttp://www.blogger.com/profile/02008328853735352613noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-5743359.post-54374290029696594462008-08-25T09:20:00.000-04:002008-08-25T09:20:00.000-04:00Do you know how to set CF to use this driver by de...Do you know how to set CF to use this driver by default when creating a MYSQL DSN instead of having to create a DSN with type OTHER.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5743359.post-52860983966918902302007-07-30T09:48:00.000-04:002007-07-30T09:48:00.000-04:00Just a warning that we have had problems with the ...Just a warning that we have had problems with the new driver when using ON DUPLICATE KEY UPDATE syntax. Seems that the sql cache doesn't get reset on either 5.0.x or the 5.1.x beta, so updates are happening in the DB but not being shown in subsequent selects via CF. Reverting to the 3.1.12 driver, it works fine again.Julianhttps://www.blogger.com/profile/15072414528714052266noreply@blogger.comtag:blogger.com,1999:blog-5743359.post-18426726888352518172007-07-23T12:25:00.000-04:002007-07-23T12:25:00.000-04:00*anonymous* - I don't know why the MySQL team chan...*anonymous* - I don't know why the MySQL team changed the settings, we don't 'configure' the MySQL driver at all.<BR/><BR/>*adam* - We call this API so that we can keep this info about each column of the result set. We have done this for all queries since CFMX 6, and MySQL was the only one that did a round trip to the server <I>for every call</I>.Tomhttps://www.blogger.com/profile/02008328853735352613noreply@blogger.comtag:blogger.com,1999:blog-5743359.post-90519822871400500612007-07-22T06:04:00.000-04:002007-07-22T06:04:00.000-04:00Gah, here's the link:http://bugs.mysql.com/bug.php...Gah, here's the link:<BR/><BR/>http://bugs.mysql.com/bug.php?id=25978Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5743359.post-5063619210106848082007-07-22T06:03:00.000-04:002007-07-22T06:03:00.000-04:00Seems like the fix is based on a bug report I file...Seems like the fix is based on a bug report I filed a while back. <BR/><BR/>Great news ;)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5743359.post-43558627850863027142007-07-21T14:05:00.000-04:002007-07-21T14:05:00.000-04:00In what situations is CF calling this "ResultSetMe...In what situations is CF calling this "ResultSetMetadata.isCaseSensitive()" method on "every column on every table it sees"? And why?<BR/><BR/>-- <BR/>AdamUnknownhttps://www.blogger.com/profile/02120069486623450492noreply@blogger.comtag:blogger.com,1999:blog-5743359.post-84386435273753863332007-07-21T00:05:00.000-04:002007-07-21T00:05:00.000-04:00you said: "might be a good idea depending on your ...you said: "might be a good idea depending on your application's use of the database"<BR/><BR/>Can you elaborate on this and in what cases this would be of benefit? If the MySql team is recommending it as a default why wouldnt CF8 just ship with that as the default config?Anonymousnoreply@blogger.com