常連

■環境
Spring Tool Suite 4 
Version: 4.6.0.RELEASE
Build Id: 202003181317

mysql> select version();
+-----------+
| version() |
+-----------+
| 8.0.21    |
+-----------+
> mysql> desc mydata;
+-----------------+--------------+------+-----+-------------------+-----------------------------------------------+
| Field           | Type         | Null | Key | Default           | Extra                                         |
+-----------------+--------------+------+-----+-------------------+-----------------------------------------------+
| id              | int          | NO   | PRI | NULL              | auto_increment                                |
| name            | varchar(50)  | YES  |     | NULL              |                                               |
| mail            | varchar(510) | YES  |     | NULL              |                                               |
| age             | int          | YES  |     | NULL              |                                               |
| memo            | text         | YES  |     | NULL              |                                               |
| registered_date | datetime     | NO   |     | CURRENT_TIMESTAMP | DEFAULT_GENERATED                             |
| update_date     | datetime     | NO   |     | CURRENT_TIMESTAMP | DEFAULT_GENERATED on update CURRENT_TIMESTAMP |
| remove_date     | datetime     | YES  |     | NULL              |                                               |
| last_updated_by | varchar(50)  | YES  |     | NULL              |                                               |
+-----------------+--------------+------+-----+-------------------+-----------------------------------------------+

[root@71b31029 /]# java -version
openjdk version "11.0.8" 2020-07-14

■実施したいこと。
mydataに登録処理の際に、「registered_date」「update_date 」を自動で登録したい。

■ソース　mydataクラス　@Entity
```JAVA
package com.example.demogradle.domain.entity;
import java.util.Date;
import java.util.List;
import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.EntityListeners;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.OneToMany;
import javax.persistence.Table;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;
import javax.validation.constraints.Email;
import javax.validation.constraints.Max;
import javax.validation.constraints.Min;
import javax.validation.constraints.NotEmpty;
import javax.validation.constraints.NotNull;

import org.springframework.data.annotation.CreatedDate;
import org.springframework.data.annotation.LastModifiedDate;
import org.springframework.data.jpa.domain.support.AuditingEntityListener;

import org.springframework.lang.NonNull;

@Entity
@Table(name = "mydata")
@EntityListeners(AuditingEntityListener.class)
@NamedQueries({
		@NamedQuery(name = "findWithIdNameMail", query = "from MyData where id =  :fid or name like :fname or mail like :fmail")
		// 複数やる場合は、下記のように追加。※「,」を忘れずに。
		//,@NamedQuery(name = "findWithMail", query = "from MyData where mail like :fmail")
})
public class MyData {
	
	// 6-28　追加
	@OneToMany(cascade = CascadeType.ALL)
	@Column(nullable = true)
	private List<MsgData> msgdatas;
	
	public List<MsgData> getMsgdatas() {
	return msgdatas;
	}
	//ここまで
	
	//@OneToMany(cascade = CascadeType.ALL)
	@Id
	@GeneratedValue(strategy = GenerationType.AUTO)
	@Column //(name = "ID")
	@NonNull
	private Integer id;
	
	@Column(length = 50, nullable = false)
	@NotNull
	@NotEmpty
	private String name;
	
	@Column(length = 510, nullable = false)
	@Email
	@NotEmpty
	private String mail;
	
	@Column(length = 3, nullable = false)
	@Min(20)
	@Max(99)
	private int age;
	
	@Column(nullable = true)
	private String memo;
	
	@Temporal(TemporalType.DATE)
	@CreatedDate
	@Column(name = "registered_date", nullable = false, updatable = false)
	private Date registered_date;
	
	@LastModifiedDate
	@Temporal(TemporalType.DATE)
	@Column(name = "update_date", nullable = false)
	private Date update_date;

	@Temporal(TemporalType.DATE)
	@Column(nullable = true)
	private Date remove_date;
	
	@Column(nullable = false)
	private String last_updated_by;


	public Integer getId() {
		return id;
	}

	public void setId(Integer id) {
		this.id = id;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public String getMail() {
		return mail;
	}

	public void setMail(String mail) {
		this.mail = mail;
	}

	public int getAge() {
		return age;
	}

	public void setAge(int age) {
		this.age = age;
	}

	public String getMemo() {
		return memo;
	}

	public void setMemo(String memo) {
		this.memo = memo;
	}

	public Date getRegistered_date() {
		return registered_date;
	}

	public void setRegistered_date(Date registered_date) {
		this.registered_date = registered_date;
	}

	public Date getUpdate_date() {
		return update_date;
	}

	public void setUpdate_date(Date update_date) {
		this.update_date = update_date;
	}

	public Date getRemove_date() {
		return remove_date;
	}

	public void setRemove_date(Date remove_date) {
		this.remove_date = remove_date;
	}

	public String getLast_updated_by() {
		return last_updated_by;
	}

	public void setLast_updated_by(String last_updated_by) {
		this.last_updated_by = last_updated_by;
	}

}

```　
CrudController
```JAVA
@Controller
public class CrudController {

	@Autowired
	MyDataRepository myDataRepository;

	@RequestMapping(value = "/jpa/crud", method = RequestMethod.GET)
	public ModelAndView create(@ModelAttribute("formModel") MyData mydata,ModelAndView mav) {

		mav.setViewName("jpa/crud");
		mav.addObject("msg", "+his is sample content.");
		Iterable<MyData> list = myDataRepository.findAll();
		mav.addObject("datalist", list);
		return mav;
	}

	@RequestMapping(value = "/jpa/crud",method = RequestMethod.POST)
	@Transactional(readOnly = false)
	public ModelAndView createForm(@ModelAttribute("formModel") @Validated MyData mydata, 
			BindingResult result,
			ModelAndView mov) {

		ModelAndView res = null;
		if (!result.hasErrors()){
			myDataRepository.saveAndFlush(mydata);
			res = new ModelAndView("redirect:/jpa/crud");
		} else {
			mov.setViewName("jpa/crud");
			mov.addObject("msg","sorry, error is occured...");
			Iterable<MyData> list = myDataRepository.findAll();
			mov.addObject("datalist",list);
			res = mov;
		}
		return res;
	}

```
MyDataRepository
```JAVA
@Repository
public interface MyDataRepository extends JpaRepository<MyData, Integer> {
	
	public List<MyData> findAll();
	public Optional<MyData> findById(Integer id) ;
	public List<MyData> findByNameLike(String name);
	public List<MyData> findByIdNotNullOrderByIdDesc();
	public List<MyData> findByAgeGreaterThan(Integer age);
	public List<MyData> findByAgeBetween(Integer age20, Integer age22);
	
	// リスト6−16 Repositoryからクエリーを投げる場合
	@Query("SELECT d FROM MyData d ORDER BY d.name")
	public List<MyData> findAllOrderByName();
}
```
crud.html （thymeleaf）一部抜粋
```html
	<body>
		<div th:replace="/common/header :: header"></div>
		
		<h1 th:text="#{content.title.crud}">データCRUD</h1>
	
		<table border="1" >
			<form method="post" action="/jpa/crud" th:each="object:${formModel}" th:object="${formModel}" >
			<h2 th:text="#{content.title.create}">データ登録</h2>
			
			
				<tr><td><label for="name">名前</label></td>
					<td><input type="text" name="name" th:value="*{name}" th:errorclass="err" class="sample5"></input>
						<div th:if="${#fields.detailedErrors('name')}" th:errors="*{name}" th:errorclass="err"></div>
					</td>	
				</tr>
				<tr><td><label for="age">年齢</label></td>
					<td><input type="text" name="age" th:value="*{age}" th:errorclass="err" class="sample5"></input>
						<div th:if="${#fields.detailedErrors('age')}" th:errors="*{age}" th:errorclass="err"></div>
					</td>
				</tr>
				<tr><td><label for="mail">メール</label></td>
					<td><input type="text" name="mail" th:value="*{mail}" class="sample5"></input>
					<div th:if="${#fields.detailedErrors('mail')}" th:errors="*{mail}" th:errorclass="err"></div>
					</td>
				</tr>
				<tr><td><label for="memo">メモ</label></td>
					<td><textarea name="memo" th:text="*{memo}" cols="20" rows="5" class="sample5"></textarea></td>
				</tr>
				<tr><td><label for="last_updated_by">登録者</label></td>
					<td><input type="text" name="last_updated_by" th:value="*{last_updated_by}" class="sample5"></input></td>
				</tr>
				<tr><td></td><td><input type="submit" value="登録" class="sample5"></td>
				</tr>				
			</form>
		</table>

```

エラー内容
> 2020-09-13 16:56:39.444 ERROR 3521 --- [io-18443-exec-7] o.h.engine.jdbc.spi.SqlExceptionHelper   : Column 'registered_date' cannot be null
2020-09-13 16:56:39.456 ERROR 3521 --- [io-18443-exec-7] o.a.c.c.C.[.[.[/].[dispatcherServlet]    : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement] with root cause
java.sql.SQLIntegrityConstraintViolationException: Column 'registered_date' cannot be null

エラー内容から、「registered_date」がnullと言うことでエラーになっていると思いますが、formで入力設定しなくても、値があるようにmysqlでは設定しているのですが、Spring側でエラーになっているかと思うのですが。
いろいろ試しのですが、うまく思うように動作できず。
すいませんが、教授お願いします。

質問編集履歴