spring data jpa study code

Notice

Recent Posts

Recent Comments

Link

« 2024/11 »
일	월	화	수	목	금	토
					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

Tags more

Archives

Today

Total

관리 메뉴

DBILITY

spring data jpa study code 본문

java/spring boot

spring data jpa study code

DBILITY 2022. 2. 18. 10:57

이거 보고 광고 한번 안 누른 이는 삼대가 재수 없을지어다!ㅋㅋ

누르고 복권을 사라!

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

공유하기 링크

페이스북
카카오스토리
트위터

'java/spring boot' Related Articles

Comments

DBILITY

spring data jpa study code 본문

spring data jpa study code

'java > spring boot' 카테고리의 다른 글

티스토리툴바