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

      Hi

       

       

      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.

       

      Thanks

      Praveen