常連

### 前提・実現したいこと

PostgreSQL12.8から統計データを取得して表示させたいです。
データベース、ユーザーを作り、A5:SQL Mk-2によりデータをインポートし、
ソースを書いてSTSを実行したところ、以下のエラーメッセージが発生しました。

### 発生している問題・エラーメッセージ

ネットでログメッセージを調べ、pom.xmlにdependencyを追加、application.propertiesを修正等しましたが、どうやってもPostgreSQLにアクセスしている気配がないため、ご教授お願い致します。

```
Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
2021-12-17 09:56:42.521 ERROR 39472 --- [           main] o.s.boot.SpringApplication               : Application run failed

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean]: Factory method 'entityManagerFactory' threw exception; nested exception is java.lang.RuntimeException: Driver net.sourceforge.jtds.jdbc.Driver claims to not accept jdbcUrl, jdbc:postgresql://localhost:5432/otnj?user=otnj&sslmode=disable&password=<masked>
	at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:658) ~[spring-beans-5.3.13.jar:5.3.13]
中略
Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean]: Factory method 'entityManagerFactory' threw exception; nested exception is java.lang.RuntimeException: Driver net.sourceforge.jtds.jdbc.Driver claims to not accept jdbcUrl, jdbc:postgresql://localhost:5432/otnj?user=otnj&sslmode=disable&password=<masked>
	at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:185) ~[spring-beans-5.3.13.jar:5.3.13]
	at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:653) ~[spring-beans-5.3.13.jar:5.3.13]
	... 19 common frames omitted
Caused by: java.lang.RuntimeException: Driver net.sourceforge.jtds.jdbc.Driver claims to not accept jdbcUrl, jdbc:postgresql://localhost:5432/otnj?user=otnj&sslmode=disable&password=<masked>
	at com.zaxxer.hikari.util.DriverDataSource.<init>(DriverDataSource.java:110) ~[HikariCP-4.0.3.jar:na]
中略
	... 20 common frames omitted
```

### 該当のソースコード

pom.xml
```xml
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
	<modelVersion>4.0.0</modelVersion>
	<parent>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-parent</artifactId>
		<version>2.6.1</version>
		<relativePath/> 
	</parent>
	<groupId>com.sct</groupId>
	<artifactId>OTNJSpring</artifactId>
	<version>0.0.1</version>
	<name>OTNJSpring</name>
	<description>OTNJ Spring Project for Spring Boot</description>
	<properties>
		<java.version>11</java.version>
	</properties>
	<dependencies>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-thymeleaf</artifactId>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-web</artifactId>
		</dependency>

		<dependency>
			<groupId>org.postgresql</groupId>
			<artifactId>postgresql</artifactId>
			<scope>runtime</scope>
		</dependency>
		<dependency>
          <groupId>org.springframework.boot</groupId>
          <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>

        <dependency>
          <groupId>javax.xml.bind</groupId>
          <artifactId>jaxb-api</artifactId>
        </dependency>

        <dependency>
          <groupId>net.sourceforge.jtds</groupId>
          <artifactId>jtds</artifactId>
        </dependency>

        <dependency>
          <groupId>org.springframework.boot</groupId>
          <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>

        <dependency>
          <groupId>org.hibernate</groupId>
          <artifactId>hibernate-core</artifactId>
        </dependency>

        <dependency>
          <groupId>org.hibernate</groupId>
          <artifactId>hibernate-entitymanager</artifactId>
        </dependency>
		
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-test</artifactId>
			<scope>test</scope>
		</dependency>
	</dependencies>

	<build>
		<plugins>
			<plugin>
				<groupId>org.springframework.boot</groupId>
				<artifactId>spring-boot-maven-plugin</artifactId>
			</plugin>
		</plugins>
	</build>

</project>
```

application.properties
```properties
spring.datasource.url=jdbc:postgresql://localhost:5432/otnj?user=otnj&sslmode=disable&password=otnj
spring.datasource.username=otnj
spring.datasource.password=otnj
spring.datasource.driver-class-name=net.sourceforge.jtds.jdbc.Driver
logging.level.org.hibernate.SQL=DEBUG
logging.level.org.hibernate.type.descriptor.sql.BasicBinder=TRACE
logging.level.org.springframework.web=DEBUG
logging.level.org.hibernate=DEBUG
spring.jpa.show-sql=true
spring.jpa.properties.hibernate.format_sql=true
```

```SQL
create table stat(
    id integer
    , row integer
    , col integer
    , data double precision not null
    , constraint stat_pk1 primary key (id, row, col)
)
```

```Java
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
public class OtnjSpringApplication {

	public static void main(String[] args) {
		SpringApplication.run(OtnjSpringApplication.class, args);
	}

}
```

```Java
import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.GetMapping;

@Controller
public class StatController {
	@Autowired
	private StatService statService;

	@GetMapping(value = "/stat")
	public String displayList(Model model) {
		List<Stat> statList = statService.searchAll();
		model.addAttribute("statList", statList);
		return "stat";
	}
}
```

```Java
import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

@Service
public class StatService {

	@Autowired
	private StatRepository statRepository;

	public List<Stat> searchAll() {
		return statRepository.findAll();
	}
}
```

```Java
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.stereotype.Repository;

@Repository
public interface StatRepository extends JpaRepository<Stat, StatCell> {

}
```

```Java
import javax.persistence.Column;
import javax.persistence.Embeddable;

@Embeddable
public class StatCell {
	@Column(name = "id")
	private Integer id;
	
	@Column(name = "row")
	private Integer row;
	
	@Column(name = "col")
	private Integer col;
}
```

```Java
import java.io.Serializable;

import javax.persistence.Column;
import javax.persistence.EmbeddedId;
import javax.persistence.Entity;
import javax.persistence.IdClass;
import javax.persistence.Table;

@Entity
@Table(name="stat")
@IdClass(value=StatCell.class)
public class Stat implements Serializable {
	
	private static final long serialVersionUID = 6501935237628672264L;

	@EmbeddedId
	private StatCell cell;
	
	@Column(name = "data")
	private Double data;
}
```

```html
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml" xmlns:th="http://www.thymeleaf.org">
  <head>
    <title>推移</title>
    <meta charset="utf-8" />
  </head>
  <body>
    <h1>推移</h1>
  <table>
    <thead>
      <tr>
        <th>年</th>
        <th>数</th>
      </tr>
    </thead>
    <tbody>
        <tr th:each="stat : ${statList}" th:object="${stat}">
            <td class="center" th:text="*{row}"></td>
            <td class="center" th:text="*{data}"></td>
        </tr>
      </tbody>
  </table>
  </body>
</html>
```
### 試したこと

JDBCのURLとデータ取得をpsqlで確認しました。
```bash
> psql -d 'postgresql://localhost:5432/otnj?user=otnj&sslmode=disable&password=otnj'
psql (12.8)
Type "help" for help.

otnj=> select * from stat;
 id | row  | col |   data
----+------+-----+----------
  1 | 1964 |   1 |   352832
  1 | 1965 |   1 |   366649
  1 | 1966 |   1 |   432937
省略
(58 rows)

otnj=>
```

### 補足情報（FW/ツールのバージョンなど）

sts-4.13.0.RELEASE

Spring BootでPostgreSQLに接続できない

### 実現したいこと
JavaでWebサイトのログイン画面を開発を学習中です。
CreateNativequeryのエラー回避のやり方を教えて頂けないでしょうか？
＜処理の内容＞
- ログイン画面に社員番号とパスワードを入力し、DBで社員番号の照合を行う。
- 社員番号でDBを検索し、登録があれば正常ケースとして、index.jspに遷移
- 社員番号がDBに登録がなければ、loginnerro.jspに遷移

（質問内容の詳細）
ログイン画面にデータ未登録の社員番号を入力し、エラー動作の確認を行ったところ、
「IllegalArgumentException」や「NoResultException」などのエラーが出ました。
CreateNativequeryメソッドを使用する場合、データがない場合や検索コードの誤りなど
エラーが起こる場合の対処方法を教えて頂けないでしょうか？
※サイト画面の入力チェックはバリデーションとして実装済です。

### 発生している問題・エラーメッセージ
タイプ 例外報告

メッセージ No entity found for query

説明 サーバーは予期しない条件に遭遇しました。それはリクエストの実行を妨げます。

例外

javax.persistence.NoResultException: No entity found for query
	org.hibernate.query.internal.AbstractProducedQuery.getSingleResult(AbstractProducedQuery.java:1643)
	controllers.LoginServlet.doPost(LoginServlet.java:78)

タイプ 例外報告

メッセージ No query defined for that name [select * from employees where code =:code]

説明 サーバーは予期しない条件に遭遇しました。それはリクエストの実行を妨げます。

例外

java.lang.IllegalArgumentException: No query defined for that name [select * from employees where code =:code]
### 該当のソースコード
package controllers;

import java.io.IOException;
import java.util.ArrayList;
import java.util.List;

import javax.persistence.EntityManager;
import javax.persistence.NoResultException;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import models.Employees;
import utils.DBUtil;

/**
 * Servlet implementation class LoginServlet
 */
@WebServlet("/login")
public class LoginServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;

	/**
	 * @see HttpServlet#HttpServlet()
	 */
	public LoginServlet() {
		super();
		// TODO Auto-generated constructor stub
	}

	/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		// TODO Auto-generated method stub
		RequestDispatcher rd = request.getRequestDispatcher("/WEB-INF/views/layout/login.jsp");
		rd.forward(request, response);

	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException, NoResultException{
		// TODO Auto-generated method stub

			System.out.println("LoginservletPost");

			EntityManager em = DBUtil.createEntityManager();

			String code = request.getParameter("emp_number");
			String password = request.getParameter("emp_pass");

			System.out.println("emp_number" + code);
			System.out.println("password" + password);

			List<String> errors = new ArrayList<String>();

			//社員番号のブランクチェック
			if (code == null || code.equals("")) {
				errors.add("社員番号を入力してください");
			}

			//パスワードのブランクチェック
			if (password == null || password.equals("")) {
				errors.add("パスワードを入力してください");
			}

			//入力内容にエラーがあるかどうか
			if (errors.size() > 0) {
				//エラーありログインエラー
				System.out.println("ログイン入力エラー");
				request.setAttribute("loginError", "true");
				request.setAttribute("errors", errors);
				RequestDispatcher rd = request.getRequestDispatcher("/WEB-INF/views/error/loginerrors.jsp");
				rd.forward(request, response);
			} else {
				//エラーなしログイン成功

				try {
					Employees employees = (Employees) em
							.createNativeQuery("select * from employees where code =:code",Employees.class)
							.setParameter("code", code)
							.getSingleResult();

					System.out.println("ログイン成功");
					request.setAttribute("employees", employees);
					RequestDispatcher rd = request.getRequestDispatcher("/WEB-INF/views/layout/index.jsp");
					rd.forward(request, response);
				} catch (ServletException e) {
					e.printStackTrace();
				} catch (NoResultException e) {
					System.out.println("ログイン社員番号未登録エラー");
					errors.add("社員番号が登録されていません");

					e.printStackTrace();
				}

			}

	}
}

### 言語
Java


CreateNativequeryのエラー回避のやり方について

### 現在の状況

ページネーションを実装しようとしていますが、次のような現象に頭を抱えています。

mysqlコンソールでは正常にクエリが実行されるのに
実際のアプリケーションではSQLGrammarExceptionが発生する。

以下コード：

```Java

	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		EntityManager em = DBUtil.createEntityManager();

		User login_user = (User)request.getSession().getAttribute("login_user");

		int page = 1;

		try {
			page = Integer.parseInt(request.getParameter("page"));
		} catch (NumberFormatException e) {}

		String getOrderItems = "SELECT * FROM items INNER JOIN cart ON items.id = cart.item_id AND cart.user_id = :user_id AND cart.cart_status = 2";
		List<Item> order_items = em.createNativeQuery(getOrderItems, Item.class)
									.setParameter("user_id", login_user.getId())
									.setFirstResult(5 * (page - 1))
									.setMaxResults(5)
									.getResultList();

		String countOrderItems = "SELECT COUNT(*) FROM items INNER JOIN cart ON items.id = cart.item_id AND cart.user_id = :user_id AND cart.cart_status = 2";
		long order_count = (long)em.createNativeQuery(countOrderItems, Item.class)
								.setParameter("user_id", login_user.getId())
								.getSingleResult();

		em.close();

		request.setAttribute("order_items", order_items);
		request.setAttribute("page", page);
		request.setAttribute("order_count", order_count);

		RequestDispatcher rd = request.getRequestDispatcher("/WEB-INF/views/users/history.jsp");
		rd.forward(request, response);
	}
}

```

```beans
@Table(name = "items")
@NamedQueries({
	@NamedQuery(
			name = "getAllItems",
			query = "SELECT i FROM Item AS i ORDER BY i.id ASC"
			),
	@NamedQuery(
			name = "getCategoryItems",
			query = "SELECT i FROM Item AS i WHERE i.category_id = :category_id ORDER BY i.id ASC"
			),
	@NamedQuery(
			name = "searchItems",
			query = "SELECT i FROM Item AS i WHERE i.name LIKE :query"
			)
})

@Entity
public class Item {
	@Id
	@Column(name = "id")
	private Integer id;

	@Column(name = "name", nullable = false)
	private String name;

	@Column(name = "price", nullable = false)
	private Integer price;

	@Column(name = "image_pass", nullable = false)
	private String image_pass;

	@Column(name = "show_image_pass", nullable = false)
	private String show_image_pass;

	@Column(name = "category_id", nullable = false)
	private Integer category_id;
```

```beans
@NamedQueries({
	@NamedQuery(
			name = "checkRegisterdEmail",
			query = "SELECT COUNT(u) FROM User AS u WHERE u.email = :email"
			),
	@NamedQuery(
			name = "checkLoginCode",
			query = "SELECT u FROM User AS u WHERE u.email = :email AND u.password = :password"
			)
})
@Table(name = "users")

@Entity
public class User {
	@Id
	@Column(name = "id")
	@GeneratedValue(strategy = GenerationType.IDENTITY)
	private Integer id;

	@Column(name = "name", length = 12, nullable = false)
	private String name;

	@Column(name = "address", nullable = false)
	private String address;

	@Column(name = "email", nullable = false, unique = true)
	private String email;

	@Column(name = "password", nullable = false)
	private String password;
}
```

発生しているエラー :

HTTPステータス 500 - org.hibernate.exception.SQLGrammarException: could not execute query
type 例外レポート

メッセージ org.hibernate.exception.SQLGrammarException: could not execute query



例外

javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query
	org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:149)
	org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:157)
	org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1423)
	org.hibernate.query.internal.AbstractProducedQuery.getSingleResult(AbstractProducedQuery.java:1463)
	controllers.users.UsersHistoryServlet.doGet(UsersHistoryServlet.java:57)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	filters.EncodingFilter.doFilter(EncodingFilter.java:43)
原因

org.hibernate.exception.SQLGrammarException: could not execute query
	org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:106)
	org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
	org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)
	org.hibernate.loader.Loader.doList(Loader.java:2695)
	org.hibernate.loader.Loader.doList(Loader.java:2675)
	org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2507)
	org.hibernate.loader.Loader.list(Loader.java:2502)
	org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:335)
	org.hibernate.internal.SessionImpl.listCustomQuery(SessionImpl.java:2162)
	org.hibernate.internal.AbstractSharedSessionContract.list(AbstractSharedSessionContract.java:1016)
	org.hibernate.query.internal.NativeQueryImpl.doList(NativeQueryImpl.java:152)
	org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1414)
	org.hibernate.query.internal.AbstractProducedQuery.getSingleResult(AbstractProducedQuery.java:1463)
	controllers.users.UsersHistoryServlet.doGet(UsersHistoryServlet.java:57)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	filters.EncodingFilter.doFilter(EncodingFilter.java:43)
原因

java.sql.SQLException: Column 'id' not found.
	com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
	com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898)
	com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887)
	com.mysql.jdbc.SQLError.createSQLException(SQLError.java:861)
	com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1080)
	com.mysql.jdbc.ResultSetImpl.getInt(ResultSetImpl.java:2570)
	org.hibernate.type.descriptor.sql.IntegerTypeDescriptor$2.doExtract(IntegerTypeDescriptor.java:62)
	org.hibernate.type.descriptor.sql.BasicExtractor.extract(BasicExtractor.java:47)
	org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:261)
	org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:257)
	org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:247)
	org.hibernate.type.AbstractStandardBasicType.hydrate(AbstractStandardBasicType.java:333)
	org.hibernate.loader.Loader.extractKeysFromResultSet(Loader.java:794)
	org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:719)
	org.hibernate.loader.Loader.processResultSet(Loader.java:991)
	org.hibernate.loader.Loader.doQuery(Loader.java:949)
	org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:341)
	org.hibernate.loader.Loader.doList(Loader.java:2692)
	org.hibernate.loader.Loader.doList(Loader.java:2675)
	org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2507)
	org.hibernate.loader.Loader.list(Loader.java:2502)
	org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:335)
	org.hibernate.internal.SessionImpl.listCustomQuery(SessionImpl.java:2162)
	org.hibernate.internal.AbstractSharedSessionContract.list(AbstractSharedSessionContract.java:1016)
	org.hibernate.query.internal.NativeQueryImpl.doList(NativeQueryImpl.java:152)
	org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1414)
	org.hibernate.query.internal.AbstractProducedQuery.getSingleResult(AbstractProducedQuery.java:1463)
	controllers.users.UsersHistoryServlet.doGet(UsersHistoryServlet.java:57)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	filters.EncodingFilter.doFilter(EncodingFilter.java:43)

宜しくお願い致します。

追記：　テーブルの定義

itemsテーブル
+-----------------+--------------+------+-----+---------+----------------+
| Field           | Type         | Null | Key | Default | Extra          |
+-----------------+--------------+------+-----+---------+----------------+
| id              | int(11)      | NO   | PRI | NULL    | auto_increment |
| name            | varchar(100) | NO   |     | NULL    |                |
| price           | int(11)      | NO   |     | NULL    |                |
| image_pass      | varchar(100) | NO   |     | NULL    |                |
| show_image_pass | varchar(100) | NO   |     | NULL    |                |
| category_id     | int(11)      | NO   |     | NULL    |                |
+-----------------+--------------+------+-----+---------+----------------+

cartテーブル
+-------------+----------+------+-----+---------+----------------+
| Field       | Type     | Null | Key | Default | Extra          |
+-------------+----------+------+-----+---------+----------------+
| id          | int(11)  | NO   | PRI | NULL    | auto_increment |
| cart_status | int(11)  | NO   |     | 0       |                |
| item_id     | int(11)  | NO   |     | NULL    |                |
| order_at    | datetime | YES  |     | NULL    |                |
| order_num   | int(11)  | YES  |     | NULL    |                |
| user_id     | int(11)  | NO   |     | NULL    |                |
+-------------+----------+------+-----+---------+----------------+

SQLGrammarExceptionを解決したい

こんばんは。
Spring Bootを起動したところ、以下のエラーが発生しました。
###エラー内容
エラー内容を見ると「user」というテーブルが見つからない旨の内容が記載されていますが、実際作成したいテーブルは「usr」です。
↓20170123追記
DBを確認したところ、テーブルは全て作成されていました。

###コンソールログ
```
Error starting ApplicationContext. To display the auto-configuration report re-run your application with 'debug' enabled.
2018-01-22 22:59:54.830 ERROR 7408 --- [           main] o.s.boot.SpringApplication               : Application startup failed

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaAutoConfiguration.class]: Invocation of init method failed; nested exception is javax.persistence.PersistenceException: [PersistenceUnit: default] Unable to build Hibernate SessionFactory
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1628) ~[spring-beans-4.3.13.RELEASE.jar:4.3.13.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:555) ~[spring-beans-4.3.13.RELEASE.jar:4.3.13.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483) ~[spring-beans-4.3.13.RELEASE.jar:4.3.13.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306) ~[spring-beans-4.3.13.RELEASE.jar:4.3.13.RELEASE]
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) ~[spring-beans-4.3.13.RELEASE.jar:4.3.13.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302) ~[spring-beans-4.3.13.RELEASE.jar:4.3.13.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) ~[spring-beans-4.3.13.RELEASE.jar:4.3.13.RELEASE]
	at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1080) ~[spring-context-4.3.13.RELEASE.jar:4.3.13.RELEASE]
	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:857) ~[spring-context-4.3.13.RELEASE.jar:4.3.13.RELEASE]
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:543) ~[spring-context-4.3.13.RELEASE.jar:4.3.13.RELEASE]
	at org.springframework.boot.context.embedded.EmbeddedWebApplicationContext.refresh(EmbeddedWebApplicationContext.java:122) ~[spring-boot-1.5.9.RELEASE.jar:1.5.9.RELEASE]
	at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:693) [spring-boot-1.5.9.RELEASE.jar:1.5.9.RELEASE]
	at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:360) [spring-boot-1.5.9.RELEASE.jar:1.5.9.RELEASE]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:303) [spring-boot-1.5.9.RELEASE.jar:1.5.9.RELEASE]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1118) [spring-boot-1.5.9.RELEASE.jar:1.5.9.RELEASE]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1107) [spring-boot-1.5.9.RELEASE.jar:1.5.9.RELEASE]
	at mrs.MrsApplication.main(MrsApplication.java:10) [classes/:na]
Caused by: javax.persistence.PersistenceException: [PersistenceUnit: default] Unable to build Hibernate SessionFactory
	at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.persistenceException(EntityManagerFactoryBuilderImpl.java:954) ~[hibernate-entitymanager-5.0.12.Final.jar:5.0.12.Final]
	at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:882) ~[hibernate-entitymanager-5.0.12.Final.jar:5.0.12.Final]
	at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:60) ~[spring-orm-4.3.13.RELEASE.jar:4.3.13.RELEASE]
	at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:360) ~[spring-orm-4.3.13.RELEASE.jar:4.3.13.RELEASE]
	at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:382) ~[spring-orm-4.3.13.RELEASE.jar:4.3.13.RELEASE]
	at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:371) ~[spring-orm-4.3.13.RELEASE.jar:4.3.13.RELEASE]
	at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.afterPropertiesSet(LocalContainerEntityManagerFactoryBean.java:336) ~[spring-orm-4.3.13.RELEASE.jar:4.3.13.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1687) ~[spring-beans-4.3.13.RELEASE.jar:4.3.13.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1624) ~[spring-beans-4.3.13.RELEASE.jar:4.3.13.RELEASE]
	... 16 common frames omitted
Caused by: org.hibernate.tool.schema.spi.SchemaManagementException: Schema-validation: missing table [user]
	at org.hibernate.tool.schema.internal.SchemaValidatorImpl.validateTable(SchemaValidatorImpl.java:67) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
	at org.hibernate.tool.schema.internal.SchemaValidatorImpl.doValidation(SchemaValidatorImpl.java:50) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
	at org.hibernate.tool.hbm2ddl.SchemaValidator.validate(SchemaValidator.java:91) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
	at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:475) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
	at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:444) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
	at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:879) ~[hibernate-entitymanager-5.0.12.Final.jar:5.0.12.Final]
	... 23 common frames omitted
```
###Entity
```
package mrs.domain.model;

import java.io.Serializable;

import javax.persistence.Entity;
import javax.persistence.EnumType;
import javax.persistence.Enumerated;
import javax.persistence.Id;
import javax.persistence.Table;

@Entity
@Table(name = "usr")
public class User implements Serializable {
	@Id
	private String userId;

	private String password;

	private String firstName;

	private String lastName;

	@Enumerated(EnumType.STRING)
	private RoleName roleName;
・・・Getter
・・・Setter
}
```
###shema.sql
```
DROP TABLE IF EXISTS meeting_room CASCADE;
DROP TABLE IF EXISTS reservable_room CASCADE;
DROP TABLE IF EXISTS reservation CASCADE;
DROP TABLE IF EXISTS usr CASCADE;

CREATE TABLE IF NOT EXISTS meeting_room (
	room_id SERIAL NOT NULL,
	room_name      VARCHAR(255) NOT NULL,
	PRIMARY KEY (room_id)
);
CREATE TABLE IF NOT EXISTS reservable_room (
	reserved_date DATE NOT NULL,
	room_id       INT4 NOT NULL,
	PRIMARY KEY (reserved_date, room_id)
);
CREATE TABLE IF NOT EXISTS reservation (
	reservation_id SERIAL NOT NULL,
	end_time       TIME   NOT NULL,
	start_time     TIME   NOT NULL,
	reserved_date  DATE   NOT NULL,
	room_id        INT4   NOT NULL,
	user_id        VARCHAR(255) NOT NULL,
	PRIMARY KEY (reservation_id)
);
CREATE TABLE IF NOT EXISTS usr (
	user_id     VARCHAR(255) NOT NULL,
	first_time  VARCHAR(255) NOT NULL,
	last_time   VARCHAR(255) NOT NULL,
	password    VARCHAR(255) NOT NULL,
	role_name   VARCHAR(255) NOT NULL,
	PRIMARY KEY (user_id)
);
ALTER TABLE reservable_room DROP CONSTRAINT IF EXISTS FK_f4wnz2qj0d59s9tl1q5800fw7;
ALTER TABLE reservation DROP CONSTRAINT IF EXISTS FK_p1k4iriqd4eo1cpnv79ubni9g;
ALTER TABLE reservation DROP CONSTRAINT IF EXISTS FK_recqnfjcp370rygd9hjjxjtg;
ALTER TABLE reservable_room ADD CONSTRAINT FK_f4wnz2qj0d59s9tl1q5800fw7 FOREIGN KEY(room_id) REFERENCES meeting_room;
ALTER TABLE reservation ADD CONSTRAINT FK_p1k4iriqd4eo1cpnv79uvni9g FOREIGN KEY (reserved_date, room_id) REFERENCES reservable_room;
ALTER TABLE reservation ADD CONSTRAINT FK_recqnfjcp370rygd9hjjxjtg FOREIGN KEY (user_id) REFERENCES usr;
```
###ER図
![![イメージ説明](1dc21001e961e7c3b23c520388b58905.png)](34f1bb72b278faeb90b874fc701999b5.png)

Spring Bootで起動できない2

### Oracle DBでINSERT時のエラー

SELECT、UPDATEは可能でINSERT時に
could not extract ResultSetは発生します。

org.hibernate.Sessionのsave()内で発生していることは
わかったのですが、解決方法が見つからない状況です。

スタックトレース内に
Caused by: java.sql.SQLSyntaxErrorException: ORA-02289: 順序が存在しません。
と出力されていて、
直前で発行されている
SELECT XXXXX.NEXTVAL FROM DUAL
をSQL Developerで直接確認するとあるので、
ORA-02289は直接関係していないのではないかと思っています。

---
Java8, Hibernate5, Spring5, Tomcat8

追記
各バージョンをまとめて上げたことによって発生しています。
ソースコードはバージョンを上げる前(動いていた時)から変更はしていません。
Hibernate3 → 5, Spring3 → 5, Tomcat7 → 8

ご教授頂けると幸いです。

org.hibernate.exception.SQLGrammarException: could not extract ResultSetの解決方法

お世話になります。


spring-boot 1.4
spring-data-jpa 1.10
を使用しています。


バッチ処理の速度改善に取り組んでいますが、100件ほど入れるinsertがbulk insertではないことに気づきました。
（この100件ほどのinsertはバッチ内で何度も実行されます。）
bulk insertに変更したいと思い、以下のページを読みましたが、
https://docs.spring.io/spring-boot/docs/current/reference/html/howto.html#howto-data-access
https://stackoverflow.com/questions/34228044/how-to-enable-batch-inserts-with-hibernate-and-spring-boot
https://www.baeldung.com/spring-data-jpa-batch-inserts
どれもentity managerを使うような仕組みでした。


そのように実装してもよいのですが、どちらかといえば、
saveメソッド(JpaRepository)
```Java
	<S extends T> List<S> save(Iterable<S> entities);
```
の動きをbulk insertに変更できないかと考えています。


お知恵を貸していただきたいです。
よろしくお願いします。

---情報を追加しました。---
DB : PostgreSQL 9.5
エンティティクラスの主キー部分のソースコード

```Java
    @Id
    @SequenceGenerator( name            = "hoge",
                        sequenceName    = "piyo",
                        allocationSize  = 1 )
    @GeneratedValue(strategy    = GenerationType.SEQUENCE,
                    generator   = "hoge" )
    @Column
    private Long fooBarId;

```

spring-data-jpaでbulk insertするにはentity manager を使うしかないのでしょうか。

### 発生している問題・エラーメッセージ

```
HTTPステータス 500 - org.hibernate.exception.SQLGrammarException: could not extract ResultSet

メッセージ org.hibernate.exception.SQLGrammarException: could not extract ResultSet

説明 The server encountered an internal error that prevented it from fulfilling this request.

例外

javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
	org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:149)
	org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:157)
	org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1423)
	org.hibernate.query.Query.getResultList(Query.java:146)
	controllers.dispatch.DispatchIndexServlet.doGet(DispatchIndexServlet.java:45)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	filters.LoginFilter.doFilter(LoginFilter.java:72)
	filters.EncodingFilter.doFilter(EncodingFilter.java:38)
原因

org.hibernate.exception.SQLGrammarException: could not extract ResultSet
	org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63)
	org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
	org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)
	org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)
	org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:69)
	org.hibernate.loader.Loader.getResultSet(Loader.java:2168)
	org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1931)
	org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1893)
	org.hibernate.loader.Loader.doQuery(Loader.java:938)
	org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:341)
	org.hibernate.loader.Loader.doList(Loader.java:2692)
	org.hibernate.loader.Loader.doList(Loader.java:2675)
	org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2507)
	org.hibernate.loader.Loader.list(Loader.java:2502)
	org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:502)
	org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:392)
	org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:216)
	org.hibernate.internal.SessionImpl.list(SessionImpl.java:1490)
	org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1445)
	org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1414)
	org.hibernate.query.Query.getResultList(Query.java:146)
	controllers.dispatch.DispatchIndexServlet.doGet(DispatchIndexServlet.java:45)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	filters.LoginFilter.doFilter(LoginFilter.java:72)
	filters.EncodingFilter.doFilter(EncodingFilter.java:38)
原因

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'dispatch0_.stack_area' in 'field list'
	sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
	com.mysql.jdbc.Util.getInstance(Util.java:408)
	com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
	com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
	com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
	com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
	com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
	com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
	com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
	com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1966)
	org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:60)
	org.hibernate.loader.Loader.getResultSet(Loader.java:2168)
	org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1931)
	org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1893)
	org.hibernate.loader.Loader.doQuery(Loader.java:938)
	org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:341)
	org.hibernate.loader.Loader.doList(Loader.java:2692)
	org.hibernate.loader.Loader.doList(Loader.java:2675)
	org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2507)
	org.hibernate.loader.Loader.list(Loader.java:2502)
	org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:502)
	org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:392)
	org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:216)
	org.hibernate.internal.SessionImpl.list(SessionImpl.java:1490)
	org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1445)
	org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1414)
	org.hibernate.query.Query.getResultList(Query.java:146)
	controllers.dispatch.DispatchIndexServlet.doGet(DispatchIndexServlet.java:45)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	filters.LoginFilter.doFilter(LoginFilter.java:72)
	filters.EncodingFilter.doFilter(EncodingFilter.java:38)
```

### 該当のソースコード

```Java
package models;

import java.sql.Date;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.Table;

@Table(name = "trucks")
@NamedQueries({
    @NamedQuery(
        name = "getAllDispatch",
        query = "SELECT d FROM Dispatch AS d ORDER BY d.id DESC"
    ),
    @NamedQuery(
        name = "getDispatchCount",
        query = "SELECT COUNT(d) FROM Dispatch AS d"
    ),
})
@Entity
public class Dispatch{
    @Id
    @Column(name = "id")
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Integer id;

    @Column(name = "task_date", nullable = false)
    private Date task_date;

    @Column(name = "task_type", nullable = false)
    private String task_type;

    @Column(name = "office_name", nullable = false)
    private String office_name;

    @Column(name = "truck_code", nullable = false)
    private String truck_code;

    @Column(name = "stack_area", nullable = false)
    private String stack_area;

    @Column(name = "wholesale_area", nullable = false)
    private String wholesale_area;

    @Column(name = "truck_type", nullable = false)
    private String truck_type;


    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public Date getTask_date() {
        return task_date;
    }

    public void setTask_date(Date task_date) {
        this.task_date = task_date;
    }

    public String getOffice_name() {
        return office_name;
    }

    public void setOffice_name(String office_name) {
        this.office_name = office_name;
    }


    public void setTask_type(String task_type){
    	this.task_type = task_type;
    }


    public String getTruck_code() {
        return truck_code;
    }

    public void setTruck_code(String truck_code) {
        this.truck_code = truck_code;
    }

    public String getStack_area() {
        return stack_area;
    }

    public void setStack_area(String stack_area) {
        this.stack_area = stack_area;
    }

    public String getWholesale_area() {
        return wholesale_area;
    }

    public void setWholesale_area(String wholesale_area) {
        this.wholesale_area = wholesale_area;
    }

    public String getTruck_type() {
        return truck_type;
    }

    public void setTruck_type(String truck_type) {
        this.truck_type = truck_type;
    }
}
```

### 試したこと

該当ソースコードのnullableをtrueからfalseに変更した。
カラム名が間違っているとのことなので
全てのソースコードを見てみたが
'dispatch0_.stack_area' と書いている所は無かった
### 補足情報（FW/ツールのバージョンなど）

HTTPステータス 500 - org.hibernate.exception.SQLGrammarException: could not extract ResultSet のエラーを解決したい。

### 実現したいこと

- [ ] ・JPAでテーブルからデータを取得したい

### 前提
Spring bootとVue.jsを使ってWEBアプリをつくっているのですが、
以下のcountByPrefectureCdメソッドではテーブルからデータを取得出来るのですが、
findByPrefectureCdメソッドではテーブルからのデータの取得に失敗します。
```Java
@Repository
public interface BoothRepository extends JpaRepository<Booth, String> {
  int countByPrefectureCd(String prefectureCd);
  List<Booth> findByPrefectureCd(String prefectureCd);
}
```

JPAのメソッドでデータの取得を試みるとjava.io.StreamCorruptedException: invalid stream header: 32303233（ASCIIコードで2023）というエラーが発生します。
恐縮ですが正常にデータを取得する方法のご教示をお願いいたします。

### 発生している問題・エラーメッセージ

```
2023-03-23 12:21:06.210[0;39m [32mDEBUG[0;39m [35m1900[0;39m [2m---[0;39m [2m[nio-8080-exec-8][0;39m [36morg.hibernate.SQL                       [0;39m [2m:[0;39m 
    select
        booth0_.booth_id as booth_id1_0_,
        booth0_.address as address2_0_,
        booth0_.booth_category_cd as booth_ca3_0_,
        booth0_.booth_name as booth_na4_0_,
        booth0_.chome_cd as chome_cd5_0_,
        booth0_.city_cd as city_cd6_0_,
        booth0_.del_flg as del_flg7_0_,
        booth0_.prefecture_cd as prefectu8_0_,
        booth0_.reg_dt as reg_dt9_0_,
        booth0_.reg_process as reg_pro10_0_,
        booth0_.reg_user_id as reg_use11_0_,
        booth0_.role_id as role_id12_0_,
        booth0_.town_area_cd as town_ar13_0_,
        booth0_.upd_dt as upd_dt14_0_,
        booth0_.upd_process as upd_pro15_0_,
        booth0_.upd_user_id as upd_use16_0_,
        booth0_.version as version17_0_ 
    from
        booth booth0_ 
    where
        booth0_.prefecture_cd=?
[2m2023-03-23 12:21:06.211[0;39m [32mTRACE[0;39m [35m1900[0;39m [2m---[0;39m [2m[nio-8080-exec-8][0;39m [36mo.h.type.descriptor.sql.BasicBinder     [0;39m [2m:[0;39m binding parameter [1] as [VARCHAR] - [01]
[2m2023-03-23 12:21:06.235[0;39m [32m INFO[0;39m [35m1900[0;39m [2m---[0;39m [2m[nio-8080-exec-8][0;39m [36mcom.koikeya.rotten.app.LogAspect        [0;39m [2m:[0;39m End:public abstract java.util.List com.koikeya.rotten.domain.repository.BoothRepository.findByPrefectureCd(java.lang.String)
[2m2023-03-23 12:21:06.235[0;39m [32m INFO[0;39m [35m1900[0;39m [2m---[0;39m [2m[nio-8080-exec-8][0;39m [36mcom.koikeya.rotten.app.LogAspect        [0;39m [2m:[0;39m End:public java.util.List com.koikeya.rotten.domain.service.impl.FetchListInfoServiceImpl.fetchListInfo(java.lang.String)
[2m2023-03-23 12:21:06.236[0;39m [32m INFO[0;39m [35m1900[0;39m [2m---[0;39m [2m[nio-8080-exec-8][0;39m [36mcom.koikeya.rotten.app.LogAspect        [0;39m [2m:[0;39m End:public java.lang.String com.koikeya.rotten.app.DisplayListController.displayList(java.lang.String,org.springframework.ui.Model)
[2m2023-03-23 12:21:06.244[0;39m [31mERROR[0;39m [35m1900[0;39m [2m---[0;39m [2m[nio-8080-exec-8][0;39m [36mo.a.c.c.C.[.[.[/].[dispatcherServlet]   [0;39m [2m:[0;39m Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.orm.jpa.JpaSystemException: could not deserialize; nested exception is org.hibernate.type.SerializationException: could not deserialize] with root cause

java.io.StreamCorruptedException: invalid stream header: 32303233
	at java.base/java.io.ObjectInputStream.readStreamHeader(ObjectInputStream.java:943)
	at java.base/java.io.ObjectInputStream.<init>(ObjectInputStream.java:381)
	at org.hibernate.internal.util.SerializationHelper$CustomObjectInputStream.<init>(SerializationHelper.java:309)
	at org.hibernate.internal.util.SerializationHelper$CustomObjectInputStream.<init>(SerializationHelper.java:299)
```

### 該当のソースコード
```html
<template>
  <p v-if="flag" class="ok">
    {{ message }}
  </p>
  <div class="eight-regional-divisions">
    <h2>北海道</h2>
    <div class="Hokkaido">
      <a href="/DisplayListController?prefectureCd=01">北海道</a>
      {{ hokkaiDo }}件
    </div>
```
```Java
@Controller
@RequestMapping("/DisplayListController")
public class DisplayListController {
    /**
     * 店舗リポジトリ
     */
    @Autowired
    FetchListInfoService fetchListInfoService;

    /**
     * 一覧画面を表示する。
     * @return 一覧画面名
     */
    @RequestMapping
    public String displayList(@RequestParam(name = "prefectureCd") String prefectureCd, Model model) {
        List<Booth> boothList = fetchListInfoService.fetchListInfo(prefectureCd);
        model.addAttribute("boothList", fetchListInfoService.fetchListInfo(prefectureCd));
        return UINameEnum.LIST.getUIName();
    }
}

```

```Java
@Service
public class FetchListInfoServiceImpl implements FetchListInfoService {
    /**
     * 店舗
     */
    @Autowired
    Booth booth;
    /**
     * 店舗リポジトリ
     */
    @Autowired
    BoothRepository boothRepository;

    @Override
    public List<Booth> fetchListInfo(String prefectureCd) {
        List<Booth> boothList = boothRepository.findByPrefectureCd(prefectureCd);
        return boothList;
    }
}
```

```Java
@Repository
public interface BoothRepository extends JpaRepository<Booth, String> {
    /**
     *　都道府県別の店舗数を取得する。
     * @param prefectureCd 都道府県コード
     * @return 店舗エンティティクラスリスト
     */
    int countByPrefectureCd(String prefectureCd);
    /**
     *　都道府県別の店舗数を取得する。
     * @param prefectureCd 都道府県コード
     * @return 店舗エンティティクラスリスト
     */
    List<Booth> findByPrefectureCd(String prefectureCd);
}

```

```Java
@Data
@Component
@Entity
@Table(name = "booth")
public class Booth implements Serializable {
    /**
     * シリアルバージョンUID
     */
    private static final long serialVersionUID = 123456789L;
    /**
     * 都道府県コード
     */
    @NotBlank
    @Length(max=2)
    private String prefectureCd;
```

```SQL
-- 店
--* RestoreFromTempTable
create table booth (
  prefecture_cd char(2) comment '都道府県コード'
```


```pom.xml
    </dependency>




    <dependency>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-thymeleaf</artifactId>
    </dependency>
    <dependency>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-web</artifactId>
    </dependency>

    <dependency>
      <groupId>org.projectlombok</groupId>
      <artifactId>lombok</artifactId>
      <optional>true</optional>
    </dependency>
    <dependency>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-tomcat</artifactId>
      <scope>provided</scope>
    </dependency>
    <dependency>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-test</artifactId>
      <scope>test</scope>
    </dependency>
    <dependency>
      <groupId>org.springframework.security</groupId>
      <artifactId>spring-security-test</artifactId>
      <scope>test</scope>
    </dependency>
    
    <dependency>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-data-jpa</artifactId>
    </dependency>
    
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
    </dependency>
    
    <dependency>
      <groupId>org.webjars.npm</groupId>
      <artifactId>vue</artifactId>
      <version>3.2.33</version>
    </dependency>
    
    <dependency>
      <groupId>joda-time</groupId>
      <artifactId>joda-time</artifactId>
      <version>2.10.14</version>
    </dependency>
    
    <dependency>
      <groupId>org.hibernate</groupId>
      <artifactId>hibernate-validator</artifactId>
      <version>6.0.17.Final</version>
    </dependency>
    
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-aop</artifactId>
    </dependency>
    
    <dependency>
        <groupId>org.aspectj</groupId>
        <artifactId>aspectjweaver</artifactId>
    </dependency>
    
    <dependency>
      <groupId>org.webjars</groupId>
      <artifactId>bootstrap</artifactId>
      <version>4.5.2</version>
    </dependency>

  </dependencies>
```


### 補足情報（FW/ツールのバージョンなど）
・Windows 11 Pro
・MySQL 8.0.29
・Eclipse 2021-09 (4.21.0)
・Java 16