coldfusion DSN advanced connection settings

[dlongnecker]

On the coldfusion DSN advanced connection settings, I can add one setting, but I can't add two.

This will work: zeroDateTimeBehavior=convertToNull

But if I try to add another one, seperated by a semicolon, it doesn't recognize the semicolon as the break and complains:

zeroDateTimeBehavior=convertToNull;zeroDateTimeBehavior=convertToNull;

java.sql.SQLException: The connection property 'zeroDateTimeBehavior' only accepts values of the form: 'exception', 'round' or 'convertToNull'. The value 'convertToNull; zeroDateTimeBehavior=convertToNull;' is not in this set.

Is there a way to add multiple connection strings?

 

[sergius]

Hello dlongnecker,

Thank you for the report.

This is known ColdFusion issue - if you will create new MySQl 4/5 DSN through ColdFusion admin's panel with the parameters "zeroDateTimeBehavior=convertToNull;characterEncoding=utf8" then you will get error described above.
The issue is actual with MySQL driver only.

Please try to use
zeroDateTimeBehavior=convertToNull&characterEncoding=utf8
instead
zeroDateTimeBehavior=convertToNull;characterEncoding=utf8.