일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | 5 | 6 | 7 |
8 | 9 | 10 | 11 | 12 | 13 | 14 |
15 | 16 | 17 | 18 | 19 | 20 | 21 |
22 | 23 | 24 | 25 | 26 | 27 | 28 |
29 | 30 |
- xPlatform
- es6
- hadoop
- GIT
- Android
- IntelliJ
- Sqoop
- Eclipse
- mybatis
- NPM
- Python
- Kotlin
- tomcat
- Express
- JavaScript
- Java
- MSSQL
- mapreduce
- 보조정렬
- 공정능력
- vaadin
- SPC
- Spring
- table
- react
- SQL
- R
- plugin
- window
- SSL
- Today
- Total
DBILITY
spring data jpa study code 본문
이거 보고 광고 한번 안 누른 이는 삼대가 재수 없을지어다!ㅋㅋ
누르고 복권을 사라!
jdbc와 iBatis,myBatis만 사용해 왔다. JPA는 극히 추상적으로만 알고 지냈다. 이번에 기본 테스트를 해봤다.
JPA ( Java Persistance API )
ORM 표준으로 ORM(Object-Relational Mapping:객체관계매핑)은 객체설계와 데이터베이스설계를 따로 하고 ORM프레임워크가 연결해 준다. JPA는 Java의 ORM 표준 인터페이스로 실제구현체는 대표적으로 Hibernate가 있다.
Spring Data JPA는 Spring에서 JPA를 쉽게 사용할 수 있도록 만든 Spring Data의 프로젝트 중 하나다.
다음은 Spring Initializr로 생성한 pom으로 spring boot 2.6.3이다.
<?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.3</version>
<relativePath/> <!-- lookup parent from repository -->
</parent>
<groupId>com.dbility.apps.dev.test</groupId>
<artifactId>devapi</artifactId>
<version>0.0.1-SNAPSHOT</version>
<name>devapi</name>
<description>devapi</description>
<properties>
<java.version>1.8</java.version>
</properties>
<repositories>
<repository>
<id>spring-repo</id>
<name>Spring Repository</name>
<url>https://repo.spring.io/release</url>
</repository>
</repositories>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-devtools</artifactId>
<scope>runtime</scope>
<optional>true</optional>
</dependency>
<dependency>
<groupId>com.h2database</groupId>
<artifactId>h2</artifactId>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<optional>true</optional>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<scope>test</scope>
</dependency>
<dependency>
<groupId>com.dbility.apps.dev.test</groupId>
<artifactId>devapi</artifactId>
<version>0.0.1-SNAPSHOT</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>commons-fileupload</groupId>
<artifactId>commons-fileupload</artifactId>
<version>1.2.2</version>
</dependency>
<dependency>
<groupId>commons-io</groupId>
<artifactId>commons-io</artifactId>
<version>2.4</version>
</dependency>
<dependency>
<groupId>org.modelmapper</groupId>
<artifactId>modelmapper</artifactId>
<version>2.4.0</version>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
<configuration>
<excludes>
<exclude>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
</exclude>
</excludes>
</configuration>
</plugin>
</plugins>
</build>
</project>
다음은 Spring Boot로 생성한 Spring Data JPA 프로젝트의 application.properties 내용이다.
server.port=9090
spring.datasource.url=jdbc:h2:mem:testdb:DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE;MODE=MySQL
spring.datasource.driver-class-name=org.h2.Driver
spring.datasource.username=sa
spring.datasource.password=password
spring.sql.init.mode=always
spring.sql.init.schema-locations=classpath*:schema.sql
spring.sql.init.data-locations=classpath*:data.sql
spring.h2.console.enabled=true
spring.h2.console.path=/h2-console
spring.jpa.open-in-view=false
logging.level.org.hibernate=debug
logging.level.org.hibernate.type.descriptor.sql=trace
spring.jpa.show-sql=true
#spring.jpa.hibernate.hbm2ddl.auto=create
spring.jpa.properties.hibernate.format_sql=true
spring.jpa.properties.hibernate.show_sql=true
spring.jpa.properties.hibernate.jdbc.lob.non_contextual_creation=true
spring.jpa.defer-datasource-initialization=true
logging.level.com.dbility.apps.dev = debug
logging.pattern.console=%d{HH:mm:ss.SSS} [%thread] %-5level %40.40logger{36} %4.4L - %msg%n%ex{full, DISPLAY_EX_EVAL}
spring.devtools.livereload.enabled=true
- server.port는 embedded was(tomcat)의 사용포트다.
- spring.datasource로 시작하는 것은 h2db in memory설정 등이다.
- sping.sql로 시작하는 부분은 시작시 table생성 및 sql data입력에 관한 것으로
spring.jpa.defer-datasource-initialization=true여야 정상적으로 동작한다.
다음은 schema.sql과 data.sql의 내용이다.
DROP TABLE IF EXISTS ROOMS;
CREATE TABLE IF NOT EXISTS ROOMS (
id INT NOT NULL AUTO_INCREMENT,
title VARCHAR (100) NOT NULL,
content VARCHAR(2000),
price BIGINT NOT NULL DEFAULT 0,
inform_count INT NOT NULL DEFAULT 0,
file_name VARCHAR(250),
file_type VARCHAR(20),
PRIMARY KEY(id)
);
INSERT INTO ROOMS(id,title, content, price, inform_count, file_name,file_type)
VALUES (1,'해운대LCT', '가운데 라인 로얄층으로 위아래 ☀️, 자연 공기청정', 3000000000, 0, 'images/room0.jpg','image/jpeg');
INSERT INTO ROOMS(id,title, content, price, inform_count, file_name,file_type)
VALUES (2,'대장동 헐값분양아파트', '아파트는 싸게 받았는데, 곽XX때문에 퇴직금 50억이 날아가나?!', 1500000000, 0, 'images/room1.jpg','image/jpeg');
INSERT INTO ROOMS(id,title, content, price, inform_count, file_name,file_type)
VALUES (3,'내곡동 오노키오랜드', '내곡동1334평. 기억에 겸손한 분만! 애완동물 불가능 🐶', 3400000000, 0, 'images/room2.jpg','image/jpeg');
다음은 Entity class로 Annotation에 관한 것은 구글검색으로 학습하자.
package com.dbility.apps.dev.test;
import lombok.Data;
import lombok.NoArgsConstructor;
import lombok.NonNull;
import org.hibernate.annotations.ColumnDefault;
import javax.persistence.*;
@Entity
@NoArgsConstructor
@Data
@Table(name = "ROOMS")
public class RoomsEntity {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Column(name = "id", columnDefinition = "INT")
private int id;
@NonNull
@Column(name = "title", columnDefinition = "VARCHAR(100)")
private String title;
@Column(name = "content",columnDefinition = "VARCHAR(2000)")
private String content;
@NonNull
@ColumnDefault("0")
@Column(name = "price",columnDefinition = "BIGINT")
private long price;
@NonNull
@ColumnDefault("0")
@Column(name = "inform_count",columnDefinition = "INT")
private int inform_count;
@Column(name = "file_name", columnDefinition = "VARCHAR(250)")
private String file_name;
@Column(name="file_type", columnDefinition = "VARCHAR(20)")
private String file_type;
}
다음은 JpaRepository class다.
package com.dbility.apps.dev.test;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.stereotype.Repository;
import java.util.List;
@Repository("roomsRepository")
public interface RoomsRepository extends JpaRepository<RoomsEntity, Long> {
List<RoomsEntity> findAll();
}
Repository interface에 관한 것은 다음을 참고하자.
https://docs.spring.io/spring-data/jpa/docs/current/reference/html/#repositories.core-concepts
Spring Data JPA - Reference Documentation
Example 109. Using @Transactional at query methods @Transactional(readOnly = true) interface UserRepository extends JpaRepository { List findByLastname(String lastname); @Modifying @Transactional @Query("delete from User u where u.active = false") void del
docs.spring.io
다음은 DTO, service 인터페이스와 구현체다. Entity와 DTO 전환은 modelmapper를 활용했다.
package com.dbility.apps.dev.test;
import lombok.AllArgsConstructor;
import lombok.Builder;
import lombok.Data;
import lombok.NoArgsConstructor;
@Builder
@AllArgsConstructor
@NoArgsConstructor
@Data
public class RoomDTO {
private String title;
private String content;
private String price;
private String inform_count;
private String file_name;
private String file_type;
}
package com.dbility.apps.dev.test;
import java.util.List;
public interface RoomsService {
List<RoomDTO> findAll() throws Exception;
}
package com.dbility.apps.dev.test;
import lombok.extern.slf4j.Slf4j;
import org.modelmapper.ModelMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;
import org.springframework.stereotype.Service;
import javax.annotation.Resource;
import java.time.LocalDateTime;
import java.util.List;
import java.util.stream.Collectors;
@Slf4j
@Service("roomsService")
public class RoomsServiceImpl implements RoomsService {
@Resource(name = "roomsRepository")
private RoomsRepository roomsRepository;
@Autowired
private ModelMapper modelMapper;
@Override
public List<RoomDTO> findAll() throws Exception {
log.info("{}", LocalDateTime.now());
List<RoomsEntity> roomList = roomsRepository.findAll();
List<RoomDTO> roomDtoList = roomList.stream().map(room->modelMapper.map(room,RoomDTO.class)).collect(Collectors.toList());
return roomDtoList;
}
}
다음은 RestController다.
package com.dbility.apps.dev.test;
import lombok.extern.slf4j.Slf4j;
import org.springframework.web.bind.annotation.CrossOrigin;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RestController;
import javax.annotation.Resource;
import java.util.List;
@Slf4j
@RestController
public class RoomsController {
@Resource(name="roomsService")
private RoomsService roomsService;
@CrossOrigin(origins = "http://localhost:3000")
@GetMapping(value = "/findall")
public List<RoomDTO> getRooms() throws Exception {
return roomsService.findAll();
}
}
다음은 AppConfig class다.
package com.dbility.apps.dev.test;
import org.springframework.context.annotation.Configuration;
import org.springframework.data.jpa.repository.config.EnableJpaRepositories;
import org.springframework.transaction.annotation.EnableTransactionManagement;
import org.springframework.web.servlet.config.annotation.EnableWebMvc;
@Configuration
@EnableJpaRepositories(basePackages = "com.dbility.apps.dev")
@EnableTransactionManagement
@EnableWebMvc
public class AppConfig {
}
다음은 intellij IDEA에서 실행한 console로그다.
C:\Dev64\tools\jdk\openjdk-1.8.0.292-1.b10.ojdkbuild\bin\java.exe -XX:TieredStopAtLevel=1 -noverify -Dspring.output.ansi.enabled=always -Dcom.sun.management.jmxremote -Dspring.jmx.enabled=true -Dspring.liveBeansView.mbeanDomain -Dspring.application.admin.enabled=true -javaagent:C:\Dev64\tools\ideaIU-2021.2.2.win\lib\idea_rt.jar=64466:C:\Dev64\tools\ideaIU-2021.2.2.win\bin -Dfile.encoding=UTF-8 -classpath C:\Dev64\tools\jdk\openjdk-1.8.0.292-1.b10.ojdkbuild\jre\lib\charsets.jar;C:\Dev64\tools\jdk\openjdk-1.8.0.292-1.b10.ojdkbuild\jre\lib\ext\access-bridge-64.jar;C:\Dev64\tools\jdk\openjdk-1.8.0.292-1.b10.ojdkbuild\jre\lib\ext\cldrdata.jar;C:\Dev64\tools\jdk\openjdk-1.8.0.292-1.b10.ojdkbuild\jre\lib\ext\dnsns.jar;C:\Dev64\tools\jdk\openjdk-1.8.0.292-1.b10.ojdkbuild\jre\lib\ext\jaccess.jar;C:\Dev64\tools\jdk\openjdk-1.8.0.292-1.b10.ojdkbuild\jre\lib\ext\localedata.jar;C:\Dev64\tools\jdk\openjdk-1.8.0.292-1.b10.ojdkbuild\jre\lib\ext\nashorn.jar;C:\Dev64\tools\jdk\openjdk-1.8.0.292-1.b10.ojdkbuild\jre\lib\ext\sunec.jar;C:\Dev64\tools\jdk\openjdk-1.8.0.292-1.b10.ojdkbuild\jre\lib\ext\sunjce_provider.jar;C:\Dev64\tools\jdk\openjdk-1.8.0.292-1.b10.ojdkbuild\jre\lib\ext\sunmscapi.jar;C:\Dev64\tools\jdk\openjdk-1.8.0.292-1.b10.ojdkbuild\jre\lib\ext\sunpkcs11.jar;C:\Dev64\tools\jdk\openjdk-1.8.0.292-1.b10.ojdkbuild\jre\lib\ext\zipfs.jar;C:\Dev64\tools\jdk\openjdk-1.8.0.292-1.b10.ojdkbuild\jre\lib\jce.jar;C:\Dev64\tools\jdk\openjdk-1.8.0.292-1.b10.ojdkbuild\jre\lib\jfr.jar;C:\Dev64\tools\jdk\openjdk-1.8.0.292-1.b10.ojdkbuild\jre\lib\jsse.jar;C:\Dev64\tools\jdk\openjdk-1.8.0.292-1.b10.ojdkbuild\jre\lib\management-agent.jar;C:\Dev64\tools\jdk\openjdk-1.8.0.292-1.b10.ojdkbuild\jre\lib\resources.jar;C:\Dev64\tools\jdk\openjdk-1.8.0.292-1.b10.ojdkbuild\jre\lib\rt.jar;C:\Dev64\workspace\devapi\target\classes;C:\Dev64\maven\repository\org\springframework\boot\spring-boot-starter-data-jpa\2.6.3\spring-boot-starter-data-jpa-2.6.3.jar;C:\Dev64\maven\repository\org\springframework\boot\spring-boot-starter-aop\2.6.3\spring-boot-starter-aop-2.6.3.jar;C:\Dev64\maven\repository\org\springframework\spring-aop\5.3.15\spring-aop-5.3.15.jar;C:\Dev64\maven\repository\org\aspectj\aspectjweaver\1.9.7\aspectjweaver-1.9.7.jar;C:\Dev64\maven\repository\org\springframework\boot\spring-boot-starter-jdbc\2.6.3\spring-boot-starter-jdbc-2.6.3.jar;C:\Dev64\maven\repository\com\zaxxer\HikariCP\4.0.3\HikariCP-4.0.3.jar;C:\Dev64\maven\repository\org\springframework\spring-jdbc\5.3.15\spring-jdbc-5.3.15.jar;C:\Dev64\maven\repository\jakarta\transaction\jakarta.transaction-api\1.3.3\jakarta.transaction-api-1.3.3.jar;C:\Dev64\maven\repository\jakarta\persistence\jakarta.persistence-api\2.2.3\jakarta.persistence-api-2.2.3.jar;C:\Dev64\maven\repository\org\hibernate\hibernate-core\5.6.4.Final\hibernate-core-5.6.4.Final.jar;C:\Dev64\maven\repository\org\jboss\logging\jboss-logging\3.4.3.Final\jboss-logging-3.4.3.Final.jar;C:\Dev64\maven\repository\net\bytebuddy\byte-buddy\1.11.22\byte-buddy-1.11.22.jar;C:\Dev64\maven\repository\antlr\antlr\2.7.7\antlr-2.7.7.jar;C:\Dev64\maven\repository\org\jboss\jandex\2.4.2.Final\jandex-2.4.2.Final.jar;C:\Dev64\maven\repository\com\fasterxml\classmate\1.5.1\classmate-1.5.1.jar;C:\Dev64\maven\repository\org\hibernate\common\hibernate-commons-annotations\5.1.2.Final\hibernate-commons-annotations-5.1.2.Final.jar;C:\Dev64\maven\repository\org\glassfish\jaxb\jaxb-runtime\2.3.5\jaxb-runtime-2.3.5.jar;C:\Dev64\maven\repository\org\glassfish\jaxb\txw2\2.3.5\txw2-2.3.5.jar;C:\Dev64\maven\repository\com\sun\istack\istack-commons-runtime\3.0.12\istack-commons-runtime-3.0.12.jar;C:\Dev64\maven\repository\com\sun\activation\jakarta.activation\1.2.2\jakarta.activation-1.2.2.jar;C:\Dev64\maven\repository\org\springframework\data\spring-data-jpa\2.6.1\spring-data-jpa-2.6.1.jar;C:\Dev64\maven\repository\org\springframework\data\spring-data-commons\2.6.1\spring-data-commons-2.6.1.jar;C:\Dev64\maven\repository\org\springframework\spring-orm\5.3.15\spring-orm-5.3.15.jar;C:\Dev64\maven\repository\org\springframework\spring-context\5.3.15\spring-context-5.3.15.jar;C:\Dev64\maven\repository\org\springframework\spring-tx\5.3.15\spring-tx-5.3.15.jar;C:\Dev64\maven\repository\org\springframework\spring-beans\5.3.15\spring-beans-5.3.15.jar;C:\Dev64\maven\repository\org\slf4j\slf4j-api\1.7.33\slf4j-api-1.7.33.jar;C:\Dev64\maven\repository\org\springframework\spring-aspects\5.3.15\spring-aspects-5.3.15.jar;C:\Dev64\maven\repository\org\springframework\boot\spring-boot-starter-web\2.6.3\spring-boot-starter-web-2.6.3.jar;C:\Dev64\maven\repository\org\springframework\boot\spring-boot-starter\2.6.3\spring-boot-starter-2.6.3.jar;C:\Dev64\maven\repository\org\springframework\boot\spring-boot-starter-logging\2.6.3\spring-boot-starter-logging-2.6.3.jar;C:\Dev64\maven\repository\ch\qos\logback\logback-classic\1.2.10\logback-classic-1.2.10.jar;C:\Dev64\maven\repository\ch\qos\logback\logback-core\1.2.10\logback-core-1.2.10.jar;C:\Dev64\maven\repository\org\apache\logging\log4j\log4j-to-slf4j\2.17.1\log4j-to-slf4j-2.17.1.jar;C:\Dev64\maven\repository\org\apache\logging\log4j\log4j-api\2.17.1\log4j-api-2.17.1.jar;C:\Dev64\maven\repository\org\slf4j\jul-to-slf4j\1.7.33\jul-to-slf4j-1.7.33.jar;C:\Dev64\maven\repository\jakarta\annotation\jakarta.annotation-api\1.3.5\jakarta.annotation-api-1.3.5.jar;C:\Dev64\maven\repository\org\yaml\snakeyaml\1.29\snakeyaml-1.29.jar;C:\Dev64\maven\repository\org\springframework\boot\spring-boot-starter-json\2.6.3\spring-boot-starter-json-2.6.3.jar;C:\Dev64\maven\repository\com\fasterxml\jackson\core\jackson-databind\2.13.1\jackson-databind-2.13.1.jar;C:\Dev64\maven\repository\com\fasterxml\jackson\core\jackson-annotations\2.13.1\jackson-annotations-2.13.1.jar;C:\Dev64\maven\repository\com\fasterxml\jackson\core\jackson-core\2.13.1\jackson-core-2.13.1.jar;C:\Dev64\maven\repository\com\fasterxml\jackson\datatype\jackson-datatype-jdk8\2.13.1\jackson-datatype-jdk8-2.13.1.jar;C:\Dev64\maven\repository\com\fasterxml\jackson\datatype\jackson-datatype-jsr310\2.13.1\jackson-datatype-jsr310-2.13.1.jar;C:\Dev64\maven\repository\com\fasterxml\jackson\module\jackson-module-parameter-names\2.13.1\jackson-module-parameter-names-2.13.1.jar;C:\Dev64\maven\repository\org\springframework\boot\spring-boot-starter-tomcat\2.6.3\spring-boot-starter-tomcat-2.6.3.jar;C:\Dev64\maven\repository\org\apache\tomcat\embed\tomcat-embed-core\9.0.56\tomcat-embed-core-9.0.56.jar;C:\Dev64\maven\repository\org\apache\tomcat\embed\tomcat-embed-el\9.0.56\tomcat-embed-el-9.0.56.jar;C:\Dev64\maven\repository\org\apache\tomcat\embed\tomcat-embed-websocket\9.0.56\tomcat-embed-websocket-9.0.56.jar;C:\Dev64\maven\repository\org\springframework\spring-web\5.3.15\spring-web-5.3.15.jar;C:\Dev64\maven\repository\org\springframework\spring-webmvc\5.3.15\spring-webmvc-5.3.15.jar;C:\Dev64\maven\repository\org\springframework\spring-expression\5.3.15\spring-expression-5.3.15.jar;C:\Dev64\maven\repository\org\springframework\boot\spring-boot-devtools\2.6.3\spring-boot-devtools-2.6.3.jar;C:\Dev64\maven\repository\org\springframework\boot\spring-boot\2.6.3\spring-boot-2.6.3.jar;C:\Dev64\maven\repository\org\springframework\boot\spring-boot-autoconfigure\2.6.3\spring-boot-autoconfigure-2.6.3.jar;C:\Dev64\maven\repository\com\h2database\h2\1.4.200\h2-1.4.200.jar;C:\Dev64\maven\repository\org\projectlombok\lombok\1.18.22\lombok-1.18.22.jar;C:\Dev64\maven\repository\jakarta\xml\bind\jakarta.xml.bind-api\2.3.3\jakarta.xml.bind-api-2.3.3.jar;C:\Dev64\maven\repository\jakarta\activation\jakarta.activation-api\1.2.2\jakarta.activation-api-1.2.2.jar;C:\Dev64\maven\repository\org\springframework\spring-core\5.3.15\spring-core-5.3.15.jar;C:\Dev64\maven\repository\org\springframework\spring-jcl\5.3.15\spring-jcl-5.3.15.jar;C:\Dev64\maven\repository\commons-fileupload\commons-fileupload\1.2.2\commons-fileupload-1.2.2.jar;C:\Dev64\maven\repository\commons-io\commons-io\2.4\commons-io-2.4.jar;C:\Dev64\maven\repository\org\modelmapper\modelmapper\2.4.0\modelmapper-2.4.0.jar com.dbility.apps.dev.test.DevapiApplication
13:26:16.566 [Thread-1] DEBUG org.springframework.boot.devtools.restart.classloader.RestartClassLoader - Created RestartClassLoader org.springframework.boot.devtools.restart.classloader.RestartClassLoader@1e7492eb
. ____ _ __ _ _
/\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
\\/ ___)| |_)| | | | | || (_| | ) ) ) )
' |____| .__|_| |_|_| |_\__, | / / / /
=========|_|==============|___/=/_/_/_/
:: Spring Boot :: (v2.6.3)
13:26:16.979 [restartedMain] INFO c.d.apps.dev.test.DevapiApplication 55 - Starting DevapiApplication using Java 1.8.0_292 on DESKTOP-SFA1IFC with PID 18840 (C:\Dev64\workspace\devapi\target\classes started by ROOKIE in C:\Dev64\workspace\devapi)
13:26:16.981 [restartedMain] DEBUG c.d.apps.dev.test.DevapiApplication 56 - Running with Spring Boot v2.6.3, Spring v5.3.15
13:26:16.981 [restartedMain] INFO c.d.apps.dev.test.DevapiApplication 637 - No active profile set, falling back to default profiles: default
13:26:17.044 [restartedMain] INFO .e.DevToolsPropertyDefaultsPostProcessor 255 - Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable
13:26:17.044 [restartedMain] INFO .e.DevToolsPropertyDefaultsPostProcessor 255 - For additional web related logging consider setting the 'logging.level.web' property to 'DEBUG'
13:26:17.527 [restartedMain] INFO .s.d.r.c.RepositoryConfigurationDelegate 132 - Bootstrapping Spring Data JPA repositories in DEFAULT mode.
13:26:17.585 [restartedMain] INFO .s.d.r.c.RepositoryConfigurationDelegate 201 - Finished Spring Data repository scanning in 51 ms. Found 1 JPA repository interfaces.
13:26:18.177 [restartedMain] INFO o.s.b.w.e.tomcat.TomcatWebServer 108 - Tomcat initialized with port(s): 9090 (http)
13:26:18.184 [restartedMain] INFO o.a.catalina.core.StandardService 173 - Starting service [Tomcat]
13:26:18.184 [restartedMain] INFO o.a.catalina.core.StandardEngine 173 - Starting Servlet engine: [Apache Tomcat/9.0.56]
13:26:18.276 [restartedMain] INFO o.a.c.c.C.[Tomcat].[localhost].[/] 173 - Initializing Spring embedded WebApplicationContext
13:26:18.276 [restartedMain] INFO w.s.c.ServletWebServerApplicationContext 290 - Root WebApplicationContext: initialization completed in 1231 ms
13:26:18.303 [restartedMain] INFO com.zaxxer.hikari.HikariDataSource 110 - HikariPool-1 - Starting...
13:26:18.398 [restartedMain] INFO com.zaxxer.hikari.HikariDataSource 123 - HikariPool-1 - Start completed.
13:26:18.406 [restartedMain] INFO o.s.b.a.h.H2ConsoleAutoConfiguration 89 - H2 console available at '/h2-console'. Database available at 'jdbc:h2:mem:testdb:DB_CLOSE_DELAY=-1'
13:26:18.560 [restartedMain] DEBUG o.h.jpa.internal.util.LogHelper 102 - PersistenceUnitInfo [
name: default
persistence provider classname: null
classloader: org.springframework.boot.devtools.restart.classloader.RestartClassLoader@1e7492eb
excludeUnlistedClasses: true
JTA datasource: null
Non JTA datasource: HikariDataSource (HikariPool-1)
Transaction type: RESOURCE_LOCAL
PU root URL: file:/C:/Dev64/workspace/devapi/target/classes/
Shared Cache Mode: UNSPECIFIED
Validation Mode: AUTO
Jar files URLs []
Managed classes names [
com.dbility.apps.dev.test.RoomsEntity]
Mapping files names []
Properties []
13:26:18.609 [restartedMain] DEBUG o.h.i.internal.IntegratorServiceImpl 46 - Adding Integrator [org.hibernate.cfg.beanvalidation.BeanValidationIntegrator].
13:26:18.610 [restartedMain] DEBUG o.h.i.internal.IntegratorServiceImpl 46 - Adding Integrator [org.hibernate.secure.spi.JaccIntegrator].
13:26:18.612 [restartedMain] DEBUG o.h.i.internal.IntegratorServiceImpl 46 - Adding Integrator [org.hibernate.cache.internal.CollectionCacheInvalidator].
13:26:18.648 [restartedMain] INFO org.hibernate.Version 44 - HHH000412: Hibernate ORM core version 5.6.4.Final
13:26:18.650 [restartedMain] DEBUG org.hibernate.cfg.Environment 199 - HHH000206: hibernate.properties not found
13:26:18.774 [restartedMain] DEBUG o.h.service.spi.ServiceBinding 68 - Overriding existing service binding [org.hibernate.secure.spi.JaccService]
13:26:18.785 [restartedMain] DEBUG o.h.c.i.RegionFactoryInitiator 118 - Cannot default RegionFactory based on registered strategies as `[]` RegionFactory strategies were registered
13:26:18.785 [restartedMain] DEBUG o.h.c.i.RegionFactoryInitiator 49 - Cache region factory : org.hibernate.cache.internal.NoCachingRegionFactory
13:26:18.804 [restartedMain] INFO o.h.annotations.common.Version 56 - HCANN000001: Hibernate Commons Annotations {5.1.2.Final}
13:26:18.840 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration boolean -> org.hibernate.type.BooleanType@518a6c78
13:26:18.841 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration boolean -> org.hibernate.type.BooleanType@518a6c78
13:26:18.841 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration java.lang.Boolean -> org.hibernate.type.BooleanType@518a6c78
13:26:18.842 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration numeric_boolean -> org.hibernate.type.NumericBooleanType@1853de39
13:26:18.843 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration true_false -> org.hibernate.type.TrueFalseType@521b87b7
13:26:18.844 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration yes_no -> org.hibernate.type.YesNoType@5d144ec1
13:26:18.846 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration byte -> org.hibernate.type.ByteType@aff89e5
13:26:18.846 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration byte -> org.hibernate.type.ByteType@aff89e5
13:26:18.846 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration java.lang.Byte -> org.hibernate.type.ByteType@aff89e5
13:26:18.847 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration character -> org.hibernate.type.CharacterType@4be01d08
13:26:18.847 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration char -> org.hibernate.type.CharacterType@4be01d08
13:26:18.848 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration java.lang.Character -> org.hibernate.type.CharacterType@4be01d08
13:26:18.849 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration short -> org.hibernate.type.ShortType@7d5b0818
13:26:18.849 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration short -> org.hibernate.type.ShortType@7d5b0818
13:26:18.849 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration java.lang.Short -> org.hibernate.type.ShortType@7d5b0818
13:26:18.850 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration integer -> org.hibernate.type.IntegerType@64073558
13:26:18.850 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration int -> org.hibernate.type.IntegerType@64073558
13:26:18.850 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration java.lang.Integer -> org.hibernate.type.IntegerType@64073558
13:26:18.851 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration long -> org.hibernate.type.LongType@559218fe
13:26:18.851 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration long -> org.hibernate.type.LongType@559218fe
13:26:18.851 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration java.lang.Long -> org.hibernate.type.LongType@559218fe
13:26:18.852 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration float -> org.hibernate.type.FloatType@1b0f631
13:26:18.852 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration float -> org.hibernate.type.FloatType@1b0f631
13:26:18.853 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration java.lang.Float -> org.hibernate.type.FloatType@1b0f631
13:26:18.854 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration double -> org.hibernate.type.DoubleType@5554a627
13:26:18.854 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration double -> org.hibernate.type.DoubleType@5554a627
13:26:18.855 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration java.lang.Double -> org.hibernate.type.DoubleType@5554a627
13:26:18.856 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration big_decimal -> org.hibernate.type.BigDecimalType@1bfdd08a
13:26:18.857 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration java.math.BigDecimal -> org.hibernate.type.BigDecimalType@1bfdd08a
13:26:18.858 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration big_integer -> org.hibernate.type.BigIntegerType@26228966
13:26:18.858 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration java.math.BigInteger -> org.hibernate.type.BigIntegerType@26228966
13:26:18.860 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration string -> org.hibernate.type.StringType@23633763
13:26:18.860 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration java.lang.String -> org.hibernate.type.StringType@23633763
13:26:18.861 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration nstring -> org.hibernate.type.StringNVarcharType@14ba152f
13:26:18.862 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration ncharacter -> org.hibernate.type.CharacterNCharType@3e566a59
13:26:18.863 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration url -> org.hibernate.type.UrlType@60eef58d
13:26:18.863 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration java.net.URL -> org.hibernate.type.UrlType@60eef58d
13:26:18.864 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration Duration -> org.hibernate.type.DurationType@2ce4eba7
13:26:18.864 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration java.time.Duration -> org.hibernate.type.DurationType@2ce4eba7
13:26:18.865 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration Instant -> org.hibernate.type.InstantType@f150ba3
13:26:18.865 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration java.time.Instant -> org.hibernate.type.InstantType@f150ba3
13:26:18.867 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration LocalDateTime -> org.hibernate.type.LocalDateTimeType@5643d622
13:26:18.867 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration java.time.LocalDateTime -> org.hibernate.type.LocalDateTimeType@5643d622
13:26:18.868 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration LocalDate -> org.hibernate.type.LocalDateType@39a1c14c
13:26:18.868 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration java.time.LocalDate -> org.hibernate.type.LocalDateType@39a1c14c
13:26:18.870 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration LocalTime -> org.hibernate.type.LocalTimeType@3a5c1b0b
13:26:18.870 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration java.time.LocalTime -> org.hibernate.type.LocalTimeType@3a5c1b0b
13:26:18.872 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration OffsetDateTime -> org.hibernate.type.OffsetDateTimeType@6cc0180
13:26:18.872 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration java.time.OffsetDateTime -> org.hibernate.type.OffsetDateTimeType@6cc0180
13:26:18.874 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration OffsetTime -> org.hibernate.type.OffsetTimeType@18c62a61
13:26:18.874 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration java.time.OffsetTime -> org.hibernate.type.OffsetTimeType@18c62a61
13:26:18.876 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration ZonedDateTime -> org.hibernate.type.ZonedDateTimeType@7f641fb6
13:26:18.876 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration java.time.ZonedDateTime -> org.hibernate.type.ZonedDateTimeType@7f641fb6
13:26:18.878 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration date -> org.hibernate.type.DateType@4e0b7e41
13:26:18.878 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration java.sql.Date -> org.hibernate.type.DateType@4e0b7e41
13:26:18.879 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration time -> org.hibernate.type.TimeType@73c35bcc
13:26:18.879 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration java.sql.Time -> org.hibernate.type.TimeType@73c35bcc
13:26:18.881 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration timestamp -> org.hibernate.type.TimestampType@7cbfb517
13:26:18.881 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration java.sql.Timestamp -> org.hibernate.type.TimestampType@7cbfb517
13:26:18.882 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration java.util.Date -> org.hibernate.type.TimestampType@7cbfb517
13:26:18.882 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration dbtimestamp -> org.hibernate.type.DbTimestampType@3883270
13:26:18.884 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration calendar -> org.hibernate.type.CalendarType@20d0c17d
13:26:18.885 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration java.util.Calendar -> org.hibernate.type.CalendarType@20d0c17d
13:26:18.885 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration java.util.GregorianCalendar -> org.hibernate.type.CalendarType@20d0c17d
13:26:18.886 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration calendar_date -> org.hibernate.type.CalendarDateType@528b9bec
13:26:18.887 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration calendar_time -> org.hibernate.type.CalendarTimeType@6ad48f2a
13:26:18.888 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration locale -> org.hibernate.type.LocaleType@7fab78fa
13:26:18.888 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration java.util.Locale -> org.hibernate.type.LocaleType@7fab78fa
13:26:18.890 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration currency -> org.hibernate.type.CurrencyType@6b73f241
13:26:18.890 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration java.util.Currency -> org.hibernate.type.CurrencyType@6b73f241
13:26:18.891 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration timezone -> org.hibernate.type.TimeZoneType@33f83587
13:26:18.891 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration java.util.TimeZone -> org.hibernate.type.TimeZoneType@33f83587
13:26:18.892 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration class -> org.hibernate.type.ClassType@7c142896
13:26:18.892 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration java.lang.Class -> org.hibernate.type.ClassType@7c142896
13:26:18.893 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration uuid-binary -> org.hibernate.type.UUIDBinaryType@7e21ecd6
13:26:18.894 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration java.util.UUID -> org.hibernate.type.UUIDBinaryType@7e21ecd6
13:26:18.894 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration uuid-char -> org.hibernate.type.UUIDCharType@6ed47376
13:26:18.896 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration binary -> org.hibernate.type.BinaryType@4fe1a37e
13:26:18.896 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration byte[] -> org.hibernate.type.BinaryType@4fe1a37e
13:26:18.896 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration [B -> org.hibernate.type.BinaryType@4fe1a37e
13:26:18.897 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration wrapper-binary -> org.hibernate.type.WrapperBinaryType@660a8ce4
13:26:18.897 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration Byte[] -> org.hibernate.type.WrapperBinaryType@660a8ce4
13:26:18.898 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration [Ljava.lang.Byte; -> org.hibernate.type.WrapperBinaryType@660a8ce4
13:26:18.899 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration row_version -> org.hibernate.type.RowVersionType@22bf8857
13:26:18.900 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration image -> org.hibernate.type.ImageType@498c9ce7
13:26:18.901 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration characters -> org.hibernate.type.CharArrayType@1ad9ed9b
13:26:18.901 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration char[] -> org.hibernate.type.CharArrayType@1ad9ed9b
13:26:18.902 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration [C -> org.hibernate.type.CharArrayType@1ad9ed9b
13:26:18.903 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration wrapper-characters -> org.hibernate.type.CharacterArrayType@63b20328
13:26:18.903 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration [Ljava.lang.Character; -> org.hibernate.type.CharacterArrayType@63b20328
13:26:18.903 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration Character[] -> org.hibernate.type.CharacterArrayType@63b20328
13:26:18.904 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration text -> org.hibernate.type.TextType@6dbc7ad5
13:26:18.904 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration ntext -> org.hibernate.type.NTextType@3666aa4c
13:26:18.906 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration blob -> org.hibernate.type.BlobType@7a5fc93b
13:26:18.906 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration java.sql.Blob -> org.hibernate.type.BlobType@7a5fc93b
13:26:18.907 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration materialized_blob -> org.hibernate.type.MaterializedBlobType@187670af
13:26:18.909 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration clob -> org.hibernate.type.ClobType@4ce8bfc2
13:26:18.909 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration java.sql.Clob -> org.hibernate.type.ClobType@4ce8bfc2
13:26:18.910 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration nclob -> org.hibernate.type.NClobType@706a8659
13:26:18.910 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration java.sql.NClob -> org.hibernate.type.NClobType@706a8659
13:26:18.911 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration materialized_clob -> org.hibernate.type.MaterializedClobType@22e67bb8
13:26:18.911 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration materialized_nclob -> org.hibernate.type.MaterializedNClobType@27d1c750
13:26:18.912 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration serializable -> org.hibernate.type.SerializableType@10e827ae
13:26:18.915 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration object -> org.hibernate.type.ObjectType@1a7ade2e
13:26:18.916 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration java.lang.Object -> org.hibernate.type.ObjectType@1a7ade2e
13:26:18.916 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration imm_date -> org.hibernate.type.AdaptedImmutableType@4aa86eea
13:26:18.917 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration imm_time -> org.hibernate.type.AdaptedImmutableType@66f423f
13:26:18.917 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration imm_timestamp -> org.hibernate.type.AdaptedImmutableType@44664b93
13:26:18.917 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration imm_dbtimestamp -> org.hibernate.type.AdaptedImmutableType@74a70211
13:26:18.917 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration imm_calendar -> org.hibernate.type.AdaptedImmutableType@7d71ed51
13:26:18.917 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration imm_calendar_date -> org.hibernate.type.AdaptedImmutableType@173267a
13:26:18.917 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration imm_binary -> org.hibernate.type.AdaptedImmutableType@773fcf14
13:26:18.918 [restartedMain] DEBUG org.hibernate.type.BasicTypeRegistry 157 - Adding type registration imm_serializable -> org.hibernate.type.AdaptedImmutableType@3bc4fc68
13:26:18.925 [restartedMain] DEBUG o.h.b.internal.BootstrapContextImpl 259 - Injecting JPA temp ClassLoader [org.springframework.instrument.classloading.SimpleThrowawayClassLoader@35d0b832] into BootstrapContext; was [null]
13:26:18.925 [restartedMain] DEBUG o.h.b.internal.ClassLoaderAccessImpl 45 - ClassLoaderAccessImpl#injectTempClassLoader(org.springframework.instrument.classloading.SimpleThrowawayClassLoader@35d0b832) [was null]
13:26:18.926 [restartedMain] DEBUG o.h.b.internal.BootstrapContextImpl 269 - Injecting ScanEnvironment [org.hibernate.jpa.boot.internal.StandardJpaScanEnvironmentImpl@7a164931] into BootstrapContext; was [null]
13:26:18.926 [restartedMain] DEBUG o.h.b.internal.BootstrapContextImpl 264 - Injecting ScanOptions [org.hibernate.boot.archive.scan.internal.StandardScanOptions@4216bb90] into BootstrapContext; was [org.hibernate.boot.archive.scan.internal.StandardScanOptions@3cf4ea23]
13:26:18.934 [restartedMain] DEBUG o.h.b.internal.BootstrapContextImpl 259 - Injecting JPA temp ClassLoader [null] into BootstrapContext; was [org.springframework.instrument.classloading.SimpleThrowawayClassLoader@35d0b832]
13:26:18.934 [restartedMain] DEBUG o.h.b.internal.ClassLoaderAccessImpl 45 - ClassLoaderAccessImpl#injectTempClassLoader(null) [was org.springframework.instrument.classloading.SimpleThrowawayClassLoader@35d0b832]
13:26:18.940 [restartedMain] DEBUG .i.f.i.DefaultIdentifierGeneratorFactory 98 - Registering IdentifierGenerator strategy [uuid2] -> [org.hibernate.id.UUIDGenerator]
13:26:18.941 [restartedMain] DEBUG .i.f.i.DefaultIdentifierGeneratorFactory 98 - Registering IdentifierGenerator strategy [guid] -> [org.hibernate.id.GUIDGenerator]
13:26:18.941 [restartedMain] DEBUG .i.f.i.DefaultIdentifierGeneratorFactory 98 - Registering IdentifierGenerator strategy [uuid] -> [org.hibernate.id.UUIDHexGenerator]
13:26:18.942 [restartedMain] DEBUG .i.f.i.DefaultIdentifierGeneratorFactory 98 - Registering IdentifierGenerator strategy [uuid.hex] -> [org.hibernate.id.UUIDHexGenerator]
13:26:18.942 [restartedMain] DEBUG .i.f.i.DefaultIdentifierGeneratorFactory 98 - Registering IdentifierGenerator strategy [assigned] -> [org.hibernate.id.Assigned]
13:26:18.944 [restartedMain] DEBUG .i.f.i.DefaultIdentifierGeneratorFactory 98 - Registering IdentifierGenerator strategy [identity] -> [org.hibernate.id.IdentityGenerator]
13:26:18.945 [restartedMain] DEBUG .i.f.i.DefaultIdentifierGeneratorFactory 98 - Registering IdentifierGenerator strategy [select] -> [org.hibernate.id.SelectGenerator]
13:26:18.947 [restartedMain] DEBUG .i.f.i.DefaultIdentifierGeneratorFactory 98 - Registering IdentifierGenerator strategy [sequence] -> [org.hibernate.id.enhanced.SequenceStyleGenerator]
13:26:18.949 [restartedMain] DEBUG .i.f.i.DefaultIdentifierGeneratorFactory 98 - Registering IdentifierGenerator strategy [seqhilo] -> [org.hibernate.id.SequenceHiLoGenerator]
13:26:18.950 [restartedMain] DEBUG .i.f.i.DefaultIdentifierGeneratorFactory 98 - Registering IdentifierGenerator strategy [increment] -> [org.hibernate.id.IncrementGenerator]
13:26:18.951 [restartedMain] DEBUG .i.f.i.DefaultIdentifierGeneratorFactory 98 - Registering IdentifierGenerator strategy [foreign] -> [org.hibernate.id.ForeignGenerator]
13:26:18.952 [restartedMain] DEBUG .i.f.i.DefaultIdentifierGeneratorFactory 98 - Registering IdentifierGenerator strategy [sequence-identity] -> [org.hibernate.id.SequenceIdentityGenerator]
13:26:18.952 [restartedMain] DEBUG .i.f.i.DefaultIdentifierGeneratorFactory 98 - Registering IdentifierGenerator strategy [enhanced-sequence] -> [org.hibernate.id.enhanced.SequenceStyleGenerator]
13:26:18.953 [restartedMain] DEBUG .i.f.i.DefaultIdentifierGeneratorFactory 98 - Registering IdentifierGenerator strategy [enhanced-table] -> [org.hibernate.id.enhanced.TableGenerator]
13:26:18.961 [restartedMain] DEBUG o.h.e.j.e.i.JdbcEnvironmentInitiator 72 - Database ->
name : H2
version : 1.4.200 (2019-10-14)
major : 1
minor : 4
13:26:18.962 [restartedMain] DEBUG o.h.e.j.e.i.JdbcEnvironmentInitiator 83 - Driver ->
name : H2 JDBC Driver
version : 1.4.200 (2019-10-14)
major : 1
minor : 4
13:26:18.962 [restartedMain] DEBUG o.h.e.j.e.i.JdbcEnvironmentInitiator 389 - JDBC version : 4.1
13:26:18.984 [restartedMain] INFO org.hibernate.dialect.Dialect 175 - HHH000400: Using dialect: org.hibernate.dialect.H2Dialect
13:26:19.023 [restartedMain] DEBUG o.h.e.j.e.s.IdentifierHelperBuilder 114 - JDBC driver metadata reported database stores quoted identifiers in neither upper, lower nor mixed case
13:26:19.031 [restartedMain] DEBUG o.h.e.j.e.i.LobCreatorBuilderImpl 89 - HHH000421: Disabling contextual LOB creation as hibernate.jdbc.lob.non_contextual_creation is true
13:26:19.037 [restartedMain] DEBUG o.h.type.spi.TypeConfiguration$Scope 149 - Scoping TypeConfiguration [org.hibernate.type.spi.TypeConfiguration@793ad472] to MetadataBuildingContext [org.hibernate.boot.internal.MetadataBuildingContextRootImpl@427cbf8b]
13:26:19.050 [restartedMain] DEBUG o.h.boot.model.relational.Namespace 51 - Created database namespace [logicalName=Name{catalog=null, schema=null}, physicalName=Name{catalog=null, schema=null}]
13:26:19.060 [restartedMain] DEBUG org.hibernate.cfg.AnnotationBinder 546 - Binding entity from annotated class: com.dbility.apps.dev.test.RoomsEntity
13:26:19.089 [restartedMain] DEBUG org.hibernate.cfg.Ejb3Column 227 - Binding column: Ejb3DiscriminatorColumn{logicalColumnName'DTYPE', discriminatorTypeName='string'}
13:26:19.097 [restartedMain] DEBUG o.h.cfg.annotations.EntityBinder 431 - Import with entity name RoomsEntity
13:26:19.102 [restartedMain] DEBUG o.h.cfg.annotations.EntityBinder 874 - Bind entity com.dbility.apps.dev.test.RoomsEntity on table rooms
13:26:19.124 [restartedMain] DEBUG org.hibernate.cfg.Ejb3Column 227 - Binding column: Ejb3Column{table=org.hibernate.mapping.Table(rooms), mappingColumn=id, insertable=true, updatable=true, unique=false}
13:26:19.128 [restartedMain] DEBUG o.h.b.internal.ClassLoaderAccessImpl 60 - Not known whether passed class name [com.dbility.apps.dev.test.RoomsEntity] is safe
13:26:19.128 [restartedMain] DEBUG o.h.b.internal.ClassLoaderAccessImpl 62 - No temp ClassLoader provided; using live ClassLoader for loading potentially unsafe class : com.dbility.apps.dev.test.RoomsEntity
13:26:19.129 [restartedMain] DEBUG o.h.cfg.annotations.PropertyBinder 175 - MetadataSourceProcessor property id with lazy=false
13:26:19.131 [restartedMain] DEBUG o.h.cfg.AbstractPropertyHolder 94 - Attempting to locate auto-apply AttributeConverter for property [com.dbility.apps.dev.test.RoomsEntity:id]
13:26:19.133 [restartedMain] DEBUG o.h.c.annotations.SimpleValueBinder 410 - building SimpleValue for id
13:26:19.137 [restartedMain] DEBUG o.h.cfg.annotations.PropertyBinder 266 - Building property id
13:26:19.143 [restartedMain] DEBUG org.hibernate.cfg.BinderHelper 514 - #makeIdGenerator(org.hibernate.mapping.SimpleValue([org.hibernate.mapping.Column(id)]), id, org.hibernate.id.enhanced.SequenceStyleGenerator, , ...)
13:26:19.144 [restartedMain] DEBUG org.hibernate.cfg.Ejb3Column 227 - Binding column: Ejb3Column{table=org.hibernate.mapping.Table(rooms), mappingColumn=content, insertable=true, updatable=true, unique=false}
13:26:19.144 [restartedMain] DEBUG o.h.cfg.annotations.PropertyBinder 175 - MetadataSourceProcessor property content with lazy=false
13:26:19.145 [restartedMain] DEBUG o.h.cfg.AbstractPropertyHolder 94 - Attempting to locate auto-apply AttributeConverter for property [com.dbility.apps.dev.test.RoomsEntity:content]
13:26:19.145 [restartedMain] DEBUG o.h.c.annotations.SimpleValueBinder 410 - building SimpleValue for content
13:26:19.145 [restartedMain] DEBUG o.h.cfg.annotations.PropertyBinder 266 - Building property content
13:26:19.146 [restartedMain] DEBUG org.hibernate.cfg.Ejb3Column 227 - Binding column: Ejb3Column{table=org.hibernate.mapping.Table(rooms), mappingColumn=file_name, insertable=true, updatable=true, unique=false}
13:26:19.146 [restartedMain] DEBUG o.h.cfg.annotations.PropertyBinder 175 - MetadataSourceProcessor property file_name with lazy=false
13:26:19.147 [restartedMain] DEBUG o.h.cfg.AbstractPropertyHolder 94 - Attempting to locate auto-apply AttributeConverter for property [com.dbility.apps.dev.test.RoomsEntity:file_name]
13:26:19.147 [restartedMain] DEBUG o.h.c.annotations.SimpleValueBinder 410 - building SimpleValue for file_name
13:26:19.147 [restartedMain] DEBUG o.h.cfg.annotations.PropertyBinder 266 - Building property file_name
13:26:19.147 [restartedMain] DEBUG org.hibernate.cfg.Ejb3Column 227 - Binding column: Ejb3Column{table=org.hibernate.mapping.Table(rooms), mappingColumn=file_type, insertable=true, updatable=true, unique=false}
13:26:19.147 [restartedMain] DEBUG o.h.cfg.annotations.PropertyBinder 175 - MetadataSourceProcessor property file_type with lazy=false
13:26:19.148 [restartedMain] DEBUG o.h.cfg.AbstractPropertyHolder 94 - Attempting to locate auto-apply AttributeConverter for property [com.dbility.apps.dev.test.RoomsEntity:file_type]
13:26:19.148 [restartedMain] DEBUG o.h.c.annotations.SimpleValueBinder 410 - building SimpleValue for file_type
13:26:19.148 [restartedMain] DEBUG o.h.cfg.annotations.PropertyBinder 266 - Building property file_type
13:26:19.148 [restartedMain] DEBUG org.hibernate.cfg.Ejb3Column 227 - Binding column: Ejb3Column{table=org.hibernate.mapping.Table(rooms), mappingColumn=inform_count, insertable=true, updatable=true, unique=false}
13:26:19.149 [restartedMain] DEBUG o.h.cfg.annotations.PropertyBinder 175 - MetadataSourceProcessor property inform_count with lazy=false
13:26:19.149 [restartedMain] DEBUG o.h.cfg.AbstractPropertyHolder 94 - Attempting to locate auto-apply AttributeConverter for property [com.dbility.apps.dev.test.RoomsEntity:inform_count]
13:26:19.149 [restartedMain] DEBUG o.h.c.annotations.SimpleValueBinder 410 - building SimpleValue for inform_count
13:26:19.149 [restartedMain] DEBUG o.h.cfg.annotations.PropertyBinder 266 - Building property inform_count
13:26:19.150 [restartedMain] DEBUG org.hibernate.cfg.Ejb3Column 227 - Binding column: Ejb3Column{table=org.hibernate.mapping.Table(rooms), mappingColumn=price, insertable=true, updatable=true, unique=false}
13:26:19.150 [restartedMain] DEBUG o.h.cfg.annotations.PropertyBinder 175 - MetadataSourceProcessor property price with lazy=false
13:26:19.150 [restartedMain] DEBUG o.h.cfg.AbstractPropertyHolder 94 - Attempting to locate auto-apply AttributeConverter for property [com.dbility.apps.dev.test.RoomsEntity:price]
13:26:19.150 [restartedMain] DEBUG o.h.c.annotations.SimpleValueBinder 410 - building SimpleValue for price
13:26:19.150 [restartedMain] DEBUG o.h.cfg.annotations.PropertyBinder 266 - Building property price
13:26:19.151 [restartedMain] DEBUG org.hibernate.cfg.Ejb3Column 227 - Binding column: Ejb3Column{table=org.hibernate.mapping.Table(rooms), mappingColumn=title, insertable=true, updatable=true, unique=false}
13:26:19.151 [restartedMain] DEBUG o.h.cfg.annotations.PropertyBinder 175 - MetadataSourceProcessor property title with lazy=false
13:26:19.151 [restartedMain] DEBUG o.h.cfg.AbstractPropertyHolder 94 - Attempting to locate auto-apply AttributeConverter for property [com.dbility.apps.dev.test.RoomsEntity:title]
13:26:19.151 [restartedMain] DEBUG o.h.c.annotations.SimpleValueBinder 410 - building SimpleValue for title
13:26:19.151 [restartedMain] DEBUG o.h.cfg.annotations.PropertyBinder 266 - Building property title
13:26:19.159 [restartedMain] DEBUG o.h.c.annotations.SimpleValueBinder 455 - Starting fillSimpleValue for id
13:26:19.159 [restartedMain] DEBUG o.h.c.annotations.SimpleValueBinder 455 - Starting fillSimpleValue for content
13:26:19.159 [restartedMain] DEBUG o.h.c.annotations.SimpleValueBinder 455 - Starting fillSimpleValue for file_name
13:26:19.160 [restartedMain] DEBUG o.h.c.annotations.SimpleValueBinder 455 - Starting fillSimpleValue for file_type
13:26:19.160 [restartedMain] DEBUG o.h.c.annotations.SimpleValueBinder 455 - Starting fillSimpleValue for inform_count
13:26:19.160 [restartedMain] DEBUG o.h.c.annotations.SimpleValueBinder 455 - Starting fillSimpleValue for price
13:26:19.160 [restartedMain] DEBUG o.h.c.annotations.SimpleValueBinder 455 - Starting fillSimpleValue for title
13:26:19.162 [restartedMain] DEBUG org.hibernate.mapping.PrimaryKey 36 - Forcing column [id] to be non-null as it is part of the primary key for table [rooms]
13:26:19.198 [restartedMain] DEBUG o.h.internal.SessionFactoryImpl 208 - Building session factory
13:26:19.199 [restartedMain] DEBUG org.hibernate.cfg.Settings 68 - SessionFactory name : null
13:26:19.200 [restartedMain] DEBUG org.hibernate.cfg.Settings 69 - Automatic flush during beforeCompletion(): enabled
13:26:19.200 [restartedMain] DEBUG org.hibernate.cfg.Settings 70 - Automatic session close at end of transaction: disabled
13:26:19.200 [restartedMain] DEBUG org.hibernate.cfg.Settings 72 - Statistics: disabled
13:26:19.201 [restartedMain] DEBUG org.hibernate.cfg.Settings 74 - Deleted entity synthetic identifier rollback: disabled
13:26:19.201 [restartedMain] DEBUG org.hibernate.cfg.Settings 75 - Default entity-mode: pojo
13:26:19.201 [restartedMain] DEBUG org.hibernate.cfg.Settings 76 - Check Nullability in Core (should be disabled when Bean Validation is on): enabled
13:26:19.201 [restartedMain] DEBUG org.hibernate.cfg.Settings 77 - Allow initialization of lazy state outside session : disabled
13:26:19.201 [restartedMain] DEBUG org.hibernate.cfg.Settings 79 - Using BatchFetchStyle : LEGACY
13:26:19.201 [restartedMain] DEBUG org.hibernate.cfg.Settings 80 - Default batch fetch size: -1
13:26:19.202 [restartedMain] DEBUG org.hibernate.cfg.Settings 81 - Maximum outer join fetch depth: null
13:26:19.202 [restartedMain] DEBUG org.hibernate.cfg.Settings 82 - Default null ordering: NONE
13:26:19.202 [restartedMain] DEBUG org.hibernate.cfg.Settings 83 - Order SQL updates by primary key: disabled
13:26:19.202 [restartedMain] DEBUG org.hibernate.cfg.Settings 84 - Order SQL inserts for batching: disabled
13:26:19.202 [restartedMain] DEBUG org.hibernate.cfg.Settings 86 - multi-tenancy strategy : NONE
13:26:19.202 [restartedMain] DEBUG org.hibernate.cfg.Settings 88 - JTA Track by Thread: enabled
13:26:19.202 [restartedMain] DEBUG org.hibernate.cfg.Settings 90 - Query language substitutions: {}
13:26:19.202 [restartedMain] DEBUG org.hibernate.cfg.Settings 91 - Named query checking : enabled
13:26:19.203 [restartedMain] DEBUG org.hibernate.cfg.Settings 93 - Second-level cache: disabled
13:26:19.203 [restartedMain] DEBUG org.hibernate.cfg.Settings 94 - Second-level query cache: disabled
13:26:19.203 [restartedMain] DEBUG org.hibernate.cfg.Settings 95 - Second-level query cache factory: null
13:26:19.203 [restartedMain] DEBUG org.hibernate.cfg.Settings 96 - Second-level cache region prefix: null
13:26:19.203 [restartedMain] DEBUG org.hibernate.cfg.Settings 97 - Optimize second-level cache for minimal puts: disabled
13:26:19.203 [restartedMain] DEBUG org.hibernate.cfg.Settings 98 - Structured second-level cache entries: disabled
13:26:19.203 [restartedMain] DEBUG org.hibernate.cfg.Settings 99 - Second-level cache direct-reference entries: disabled
13:26:19.204 [restartedMain] DEBUG org.hibernate.cfg.Settings 100 - Automatic eviction of collection cache: disabled
13:26:19.204 [restartedMain] DEBUG org.hibernate.cfg.Settings 102 - JDBC batch size: 15
13:26:19.204 [restartedMain] DEBUG org.hibernate.cfg.Settings 103 - JDBC batch updates for versioned data: enabled
13:26:19.204 [restartedMain] DEBUG org.hibernate.cfg.Settings 104 - Scrollable result sets: enabled
13:26:19.204 [restartedMain] DEBUG org.hibernate.cfg.Settings 105 - Wrap result sets: disabled
13:26:19.204 [restartedMain] DEBUG org.hibernate.cfg.Settings 106 - JDBC3 getGeneratedKeys(): enabled
13:26:19.205 [restartedMain] DEBUG org.hibernate.cfg.Settings 107 - JDBC result set fetch size: null
13:26:19.205 [restartedMain] DEBUG org.hibernate.cfg.Settings 108 - Connection release mode: ON_CLOSE
13:26:19.205 [restartedMain] DEBUG org.hibernate.cfg.Settings 109 - Generate SQL with comments: disabled
13:26:19.205 [restartedMain] DEBUG org.hibernate.cfg.Settings 111 - JPA compliance - query : disabled
13:26:19.205 [restartedMain] DEBUG org.hibernate.cfg.Settings 112 - JPA compliance - closed-handling : disabled
13:26:19.205 [restartedMain] DEBUG org.hibernate.cfg.Settings 113 - JPA compliance - lists : disabled
13:26:19.205 [restartedMain] DEBUG org.hibernate.cfg.Settings 114 - JPA compliance - transactions : disabled
13:26:19.253 [restartedMain] DEBUG .h.s.i.SessionFactoryServiceRegistryImpl 92 - EventListenerRegistry access via ServiceRegistry is deprecated. Use `sessionFactory.getEventEngine().getListenerRegistry()` instead
13:26:19.255 [restartedMain] DEBUG .h.s.i.SessionFactoryServiceRegistryImpl 92 - EventListenerRegistry access via ServiceRegistry is deprecated. Use `sessionFactory.getEventEngine().getListenerRegistry()` instead
13:26:19.264 [restartedMain] DEBUG o.h.internal.SessionFactoryImpl 276 - Session factory constructed with filter configurations : {}
13:26:19.264 [restartedMain] DEBUG o.h.internal.SessionFactoryImpl 277 - Instantiating session factory with properties: {sun.desktop=windows, awt.toolkit=sun.awt.windows.WToolkit, hibernate.format_sql=true, hibernate.id.new_generator_mappings=true, java.specification.version=1.8, file.encoding.pkg=sun.io, sun.cpu.isalist=amd64, hibernate.resource.beans.container=org.springframework.orm.hibernate5.SpringBeanContainer@12058976, hibernate.connection.handling_mode=DELAYED_ACQUISITION_AND_HOLD, sun.jnu.encoding=MS949, hibernate.implicit_naming_strategy=org.springframework.boot.orm.jpa.hibernate.SpringImplicitNamingStrategy, java.class.path=C:\Dev64\tools\jdk\openjdk-1.8.0.292-1.b10.ojdkbuild\jre\lib\charsets.jar;C:\Dev64\tools\jdk\openjdk-1.8.0.292-1.b10.ojdkbuild\jre\lib\ext\access-bridge-64.jar;C:\Dev64\tools\jdk\openjdk-1.8.0.292-1.b10.ojdkbuild\jre\lib\ext\cldrdata.jar;C:\Dev64\tools\jdk\openjdk-1.8.0.292-1.b10.ojdkbuild\jre\lib\ext\dnsns.jar;C:\Dev64\tools\jdk\openjdk-1.8.0.292-1.b10.ojdkbuild\jre\lib\ext\jaccess.jar;C:\Dev64\tools\jdk\openjdk-1.8.0.292-1.b10.ojdkbuild\jre\lib\ext\localedata.jar;C:\Dev64\tools\jdk\openjdk-1.8.0.292-1.b10.ojdkbuild\jre\lib\ext\nashorn.jar;C:\Dev64\tools\jdk\openjdk-1.8.0.292-1.b10.ojdkbuild\jre\lib\ext\sunec.jar;C:\Dev64\tools\jdk\openjdk-1.8.0.292-1.b10.ojdkbuild\jre\lib\ext\sunjce_provider.jar;C:\Dev64\tools\jdk\openjdk-1.8.0.292-1.b10.ojdkbuild\jre\lib\ext\sunmscapi.jar;C:\Dev64\tools\jdk\openjdk-1.8.0.292-1.b10.ojdkbuild\jre\lib\ext\sunpkcs11.jar;C:\Dev64\tools\jdk\openjdk-1.8.0.292-1.b10.ojdkbuild\jre\lib\ext\zipfs.jar;C:\Dev64\tools\jdk\openjdk-1.8.0.292-1.b10.ojdkbuild\jre\lib\jce.jar;C:\Dev64\tools\jdk\openjdk-1.8.0.292-1.b10.ojdkbuild\jre\lib\jfr.jar;C:\Dev64\tools\jdk\openjdk-1.8.0.292-1.b10.ojdkbuild\jre\lib\jsse.jar;C:\Dev64\tools\jdk\openjdk-1.8.0.292-1.b10.ojdkbuild\jre\lib\management-agent.jar;C:\Dev64\tools\jdk\openjdk-1.8.0.292-1.b10.ojdkbuild\jre\lib\resources.jar;C:\Dev64\tools\jdk\openjdk-1.8.0.292-1.b10.ojdkbuild\jre\lib\rt.jar;C:\Dev64\workspace\devapi\target\classes;C:\Dev64\maven\repository\org\springframework\boot\spring-boot-starter-data-jpa\2.6.3\spring-boot-starter-data-jpa-2.6.3.jar;C:\Dev64\maven\repository\org\springframework\boot\spring-boot-starter-aop\2.6.3\spring-boot-starter-aop-2.6.3.jar;C:\Dev64\maven\repository\org\springframework\spring-aop\5.3.15\spring-aop-5.3.15.jar;C:\Dev64\maven\repository\org\aspectj\aspectjweaver\1.9.7\aspectjweaver-1.9.7.jar;C:\Dev64\maven\repository\org\springframework\boot\spring-boot-starter-jdbc\2.6.3\spring-boot-starter-jdbc-2.6.3.jar;C:\Dev64\maven\repository\com\zaxxer\HikariCP\4.0.3\HikariCP-4.0.3.jar;C:\Dev64\maven\repository\org\springframework\spring-jdbc\5.3.15\spring-jdbc-5.3.15.jar;C:\Dev64\maven\repository\jakarta\transaction\jakarta.transaction-api\1.3.3\jakarta.transaction-api-1.3.3.jar;C:\Dev64\maven\repository\jakarta\persistence\jakarta.persistence-api\2.2.3\jakarta.persistence-api-2.2.3.jar;C:\Dev64\maven\repository\org\hibernate\hibernate-core\5.6.4.Final\hibernate-core-5.6.4.Final.jar;C:\Dev64\maven\repository\org\jboss\logging\jboss-logging\3.4.3.Final\jboss-logging-3.4.3.Final.jar;C:\Dev64\maven\repository\net\bytebuddy\byte-buddy\1.11.22\byte-buddy-1.11.22.jar;C:\Dev64\maven\repository\antlr\antlr\2.7.7\antlr-2.7.7.jar;C:\Dev64\maven\repository\org\jboss\jandex\2.4.2.Final\jandex-2.4.2.Final.jar;C:\Dev64\maven\repository\com\fasterxml\classmate\1.5.1\classmate-1.5.1.jar;C:\Dev64\maven\repository\org\hibernate\common\hibernate-commons-annotations\5.1.2.Final\hibernate-commons-annotations-5.1.2.Final.jar;C:\Dev64\maven\repository\org\glassfish\jaxb\jaxb-runtime\2.3.5\jaxb-runtime-2.3.5.jar;C:\Dev64\maven\repository\org\glassfish\jaxb\txw2\2.3.5\txw2-2.3.5.jar;C:\Dev64\maven\repository\com\sun\istack\istack-commons-runtime\3.0.12\istack-commons-runtime-3.0.12.jar;C:\Dev64\maven\repository\com\sun\activation\jakarta.activation\1.2.2\jakarta.activation-1.2.2.jar;C:\Dev64\maven\repository\org\springframework\data\spring-data-jpa\2.6.1\spring-data-jpa-2.6.1.jar;C:\Dev64\maven\repository\org\springframework\data\spring-data-commons\2.6.1\spring-data-commons-2.6.1.jar;C:\Dev64\maven\repository\org\springframework\spring-orm\5.3.15\spring-orm-5.3.15.jar;C:\Dev64\maven\repository\org\springframework\spring-context\5.3.15\spring-context-5.3.15.jar;C:\Dev64\maven\repository\org\springframework\spring-tx\5.3.15\spring-tx-5.3.15.jar;C:\Dev64\maven\repository\org\springframework\spring-beans\5.3.15\spring-beans-5.3.15.jar;C:\Dev64\maven\repository\org\slf4j\slf4j-api\1.7.33\slf4j-api-1.7.33.jar;C:\Dev64\maven\repository\org\springframework\spring-aspects\5.3.15\spring-aspects-5.3.15.jar;C:\Dev64\maven\repository\org\springframework\boot\spring-boot-starter-web\2.6.3\spring-boot-starter-web-2.6.3.jar;C:\Dev64\maven\repository\org\springframework\boot\spring-boot-starter\2.6.3\spring-boot-starter-2.6.3.jar;C:\Dev64\maven\repository\org\springframework\boot\spring-boot-starter-logging\2.6.3\spring-boot-starter-logging-2.6.3.jar;C:\Dev64\maven\repository\ch\qos\logback\logback-classic\1.2.10\logback-classic-1.2.10.jar;C:\Dev64\maven\repository\ch\qos\logback\logback-core\1.2.10\logback-core-1.2.10.jar;C:\Dev64\maven\repository\org\apache\logging\log4j\log4j-to-slf4j\2.17.1\log4j-to-slf4j-2.17.1.jar;C:\Dev64\maven\repository\org\apache\logging\log4j\log4j-api\2.17.1\log4j-api-2.17.1.jar;C:\Dev64\maven\repository\org\slf4j\jul-to-slf4j\1.7.33\jul-to-slf4j-1.7.33.jar;C:\Dev64\maven\repository\jakarta\annotation\jakarta.annotation-api\1.3.5\jakarta.annotation-api-1.3.5.jar;C:\Dev64\maven\repository\org\yaml\snakeyaml\1.29\snakeyaml-1.29.jar;C:\Dev64\maven\repository\org\springframework\boot\spring-boot-starter-json\2.6.3\spring-boot-starter-json-2.6.3.jar;C:\Dev64\maven\repository\com\fasterxml\jackson\core\jackson-databind\2.13.1\jackson-databind-2.13.1.jar;C:\Dev64\maven\repository\com\fasterxml\jackson\core\jackson-annotations\2.13.1\jackson-annotations-2.13.1.jar;C:\Dev64\maven\repository\com\fasterxml\jackson\core\jackson-core\2.13.1\jackson-core-2.13.1.jar;C:\Dev64\maven\repository\com\fasterxml\jackson\datatype\jackson-datatype-jdk8\2.13.1\jackson-datatype-jdk8-2.13.1.jar;C:\Dev64\maven\repository\com\fasterxml\jackson\datatype\jackson-datatype-jsr310\2.13.1\jackson-datatype-jsr310-2.13.1.jar;C:\Dev64\maven\repository\com\fasterxml\jackson\module\jackson-module-parameter-names\2.13.1\jackson-module-parameter-names-2.13.1.jar;C:\Dev64\maven\repository\org\springframework\boot\spring-boot-starter-tomcat\2.6.3\spring-boot-starter-tomcat-2.6.3.jar;C:\Dev64\maven\repository\org\apache\tomcat\embed\tomcat-embed-core\9.0.56\tomcat-embed-core-9.0.56.jar;C:\Dev64\maven\repository\org\apache\tomcat\embed\tomcat-embed-el\9.0.56\tomcat-embed-el-9.0.56.jar;C:\Dev64\maven\repository\org\apache\tomcat\embed\tomcat-embed-websocket\9.0.56\tomcat-embed-websocket-9.0.56.jar;C:\Dev64\maven\repository\org\springframework\spring-web\5.3.15\spring-web-5.3.15.jar;C:\Dev64\maven\repository\org\springframework\spring-webmvc\5.3.15\spring-webmvc-5.3.15.jar;C:\Dev64\maven\repository\org\springframework\spring-expression\5.3.15\spring-expression-5.3.15.jar;C:\Dev64\maven\repository\org\springframework\boot\spring-boot-devtools\2.6.3\spring-boot-devtools-2.6.3.jar;C:\Dev64\maven\repository\org\springframework\boot\spring-boot\2.6.3\spring-boot-2.6.3.jar;C:\Dev64\maven\repository\org\springframework\boot\spring-boot-autoconfigure\2.6.3\spring-boot-autoconfigure-2.6.3.jar;C:\Dev64\maven\repository\com\h2database\h2\1.4.200\h2-1.4.200.jar;C:\Dev64\maven\repository\org\projectlombok\lombok\1.18.22\lombok-1.18.22.jar;C:\Dev64\maven\repository\jakarta\xml\bind\jakarta.xml.bind-api\2.3.3\jakarta.xml.bind-api-2.3.3.jar;C:\Dev64\maven\repository\jakarta\activation\jakarta.activation-api\1.2.2\jakarta.activation-api-1.2.2.jar;C:\Dev64\maven\repository\org\springframework\spring-core\5.3.15\spring-core-5.3.15.jar;C:\Dev64\maven\repository\org\springframework\spring-jcl\5.3.15\spring-jcl-5.3.15.jar;C:\Dev64\maven\repository\commons-fileupload\commons-fileupload\1.2.2\commons-fileupload-1.2.2.jar;C:\Dev64\maven\repository\commons-io\commons-io\2.4\commons-io-2.4.jar;C:\Dev64\maven\repository\org\modelmapper\modelmapper\2.4.0\modelmapper-2.4.0.jar;C:\Dev64\tools\ideaIU-2021.2.2.win\lib\idea_rt.jar, hibernate.jdbc.lob.non_contextual_creation=true, java.vm.vendor=ojdkbuild, sun.arch.data.model=64, user.variant=, java.vendor.url=https://github.com/ojdkbuild, catalina.useNaming=false, user.timezone=Asia/Seoul, jakarta.persistence.sharedCache.mode=UNSPECIFIED, os.name=Windows 10, java.vm.specification.version=1.8, javax.persistence.validation.mode=AUTO, jakarta.persistence.nonJtaDataSource=HikariDataSource (HikariPool-1), user.country=KR, sun.java.launcher=SUN_STANDARD, sun.boot.library.path=C:\Dev64\tools\jdk\openjdk-1.8.0.292-1.b10.ojdkbuild\jre\bin, sun.java.command=com.dbility.apps.dev.test.DevapiApplication, spring.application.admin.enabled=true, javax.persistence.nonJtaDataSource=HikariDataSource (HikariPool-1), hibernate.transaction.jta.platform=org.hibernate.engine.transaction.jta.platform.internal.NoJtaPlatform@24eb1fa8, com.sun.management.jmxremote=, javax.persistence.sharedCache.mode=UNSPECIFIED, spring.liveBeansView.mbeanDomain=, sun.cpu.endian=little, user.home=C:\Users\ROOKIE, user.language=ko, java.specification.vendor=Oracle Corporation, java.home=C:\Dev64\tools\jdk\openjdk-1.8.0.292-1.b10.ojdkbuild\jre, file.separator=\, spring.output.ansi.enabled=always, line.separator=
, hibernate.persistenceUnitName=default, java.vm.specification.vendor=Oracle Corporation, java.specification.name=Java Platform API Specification, FILE_LOG_CHARSET=UTF-8, hibernate.transaction.coordinator_class=class org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorBuilderImpl, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.awt.headless=true, jakarta.persistence.validation.mode=AUTO, sun.boot.class.path=C:\Dev64\tools\jdk\openjdk-1.8.0.292-1.b10.ojdkbuild\jre\lib\resources.jar;C:\Dev64\tools\jdk\openjdk-1.8.0.292-1.b10.ojdkbuild\jre\lib\rt.jar;C:\Dev64\tools\jdk\openjdk-1.8.0.292-1.b10.ojdkbuild\jre\lib\sunrsasign.jar;C:\Dev64\tools\jdk\openjdk-1.8.0.292-1.b10.ojdkbuild\jre\lib\jsse.jar;C:\Dev64\tools\jdk\openjdk-1.8.0.292-1.b10.ojdkbuild\jre\lib\jce.jar;C:\Dev64\tools\jdk\openjdk-1.8.0.292-1.b10.ojdkbuild\jre\lib\charsets.jar;C:\Dev64\tools\jdk\openjdk-1.8.0.292-1.b10.ojdkbuild\jre\lib\jfr.jar;C:\Dev64\tools\jdk\openjdk-1.8.0.292-1.b10.ojdkbuild\jre\classes, hibernate.hbm2ddl.auto=create-drop, user.script=, sun.management.compiler=HotSpot 64-Bit Tiered Compilers, java.runtime.version=1.8.0_292-b10, user.name=ROOKIE, spring.jmx.enabled=true, path.separator=;, os.version=10.0, java.endorsed.dirs=C:\Dev64\tools\jdk\openjdk-1.8.0.292-1.b10.ojdkbuild\jre\lib\endorsed, java.runtime.name=OpenJDK Runtime Environment, file.encoding=UTF-8, hibernate.ejb.persistenceUnitName=default, spring.beaninfo.ignore=true, java.vm.name=OpenJDK 64-Bit Server VM, hibernate.show_sql=true, java.vendor.url.bug=https://github.com/ojdkbuild/ojdkbuild/issues, java.io.tmpdir=C:\Users\ROOKIE\AppData\Local\Temp\, com.zaxxer.hikari.pool_number=1, catalina.home=C:\Users\ROOKIE\AppData\Local\Temp\tomcat.9090.440849911146337856, java.version=1.8.0_292, hibernate.physical_naming_strategy=org.hibernate.boot.model.naming.CamelCaseToUnderscoresNamingStrategy, user.dir=C:\Dev64\workspace\devapi, os.arch=amd64, java.vm.specification.name=Java Virtual Machine Specification, PID=18840, java.awt.printerjob=sun.awt.windows.WPrinterJob, sun.os.patch.level=, CONSOLE_LOG_CHARSET=UTF-8, catalina.base=C:\Users\ROOKIE\AppData\Local\Temp\tomcat.9090.440849911146337856, hibernate.boot.CfgXmlAccessService.key=org.hibernate.boot.registry.StandardServiceRegistryBuilder$1@720eca72, java.library.path=C:\Dev64\tools\jdk\openjdk-1.8.0.292-1.b10.ojdkbuild\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\;C:\Program Files\Microsoft SQL Server\120\Tools\Binn\;C:\Program Files\Microsoft SQL Server\120\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\ManagementStudio\;C:\Program Files (x86)\Microsoft SQL Server\120\DTS\Binn\;C:\Program Files\TortoiseSVN\bin;C:\Program Files\TortoiseGit\bin;C:\Program Files\Git\cmd;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\IBM\Client Access\Emulator;C:\Program Files (x86)\IBM\Client Access\Shared;C:\Program Files (x86)\IBM\Client Access\;C:\Program Files\nodejs\;C:\Python\Python39\Scripts\;C:\Python\Python39\;C:\Users\ROOKIE\AppData\Local\Microsoft\WindowsApps;C:\Dev64\tools\jdk\jdk170\bin;C:\Users\ROOKIE\AppData\Roaming\npm;C:\Program Files\OpenSSL-Win64\bin;;., java.vendor=ojdkbuild, java.vm.info=mixed mode, java.vm.version=25.292-b10, hibernate.bytecode.use_reflection_optimizer=false, java.rmi.server.randomIDs=true, sun.io.unicode.encoding=UnicodeLittle, hibernate.archive.scanner=org.hibernate.boot.archive.scan.internal.DisabledScanner, java.ext.dirs=C:\Dev64\tools\jdk\openjdk-1.8.0.292-1.b10.ojdkbuild\jre\lib\ext;C:\Windows\Sun\Java\lib\ext, hibernate.connection.datasource=HikariDataSource (HikariPool-1), CONSOLE_LOG_PATTERN=%d{HH:mm:ss.SSS} [%thread] %-5level %40.40logger{36} %4.4L - %msg%n%ex{full, DISPLAY_EX_EVAL}, java.class.version=52.0}
13:26:19.282 [restartedMain] DEBUG o.h.secure.spi.JaccIntegrator 84 - Skipping JACC integration as it was not enabled
13:26:19.283 [restartedMain] DEBUG o.h.internal.SessionFactoryImpl 316 - Instantiated session factory
13:26:19.283 [restartedMain] DEBUG o.h.type.spi.TypeConfiguration$Scope 154 - Scoping TypeConfiguration [org.hibernate.type.spi.TypeConfiguration@793ad472] to SessionFactoryImpl [org.hibernate.internal.SessionFactoryImpl@498808b]
13:26:19.331 [restartedMain] DEBUG o.h.b.internal.ClassLoaderAccessImpl 60 - Not known whether passed class name [com.dbility.apps.dev.test.RoomsEntity] is safe
13:26:19.331 [restartedMain] DEBUG o.h.b.internal.ClassLoaderAccessImpl 62 - No temp ClassLoader provided; using live ClassLoader for loading potentially unsafe class : com.dbility.apps.dev.test.RoomsEntity
13:26:19.499 [restartedMain] DEBUG o.h.p.entity.AbstractEntityPersister 4002 - Static SQL for entity: com.dbility.apps.dev.test.RoomsEntity
13:26:19.499 [restartedMain] DEBUG o.h.p.entity.AbstractEntityPersister 4007 - Version select: select id from rooms where id =?
13:26:19.500 [restartedMain] DEBUG o.h.p.entity.AbstractEntityPersister 4010 - Snapshot select: select roomsentit_.id, roomsentit_.content as content2_0_, roomsentit_.file_name as file_nam3_0_, roomsentit_.file_type as file_typ4_0_, roomsentit_.inform_count as inform_c5_0_, roomsentit_.price as price6_0_, roomsentit_.title as title7_0_ from rooms roomsentit_ where roomsentit_.id=?
13:26:19.500 [restartedMain] DEBUG o.h.p.entity.AbstractEntityPersister 394 - Insert 0: insert into rooms (content, file_name, file_type, inform_count, price, title, id) values (?, ?, ?, ?, ?, ?, ?)
13:26:19.500 [restartedMain] DEBUG o.h.p.entity.AbstractEntityPersister 394 - Update 0: update rooms set content=?, file_name=?, file_type=?, inform_count=?, price=?, title=? where id=?
13:26:19.500 [restartedMain] DEBUG o.h.p.entity.AbstractEntityPersister 394 - Delete 0: delete from rooms where id=?
13:26:19.528 [restartedMain] DEBUG o.h.l.p.b.i.spaces.QuerySpacesImpl 174 - Adding QuerySpace : uid = <gen:0> -> org.hibernate.loader.plan.build.internal.spaces.EntityQuerySpaceImpl@375e8323]
13:26:19.530 [restartedMain] DEBUG o.h.p.w.spi.MetamodelGraphWalker 146 - Visiting attribute path : content
13:26:19.530 [restartedMain] DEBUG o.h.p.w.spi.MetamodelGraphWalker 146 - Visiting attribute path : file_name
13:26:19.530 [restartedMain] DEBUG o.h.p.w.spi.MetamodelGraphWalker 146 - Visiting attribute path : file_type
13:26:19.530 [restartedMain] DEBUG o.h.p.w.spi.MetamodelGraphWalker 146 - Visiting attribute path : inform_count
13:26:19.530 [restartedMain] DEBUG o.h.p.w.spi.MetamodelGraphWalker 146 - Visiting attribute path : price
13:26:19.530 [restartedMain] DEBUG o.h.p.w.spi.MetamodelGraphWalker 146 - Visiting attribute path : title
13:26:19.531 [restartedMain] DEBUG lanBuildingAssociationVisitationStrategy 160 - Building LoadPlan...
13:26:19.541 [restartedMain] DEBUG h.l.p.e.i.LoadQueryJoinAndFetchProcessor 102 - processing queryspace <gen:0>
13:26:19.545 [restartedMain] DEBUG o.h.l.p.b.spi.LoadPlanTreePrinter 55 - LoadPlan(entity=com.dbility.apps.dev.test.RoomsEntity)
- Returns
- EntityReturnImpl(entity=com.dbility.apps.dev.test.RoomsEntity, querySpaceUid=<gen:0>, path=com.dbility.apps.dev.test.RoomsEntity)
- QuerySpaces
- EntityQuerySpaceImpl(uid=<gen:0>, entity=com.dbility.apps.dev.test.RoomsEntity)
- SQL table alias mapping - roomsentit0_
- alias suffix - 0_
- suffixed key columns - {id1_0_0_}
13:26:19.547 [restartedMain] DEBUG o.h.loader.entity.plan.EntityLoader 129 - Static select for entity com.dbility.apps.dev.test.RoomsEntity [NONE]: select roomsentit0_.id as id1_0_0_, roomsentit0_.content as content2_0_0_, roomsentit0_.file_name as file_nam3_0_0_, roomsentit0_.file_type as file_typ4_0_0_, roomsentit0_.inform_count as inform_c5_0_0_, roomsentit0_.price as price6_0_0_, roomsentit0_.title as title7_0_0_ from rooms roomsentit0_ where roomsentit0_.id=?
13:26:19.579 [restartedMain] DEBUG org.hibernate.SQL 144 -
drop table if exists rooms CASCADE
Hibernate:
drop table if exists rooms CASCADE
13:26:19.583 [restartedMain] DEBUG org.hibernate.SQL 144 -
drop sequence if exists hibernate_sequence
Hibernate:
drop sequence if exists hibernate_sequence
13:26:19.586 [restartedMain] DEBUG org.hibernate.SQL 144 - create sequence hibernate_sequence start with 1 increment by 1
Hibernate: create sequence hibernate_sequence start with 1 increment by 1
13:26:19.588 [restartedMain] DEBUG org.hibernate.SQL 144 -
create table rooms (
id INT not null,
content VARCHAR(2000),
file_name VARCHAR(250),
file_type VARCHAR(20),
inform_count INT default 0,
price BIGINT default 0,
title VARCHAR(100),
primary key (id)
)
Hibernate:
create table rooms (
id INT not null,
content VARCHAR(2000),
file_name VARCHAR(250),
file_type VARCHAR(20),
inform_count INT default 0,
price BIGINT default 0,
title VARCHAR(100),
primary key (id)
)
13:26:19.595 [restartedMain] INFO o.h.e.t.j.p.i.JtaPlatformInitiator 52 - HHH000490: Using JtaPlatform implementation: [org.hibernate.engine.transaction.jta.platform.internal.NoJtaPlatform]
13:26:19.596 [restartedMain] DEBUG o.h.query.spi.NamedQueryRepository 171 - Checking 0 named HQL queries
13:26:19.596 [restartedMain] DEBUG o.h.query.spi.NamedQueryRepository 185 - Checking 0 named SQL queries
13:26:19.599 [restartedMain] DEBUG .h.s.i.SessionFactoryServiceRegistryImpl 92 - EventListenerRegistry access via ServiceRegistry is deprecated. Use `sessionFactory.getEventEngine().getListenerRegistry()` instead
13:26:19.603 [restartedMain] DEBUG o.h.internal.SessionFactoryRegistry 51 - Initializing SessionFactoryRegistry : org.hibernate.internal.SessionFactoryRegistry@1caee744
13:26:19.604 [restartedMain] DEBUG o.h.internal.SessionFactoryRegistry 73 - Registering SessionFactory: 2fce7fff-f3d6-499c-bae0-b71bcca1e30c (<unnamed>)
13:26:19.604 [restartedMain] DEBUG o.h.internal.SessionFactoryRegistry 80 - Not binding SessionFactory to JNDI, no JNDI name configured
13:26:19.604 [restartedMain] INFO j.LocalContainerEntityManagerFactoryBean 437 - Initialized JPA EntityManagerFactory for persistence unit 'default'
13:26:19.720 [restartedMain] DEBUG o.h.s.internal.StatisticsInitiator 101 - Statistics initialized [enabled=false]
13:26:20.116 [restartedMain] INFO o.s.b.d.a.OptionalLiveReloadServer 58 - LiveReload server is running on port 35729
13:26:20.142 [restartedMain] INFO o.s.b.w.e.tomcat.TomcatWebServer 220 - Tomcat started on port(s): 9090 (http) with context path ''
13:26:20.150 [restartedMain] INFO c.d.apps.dev.test.DevapiApplication 61 - Started DevapiApplication in 3.573 seconds (JVM running for 5.297)
다음 그림1과 같이 httpClient로 실행을 하면 결과를 확인 할 수 있다.
http://localhost:9090/findall
HTTP/1.1 200
Vary: Origin
Vary: Access-Control-Request-Method
Vary: Access-Control-Request-Headers
Content-Type: application/json
Transfer-Encoding: chunked
Date: Wed, 23 Feb 2022 04:25:36 GMT
Keep-Alive: timeout=60
Connection: keep-alive
[
{
"title": "해운대LCT",
"content": "가운데 라인 로얄층으로 위아래 ☀️, 자연 공기청정",
"price": "3000000000",
"inform_count": "0",
"file_name": "images/room0.jpg",
"file_type": "image/jpeg"
},
{
"title": "대장동 헐값분양아파트",
"content": "아파트는 싸게 받았는데, 곽XX때문에 퇴직금 50억이 날아가나?!",
"price": "1500000000",
"inform_count": "0",
"file_name": "images/room1.jpg",
"file_type": "image/jpeg"
},
{
"title": "내곡동 오노키오랜드",
"content": "내곡동1334평. 기억에 겸손한 분만! 애완동물 불가능 🐶",
"price": "3400000000",
"inform_count": "0",
"file_name": "images/room2.jpg",
"file_type": "image/jpeg"
}
]
Response file saved.
> 2022-02-23T132536.200.json
Response code: 200; Time: 238ms; Content length: 491 bytes
그림 2는 react app 실행 결과다.
실행 시 Spring Console log
13:23:13.263 [http-nio-9090-exec-5] INFO c.d.apps.dev.test.RoomsServiceImpl 26 - 2022-02-23T13:23:13.263
13:23:13.264 [http-nio-9090-exec-5] DEBUG o.h.e.t.internal.TransactionImpl 53 - On TransactionImpl creation, JpaCompliance#isJpaTransactionComplianceEnabled == false
13:23:13.264 [http-nio-9090-exec-5] DEBUG o.h.e.t.internal.TransactionImpl 81 - begin
13:23:13.265 [http-nio-9090-exec-5] DEBUG o.h.q.c.internal.CriteriaQueryImpl 303 - Rendered criteria query -> select generatedAlias0 from RoomsEntity as generatedAlias0
13:23:13.265 [http-nio-9090-exec-5] DEBUG org.hibernate.SQL 144 -
select
roomsentit0_.id as id1_0_,
roomsentit0_.content as content2_0_,
roomsentit0_.file_name as file_nam3_0_,
roomsentit0_.file_type as file_typ4_0_,
roomsentit0_.inform_count as inform_c5_0_,
roomsentit0_.price as price6_0_,
roomsentit0_.title as title7_0_
from
rooms roomsentit0_
Hibernate:
select
roomsentit0_.id as id1_0_,
roomsentit0_.content as content2_0_,
roomsentit0_.file_name as file_nam3_0_,
roomsentit0_.file_type as file_typ4_0_,
roomsentit0_.inform_count as inform_c5_0_,
roomsentit0_.price as price6_0_,
roomsentit0_.title as title7_0_
from
rooms roomsentit0_
13:23:13.266 [http-nio-9090-exec-5] DEBUG org.hibernate.loader.Loader 384 - Result set row: 0
13:23:13.266 [http-nio-9090-exec-5] TRACE o.h.t.descriptor.sql.BasicExtractor 60 - extracted value ([id1_0_] : [INTEGER]) - [1]
13:23:13.266 [http-nio-9090-exec-5] DEBUG org.hibernate.loader.Loader 1595 - Result row: EntityKey[com.dbility.apps.dev.test.RoomsEntity#1]
13:23:13.267 [http-nio-9090-exec-5] TRACE o.h.t.descriptor.sql.BasicExtractor 60 - extracted value ([content2_0_] : [VARCHAR]) - [가운데 라인 로얄층으로 위아래 ☀️, 자연 공기청정]
13:23:13.267 [http-nio-9090-exec-5] TRACE o.h.t.descriptor.sql.BasicExtractor 60 - extracted value ([file_nam3_0_] : [VARCHAR]) - [images/room0.jpg]
13:23:13.267 [http-nio-9090-exec-5] TRACE o.h.t.descriptor.sql.BasicExtractor 60 - extracted value ([file_typ4_0_] : [VARCHAR]) - [image/jpeg]
13:23:13.268 [http-nio-9090-exec-5] TRACE o.h.t.descriptor.sql.BasicExtractor 60 - extracted value ([inform_c5_0_] : [INTEGER]) - [0]
13:23:13.268 [http-nio-9090-exec-5] TRACE o.h.t.descriptor.sql.BasicExtractor 60 - extracted value ([price6_0_] : [BIGINT]) - [3000000000]
13:23:13.268 [http-nio-9090-exec-5] TRACE o.h.t.descriptor.sql.BasicExtractor 60 - extracted value ([title7_0_] : [VARCHAR]) - [해운대LCT]
13:23:13.269 [http-nio-9090-exec-5] DEBUG org.hibernate.loader.Loader 384 - Result set row: 1
13:23:13.269 [http-nio-9090-exec-5] TRACE o.h.t.descriptor.sql.BasicExtractor 60 - extracted value ([id1_0_] : [INTEGER]) - [2]
13:23:13.269 [http-nio-9090-exec-5] DEBUG org.hibernate.loader.Loader 1595 - Result row: EntityKey[com.dbility.apps.dev.test.RoomsEntity#2]
13:23:13.270 [http-nio-9090-exec-5] TRACE o.h.t.descriptor.sql.BasicExtractor 60 - extracted value ([content2_0_] : [VARCHAR]) - [아파트는 싸게 받았는데, 곽XX때문에 퇴직금 50억이 날아가나?!]
13:23:13.270 [http-nio-9090-exec-5] TRACE o.h.t.descriptor.sql.BasicExtractor 60 - extracted value ([file_nam3_0_] : [VARCHAR]) - [images/room1.jpg]
13:23:13.270 [http-nio-9090-exec-5] TRACE o.h.t.descriptor.sql.BasicExtractor 60 - extracted value ([file_typ4_0_] : [VARCHAR]) - [image/jpeg]
13:23:13.271 [http-nio-9090-exec-5] TRACE o.h.t.descriptor.sql.BasicExtractor 60 - extracted value ([inform_c5_0_] : [INTEGER]) - [0]
13:23:13.271 [http-nio-9090-exec-5] TRACE o.h.t.descriptor.sql.BasicExtractor 60 - extracted value ([price6_0_] : [BIGINT]) - [1500000000]
13:23:13.271 [http-nio-9090-exec-5] TRACE o.h.t.descriptor.sql.BasicExtractor 60 - extracted value ([title7_0_] : [VARCHAR]) - [대장동 헐값분양아파트]
13:23:13.272 [http-nio-9090-exec-5] DEBUG org.hibernate.loader.Loader 384 - Result set row: 2
13:23:13.272 [http-nio-9090-exec-5] TRACE o.h.t.descriptor.sql.BasicExtractor 60 - extracted value ([id1_0_] : [INTEGER]) - [3]
13:23:13.272 [http-nio-9090-exec-5] DEBUG org.hibernate.loader.Loader 1595 - Result row: EntityKey[com.dbility.apps.dev.test.RoomsEntity#3]
13:23:13.273 [http-nio-9090-exec-5] TRACE o.h.t.descriptor.sql.BasicExtractor 60 - extracted value ([content2_0_] : [VARCHAR]) - [내곡동1334평. 기억에 겸손한 분만! 애완동물 불가능 🐶]
13:23:13.274 [http-nio-9090-exec-5] TRACE o.h.t.descriptor.sql.BasicExtractor 60 - extracted value ([file_nam3_0_] : [VARCHAR]) - [images/room2.jpg]
13:23:13.274 [http-nio-9090-exec-5] TRACE o.h.t.descriptor.sql.BasicExtractor 60 - extracted value ([file_typ4_0_] : [VARCHAR]) - [image/jpeg]
13:23:13.275 [http-nio-9090-exec-5] TRACE o.h.t.descriptor.sql.BasicExtractor 60 - extracted value ([inform_c5_0_] : [INTEGER]) - [0]
13:23:13.276 [http-nio-9090-exec-5] TRACE o.h.t.descriptor.sql.BasicExtractor 60 - extracted value ([price6_0_] : [BIGINT]) - [3400000000]
13:23:13.277 [http-nio-9090-exec-5] TRACE o.h.t.descriptor.sql.BasicExtractor 60 - extracted value ([title7_0_] : [VARCHAR]) - [내곡동 오노키오랜드]
13:23:13.278 [http-nio-9090-exec-5] DEBUG o.h.engine.internal.TwoPhaseLoad 171 - Resolving attributes for [com.dbility.apps.dev.test.RoomsEntity#1]
13:23:13.278 [http-nio-9090-exec-5] DEBUG o.h.engine.internal.TwoPhaseLoad 184 - Processing attribute `content` : value = 가운데 라인 로얄층으로 위아래 ☀️, 자연 공기청정
13:23:13.278 [http-nio-9090-exec-5] DEBUG o.h.engine.internal.TwoPhaseLoad 215 - Attribute (`content`) - enhanced for lazy-loading? - false
13:23:13.279 [http-nio-9090-exec-5] DEBUG o.h.engine.internal.TwoPhaseLoad 184 - Processing attribute `file_name` : value = images/room0.jpg
13:23:13.279 [http-nio-9090-exec-5] DEBUG o.h.engine.internal.TwoPhaseLoad 215 - Attribute (`file_name`) - enhanced for lazy-loading? - false
13:23:13.279 [http-nio-9090-exec-5] DEBUG o.h.engine.internal.TwoPhaseLoad 184 - Processing attribute `file_type` : value = image/jpeg
13:23:13.279 [http-nio-9090-exec-5] DEBUG o.h.engine.internal.TwoPhaseLoad 215 - Attribute (`file_type`) - enhanced for lazy-loading? - false
13:23:13.280 [http-nio-9090-exec-5] DEBUG o.h.engine.internal.TwoPhaseLoad 184 - Processing attribute `inform_count` : value = 0
13:23:13.280 [http-nio-9090-exec-5] DEBUG o.h.engine.internal.TwoPhaseLoad 215 - Attribute (`inform_count`) - enhanced for lazy-loading? - false
13:23:13.280 [http-nio-9090-exec-5] DEBUG o.h.engine.internal.TwoPhaseLoad 184 - Processing attribute `price` : value = 3000000000
13:23:13.280 [http-nio-9090-exec-5] DEBUG o.h.engine.internal.TwoPhaseLoad 215 - Attribute (`price`) - enhanced for lazy-loading? - false
13:23:13.280 [http-nio-9090-exec-5] DEBUG o.h.engine.internal.TwoPhaseLoad 184 - Processing attribute `title` : value = 해운대LCT
13:23:13.281 [http-nio-9090-exec-5] DEBUG o.h.engine.internal.TwoPhaseLoad 215 - Attribute (`title`) - enhanced for lazy-loading? - false
13:23:13.281 [http-nio-9090-exec-5] DEBUG o.h.engine.internal.TwoPhaseLoad 352 - Done materializing entity [com.dbility.apps.dev.test.RoomsEntity#1]
13:23:13.281 [http-nio-9090-exec-5] DEBUG o.h.engine.internal.TwoPhaseLoad 171 - Resolving attributes for [com.dbility.apps.dev.test.RoomsEntity#2]
13:23:13.281 [http-nio-9090-exec-5] DEBUG o.h.engine.internal.TwoPhaseLoad 184 - Processing attribute `content` : value = 아파트는 싸게 받았는데, 곽XX때문에 퇴직금 50억이 날아가나?!
13:23:13.282 [http-nio-9090-exec-5] DEBUG o.h.engine.internal.TwoPhaseLoad 215 - Attribute (`content`) - enhanced for lazy-loading? - false
13:23:13.282 [http-nio-9090-exec-5] DEBUG o.h.engine.internal.TwoPhaseLoad 184 - Processing attribute `file_name` : value = images/room1.jpg
13:23:13.282 [http-nio-9090-exec-5] DEBUG o.h.engine.internal.TwoPhaseLoad 215 - Attribute (`file_name`) - enhanced for lazy-loading? - false
13:23:13.282 [http-nio-9090-exec-5] DEBUG o.h.engine.internal.TwoPhaseLoad 184 - Processing attribute `file_type` : value = image/jpeg
13:23:13.282 [http-nio-9090-exec-5] DEBUG o.h.engine.internal.TwoPhaseLoad 215 - Attribute (`file_type`) - enhanced for lazy-loading? - false
13:23:13.283 [http-nio-9090-exec-5] DEBUG o.h.engine.internal.TwoPhaseLoad 184 - Processing attribute `inform_count` : value = 0
13:23:13.283 [http-nio-9090-exec-5] DEBUG o.h.engine.internal.TwoPhaseLoad 215 - Attribute (`inform_count`) - enhanced for lazy-loading? - false
13:23:13.283 [http-nio-9090-exec-5] DEBUG o.h.engine.internal.TwoPhaseLoad 184 - Processing attribute `price` : value = 1500000000
13:23:13.283 [http-nio-9090-exec-5] DEBUG o.h.engine.internal.TwoPhaseLoad 215 - Attribute (`price`) - enhanced for lazy-loading? - false
13:23:13.283 [http-nio-9090-exec-5] DEBUG o.h.engine.internal.TwoPhaseLoad 184 - Processing attribute `title` : value = 대장동 헐값분양아파트
13:23:13.283 [http-nio-9090-exec-5] DEBUG o.h.engine.internal.TwoPhaseLoad 215 - Attribute (`title`) - enhanced for lazy-loading? - false
13:23:13.284 [http-nio-9090-exec-5] DEBUG o.h.engine.internal.TwoPhaseLoad 352 - Done materializing entity [com.dbility.apps.dev.test.RoomsEntity#2]
13:23:13.284 [http-nio-9090-exec-5] DEBUG o.h.engine.internal.TwoPhaseLoad 171 - Resolving attributes for [com.dbility.apps.dev.test.RoomsEntity#3]
13:23:13.284 [http-nio-9090-exec-5] DEBUG o.h.engine.internal.TwoPhaseLoad 184 - Processing attribute `content` : value = 내곡동1334평. 기억에 겸손한 분만! 애완동물 불가능 🐶
13:23:13.284 [http-nio-9090-exec-5] DEBUG o.h.engine.internal.TwoPhaseLoad 215 - Attribute (`content`) - enhanced for lazy-loading? - false
13:23:13.284 [http-nio-9090-exec-5] DEBUG o.h.engine.internal.TwoPhaseLoad 184 - Processing attribute `file_name` : value = images/room2.jpg
13:23:13.285 [http-nio-9090-exec-5] DEBUG o.h.engine.internal.TwoPhaseLoad 215 - Attribute (`file_name`) - enhanced for lazy-loading? - false
13:23:13.285 [http-nio-9090-exec-5] DEBUG o.h.engine.internal.TwoPhaseLoad 184 - Processing attribute `file_type` : value = image/jpeg
13:23:13.285 [http-nio-9090-exec-5] DEBUG o.h.engine.internal.TwoPhaseLoad 215 - Attribute (`file_type`) - enhanced for lazy-loading? - false
13:23:13.286 [http-nio-9090-exec-5] DEBUG o.h.engine.internal.TwoPhaseLoad 184 - Processing attribute `inform_count` : value = 0
13:23:13.286 [http-nio-9090-exec-5] DEBUG o.h.engine.internal.TwoPhaseLoad 215 - Attribute (`inform_count`) - enhanced for lazy-loading? - false
13:23:13.286 [http-nio-9090-exec-5] DEBUG o.h.engine.internal.TwoPhaseLoad 184 - Processing attribute `price` : value = 3400000000
13:23:13.286 [http-nio-9090-exec-5] DEBUG o.h.engine.internal.TwoPhaseLoad 215 - Attribute (`price`) - enhanced for lazy-loading? - false
13:23:13.287 [http-nio-9090-exec-5] DEBUG o.h.engine.internal.TwoPhaseLoad 184 - Processing attribute `title` : value = 내곡동 오노키오랜드
13:23:13.287 [http-nio-9090-exec-5] DEBUG o.h.engine.internal.TwoPhaseLoad 215 - Attribute (`title`) - enhanced for lazy-loading? - false
13:23:13.287 [http-nio-9090-exec-5] DEBUG o.h.engine.internal.TwoPhaseLoad 352 - Done materializing entity [com.dbility.apps.dev.test.RoomsEntity#3]
13:23:13.288 [http-nio-9090-exec-5] DEBUG o.h.e.t.internal.TransactionImpl 98 - committing
'java > spring boot' 카테고리의 다른 글
spring boot embedded tomcat docroot change (0) | 2022.02.24 |
---|---|
maven Blocked mirror for repositories~ (0) | 2022.02.19 |
spring boot rest api cors (0) | 2022.02.17 |