0 Replies Latest reply on Mar 1, 2011 2:35 PM by Binh T

    ORM and DB2 date conversion problem

    Binh T

      I'm testing an orm application in a test environment with coldfusion 9 for windows and db2 for the IBM system i.


      I'm running into several problems with data conversion from orm to db2.


      The current problem is sending dates to db2.


      I keep getting the following error message:


      [SQL0180] Syntax of date, time, or timestamp value not valid.


      I looked in the hibernate log and I see the following sql bind statement:


      03/01 15:38:18 [web-12] HIBERNATE DEBUG - binding '28 February 2011' to parameter: 7


      In the coldfusion page, I am setting the date using the CreateODBCDate function within the object setter's parameter before the ormflush().


      Is the date format set by coldfusion or hibernate?


      I don't know if the above date format is the problem because it seems to work one minute and then the next it doesn't.


      I would appreciate any help with this problem.