Re: Default mysql TIMESTAMPS not allowed NULL
Re: Default mysql TIMESTAMPS not allowed NULL
- Subject: Re: Default mysql TIMESTAMPS not allowed NULL
- From: Tim W via Webobjects-dev <email@hidden>
- Date: Wed, 11 Nov 2020 15:13:51 -0800
John:
Off the top of my head these may be a couple options:
1. In your EO super class, override willInsert or awakeFromInsertion. The
former assumes you’re extending ERXGenericRecord. Not so elegant but you could
clobber every instance of a certain attribute type - with some overhead.
2. Possibly override MySQLExpression.formatValueForAttribute ? Force what you
want when a certain attribute type is null. Maybe poll for the version of mysql
there?
Tim
UCLA GSE&IS
> On Nov 11, 2020, at 2:20 PM, John Pollard via Webobjects-dev
> <email@hidden> wrote:
>
> Hi again list,
>
> My move to Catalina forced me to mysql 8. The previous version allowed NULL
> to be passed to TIMESTAMP fields causing mysql to set them automatically, but
> the NULL passed in the INSERT statements causes an error.
>
> From reading around I believe they should be passed as a blank “” rather than
> NULL in order for mysql to default them. I should update my Wonder snapshot
> as perhaps it is fixed in Wonder now, but I am wary of making too many
> changes all at once. The lesson I suppose is to keep all aspects reasonably
> up to date in good time!
>
> Is there a quick way to set all fields that are of type
> dateTimeStampPrototype in the EOModel to be blank rather than NULL? Or I
> could just set them to now in code, but is there one place I can do it rather
> than in every entity class?
>
> Thanks
> John
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list (email@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden