Login for more options
Connection String in MySQL Datasource sent to Database with trailing space
When attempting to add a Connection String to a MySQL 4/5 Datasource, if the value is "allowMultiQueries=yes"
The message returned is:
Connection verification failed for data source: kplapdashboard
java.sql.SQLException: The connection property 'allowMultiQueries' only accepts values of the form: 'true', 'false', 'yes' or 'no'. The value 'yes ' is not in this set.
The root cause was that: java.sql.SQLException: The connection property 'allowMultiQueries' only accepts values of the form: 'true', 'false', 'yes' or 'no'. The value 'yes ' is not in this set.
Also tried with a value of "true" -- ensured no trailing space in the form on the DSN configuration page in the CF Admin
Steps to Reproduce:
Add a MySQL 4/5 datasource, add a Connection String of "allowMultiQueries=yes", submit the datasource, view error message (or try to load a page that uses the datasource)
Actual Result: error message above
Expected Result: no error, connection string properly sent to the database server
Any Workarounds: None I know of
My Hardware and Environment details: MacBook Pro, OS X 10.6, CF10 production build
|Platform(s)||Mac 10.6 for Intel|
|Found In Build||Final|
|Fixed In Build|
Paul White (Paul White)
8:37:38 AM GMT+00:00 Jun 26, 2013
Yes, this needs to be fixed as soon a possible. This makes moving from CF9 to CF10 questionable when you see such minor problems like this go unsolved. It also makes long term administration in CF10 more difficult when you have to manually hack a fix into the XML every time a DNS change is needed.
10:21:15 PM GMT+00:00 Nov 20, 2012
Adobe, you have done it again !! Please read and listen to the handfull of people that are still holding on to your server products. We are at update 5 for ColdFusion 10 and it still hasn't been resolved !!! Come-on !!
1:20:52 PM GMT+00:00 Oct 16, 2012
This does not work in CF10.
When you use the zeroDateTimeBehavoir=convertToNull in your connection string in CF10, you will receive this error
please fix asap
12:44:51 PM GMT+00:00 Oct 16, 2012
I am unable to create a DSN as required for legacy database reasons. This needs urgent fixing.
4:41:02 PM GMT+00:00 Jun 7, 2012
This bug prevents us from moving legacy code from Coldfusion 9