I need help wit the following error: An error occurred in executing an Activity Class

Question

Hi I am experiencing the following error while trying to write to mysql database, Problem: An error occurred in executing an Activity Class. Details: An error occurred while trying to write to the entity &ldquo;moduleStandardCost&rdquo; [id=65541bf2-d155-4aac-9542-579b89e0ba9f@10810, type=ICAMS_SerialStandardPrice (id=7196)] (data store: ICAMS Datastore). Details: org.hibernate.exception.GenericJDBCException: could not load an entity: [ICAMSSerialStandardPriceDT2874#23EX0416-GB]: java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Timestamp Data: TypedValue[it=7197,v={{23EX0416-GB,250000.0,,2016-07-29 15:14:20.79}}] Recommended Action: Examine the activity class to correct the error and then resume. Priority of this problem: High Priority Any Suggestions? 
 OriginalPostID-226414 
 OriginalPostID-226414

andys658 · Accepted Answer

Looks like your value of 0000-00-00 isn't in JDBC timestamp escape format; see docs.oracle.com/.../Timestamp.html for the format to use. I would suggest that the 0000-00-00 should actually be the year-month-day numbers, and you're not passing a time value after that.