3 Replies Latest reply on Nov 25, 2009 8:18 PM by PraveenKumar D

    How to insert Date into Database from workbench.

    PraveenKumar D Level 1




      I have requirement where  I need to  insert the currentDate and Time to the database.   Here I am using  as


      At SQL Statement Info Editor ,have like these :


      Type     value

      Date     parse-dateTime(current-dateTime())


      At DB I have Datatype  as DateTime( Using MySQL). Here i am getting error like :


      Caused by: com.adobe.idp.dsc.jdbc.exception.JDBCIllegalParameterException: Type mismatch is found when preparing SQL statement. Expecting type 'date', but got type 'String'.


      Could  any one tell me where I can find  detailed log say hibernate type... where exatly we are  getting error.(Expect jboss's server log).


      Please tell how to  insert the date into the DB ASAP.