1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

coldfusion DSN advanced connection settings

Discussion in 'Plesk for Windows - 8.x and Older' started by dlongnecker, Jun 19, 2008.

  1. dlongnecker

    dlongnecker Guest

    0
     
    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?
     
  2. sergius

    sergius Golden Pleskian

    28
    57%
    Joined:
    Nov 6, 2005
    Messages:
    1,898
    Likes Received:
    0
    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.
     
Loading...