ColdFusion 10.0  -  Bug 3197321

Created on Wednesday, May 23, 2012

Login for more options

Title

Connection String in MySQL Datasource sent to Database with trailing space

Description

Problem Description:
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

Test Configuration

My Hardware and Environment details: MacBook Pro, OS X 10.6, CF10 production build

App Language(s) English
OS Language(s) English
Platform(s) Mac 10.6 for Intel
Browser(s) Browsers All

Notes (10)

  • Nimit Sharma

    9:31:21 PM GMT+00:00 Dec 3, 2013

    @screennameunavailable99:

    This is only occurring when I am giving spaces deliberately at the end of "allowMultiQueries=yes"
    Can you please verify it once and provide me the exact connection string which you are using?

    Regards,
    Nimit

  • wallawallajim

    7:05:41 AM GMT+00:00 Jun 10, 2013

    I just installed CF10 update 10 and this issue still exists, why is it not fixed?

  • screennameunavailable99

    9:28:17 PM GMT+00:00 Nov 16, 2012

    Just applied Updater 4 - this error is still present.

    Exact string tried is: allowMultiQueries=yes

    Adding "&" at the end of the string entered in the CF Administrator is a great work-around to this!

  • Asha K S

    4:01:54 AM GMT+00:00 Nov 9, 2012

    Can you please try using & instead of ; in the Connection String, that should not cause this error.Also i see the same issue happening with CF9.0.2.
    Can you please let us know the exact Connection String you are using.

  • revdave

    1:20:02 PM GMT+00:00 Oct 16, 2012

    issue appears in this thread

    http://forums.adobe.com/message/4779168#4779168

  • brilang

    4:34:53 PM GMT+00:00 Oct 15, 2012

    I am also seeing this bug with zeroDateTimeBehavior=convertToNull

  • screennameunavailable99

    5:41:57 PM GMT+00:00 Sep 4, 2012

    The latest updater (10.0.1) did not fix this issue -- it continues to be a show-stopping problem for getting code that worked fine on CF9 to work on CF10 because that code assumes this setting in the CF datasource.

  • screennameunavailable99

    11:33:39 PM GMT+00:00 Jun 8, 2012

    Looking at new-datasource.xml the datasource, after being created, has the following extra characters in the URL var for the connection:

    <char code='0a'/><char code='09'/><char code='09'/><char code='09'/><char code='09'/><char code='09'/><char code='09'/><char code='09'/>

    Removing those and restarting CF allows the datasource to be verified.

    If the datasource is then edited via the CF Admin UI the problem returns.

  • cdsdave

    4:51:51 PM GMT+00:00 Jun 7, 2012

    This was also occurring on a Linux 64 Bit install
    *** Workaround ***
    Setup a new datasource with type other
    JDBC URL = jdbc:mysql://xxx.xxx.xxx.xxx:3306/dbName?zeroDateTimeBehavior=convertToNull
    Driver class = com.mysql.jdbc.Driver
    Driver name = MySQL (Other)

  • cdsdave

    4:39:51 PM GMT+00:00 Jun 7, 2012

    This also appears to impact zeroDateTimeBehavior=convertToNull with the same issue. I have reviewed the neo-datasource.xml file and the additional space isn't shown within the file but the datasource validator still flags as an error and refuses to use the datasource

Duplicate ID
Reported By screennameunavailable99

Status

State Open
Status ToTrack
Reason PRNeedInfo

Importance

Priority 3-High
Frequency All users will encounter
Failure Type Incorrectly Functioning
Product Area Database

Build

Found In Build Final
Fixed In Build

Attachments (0)

No Files Attached

Votes (5)

  • 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.

  • Netadvanced

    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 !!

  • revdave

    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

  • brilang

    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.

  • cdsdave

    4:41:02 PM GMT+00:00 Jun 7, 2012

    This bug prevents us from moving legacy code from Coldfusion 9

Your session has expired! Click to login
Current form data will be preserved

Cancel