Skip navigation
DavidSim2
DavidSim2 Calculating status...
Currently Being Moderated

CF10: zeroDateTimeBehavior Problem

Aug 6, 2012 2:14 PM

Tags: #datasource #cf10

I'm setting up a MySQL data source. For legacy compatibility I need to handle dates with the value 0000-00-00.

 

I can use the connection string zeroDateTimeBehavior=convertToNull to active that. However, this results in a rather odd error:

 

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

 

Help!

584 Views   3 Replies   Latest reply: brilang, Oct 16, 2012 12:45 PM
 
Replies
  • Dan Bracuk
    Currently Being Moderated
    1. Dan Bracuk,
    Aug 6, 2012 4:11 PM   in reply to DavidSim2
    Report

    Read this.  http://dev.mysql.com/doc/refman/5.1/en/datetime.html

     

    Pay attention to the supported range.  Decide what you want to do with dates outside that range.

     
    |
    Mark as:
  • DavidSim2
    Currently Being Moderated
    2. DavidSim2,
    Aug 7, 2012 1:11 AM   in reply to Dan Bracuk
    Report

    Thanks Dan. I could replace all the date fields with null, although that would conflict with a legacy system.

     

    zeroDateTimeBehavior is a valid connection property and the error message confirms that. My question is really why there is an error when the value I'm passing is clearly one of the values in the acceptable set.

     

    David.

     
    |
    Mark as:
  • brilang
    Currently Being Moderated
    3. brilang,
    Oct 16, 2012 12:45 PM   in reply to DavidSim2
    Report

    I am also seeing that error:

     

    Connection verification failed for data source: pcbcrm

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

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

    It has been reported as part of bug here

    https://bugbase.adobe.com/index.cfm?event=bug&id=3197321

     

    Hopefully Adobe fixes it soon.

     
    |
    Mark as:
Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points