h2 console 에 테이블이 보이질 않습니다.
미해결
실전! Querydsl
application.yml spring: datasource: url: jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 username: sa password: driver-class-name: org.h2.Driver jpa: hibernate: ddl-auto: create properties: hibernate: # show_sql: true format_aql: true default_batch_fetch_size: 100 logging: level: org.hibernate.SQL: debug org.hibernate.type: trace build.gradle buildscript { dependencies { classpath("gradle.plugin.com.ewerk.gradle.plugins:querydsl-plugin:1.0.10") } } plugins {id 'org.springframework.boot' version '2.4.1' id 'io.spring.dependency-management' version '1.0.10.RELEASE' id 'java' } apply plugin: 'io.spring.dependency-management' apply plugin: "com.ewerk.gradle.plugins.querydsl" group = 'jpabook' version = '1.8.1' sourceCompatibility = '11' configurations { compileOnly { extendsFrom annotationProcessor } } repositories { mavenCentral() } dependencies { implementation 'org.springframework.boot:spring-boot-starter-data-jpa' implementation 'org.springframework.boot:spring-boot-starter-thymeleaf' implementation 'org.springframework.boot:spring-boot-starter-web' implementation 'org.springframework.boot:spring-boot-devtools' implementation 'com.github.gavlyukovskiy:p6spy-spring-boot-starter:1.8.1' implementation 'org.springframework.boot:spring-boot-starter-validation' implementation 'com.fasterxml.jackson.datatype:jackson-datatype-hibernate5' testImplementation 'org.projectlombok:lombok:1.18.24' testImplementation 'org.projectlombok:lombok:1.18.24' compileOnly 'org.projectlombok:lombok' runtimeOnly 'com.h2database:h2' annotationProcessor 'org.projectlombok:lombok' testImplementation 'org.springframework.boot:spring-boot-starter-test' testImplementation 'org.assertj:assertj-core:3.23.1' //JUnit4 추가 testImplementation("org.junit.vintage:junit-vintage-engine") { exclude group: "org.hamcrest", module: "hamcrest-core" } //querydsl 추가 implementation 'com.querydsl:querydsl-jpa' //querydsl 추가 implementation 'com.querydsl:querydsl-apt' } //querydsl 추가 //def querydslDir = 'src/main/generated' def querydslDir = "$buildDir/generated/querydsl" querydsl { library = "com.querydsl:querydsl-apt" jpa = true querydslSourcesDir = querydslDir } sourceSets { main { java { srcDirs = ['src/main/java', querydslDir] } } } compileQuerydsl{ options.annotationProcessorPath = configurations.querydsl } configurations { querydsl.extendsFrom compileClasspath } tasks.named('test') { useJUnitPlatform() } 로그입니다. 2023-01-02 23:24:13.584 INFO 1432 --- [ restartedMain] jpabook.jpashop.JpashopApplication : Starting JpashopApplication using Java 11.0.15 on DESKTOP-I7K9HJ3 with PID 1432 (C:\Users\kom12\OneDrive\Desktop\IJ\jpashop1-practice\out\production\classes started by kom12 in C:\Users\kom12\OneDrive\Desktop\IJ\jpashop1-practice) 2023-01-02 23:24:13.588 INFO 1432 --- [ restartedMain] jpabook.jpashop.JpashopApplication : No active profile set, falling back to default profiles: default 2023-01-02 23:24:13.664 INFO 1432 --- [ restartedMain] .e.DevToolsPropertyDefaultsPostProcessor : Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable 2023-01-02 23:24:13.664 INFO 1432 --- [ restartedMain] .e.DevToolsPropertyDefaultsPostProcessor : For additional web related logging consider setting the 'logging.level.web' property to 'DEBUG' 2023-01-02 23:24:14.910 INFO 1432 --- [ restartedMain] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode. 2023-01-02 23:24:15.052 INFO 1432 --- [ restartedMain] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 115 ms. Found 1 JPA repository interfaces. 2023-01-02 23:24:16.174 INFO 1432 --- [ restartedMain] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port(s): 8080 (http) 2023-01-02 23:24:16.191 INFO 1432 --- [ restartedMain] o.apache.catalina.core.StandardService : Starting service [Tomcat] 2023-01-02 23:24:16.192 INFO 1432 --- [ restartedMain] org.apache.catalina.core.StandardEngine : Starting Servlet engine: [Apache Tomcat/9.0.41] 2023-01-02 23:24:16.321 INFO 1432 --- [ restartedMain] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring embedded WebApplicationContext 2023-01-02 23:24:16.321 INFO 1432 --- [ restartedMain] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 2656 ms 2023-01-02 23:24:16.476 INFO 1432 --- [ restartedMain] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting... 2023-01-02 23:24:16.728 INFO 1432 --- [ restartedMain] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed. 2023-01-02 23:24:16.740 INFO 1432 --- [ restartedMain] o.s.b.a.h2.H2ConsoleAutoConfiguration : H2 console available at '/h2-console'. Database available at 'jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08' 2023-01-02 23:24:16.919 INFO 1432 --- [ restartedMain] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default] 2023-01-02 23:24:16.996 INFO 1432 --- [ restartedMain] org.hibernate.Version : HHH000412: Hibernate ORM core version 5.4.25.Final 2023-01-02 23:24:17.182 INFO 1432 --- [ restartedMain] o.hibernate.annotations.common.Version : HCANN000001: Hibernate Commons Annotations {5.1.2.Final} 2023-01-02 23:24:17.398 INFO 1432 --- [ restartedMain] org.hibernate.dialect.Dialect : HHH000400: Using dialect: org.hibernate.dialect.H2Dialect 2023-01-02 23:24:18.411 INFO 1432 --- [ restartedMain] p6spy : #1672669458411 | took 1ms | statement | connection 3| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 drop table if exists category CASCADE drop table if exists category CASCADE ; 2023-01-02 23:24:18.411 INFO 1432 --- [ restartedMain] p6spy : #1672669458411 | took 0ms | statement | connection 3| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 drop table if exists category_item CASCADE drop table if exists category_item CASCADE ; 2023-01-02 23:24:18.411 INFO 1432 --- [ restartedMain] p6spy : #1672669458411 | took 0ms | statement | connection 3| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 drop table if exists delivery CASCADE drop table if exists delivery CASCADE ; 2023-01-02 23:24:18.411 INFO 1432 --- [ restartedMain] p6spy : #1672669458411 | took 0ms | statement | connection 3| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 drop table if exists item CASCADE drop table if exists item CASCADE ; 2023-01-02 23:24:18.412 INFO 1432 --- [ restartedMain] p6spy : #1672669458412 | took 0ms | statement | connection 3| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 drop table if exists member CASCADE drop table if exists member CASCADE ; 2023-01-02 23:24:18.412 INFO 1432 --- [ restartedMain] p6spy : #1672669458412 | took 0ms | statement | connection 3| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 drop table if exists order_item CASCADE drop table if exists order_item CASCADE ; 2023-01-02 23:24:18.412 INFO 1432 --- [ restartedMain] p6spy : #1672669458412 | took 0ms | statement | connection 3| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 drop table if exists orders CASCADE drop table if exists orders CASCADE ; 2023-01-02 23:24:18.412 INFO 1432 --- [ restartedMain] p6spy : #1672669458412 | took 0ms | statement | connection 3| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 drop sequence if exists hibernate_sequence drop sequence if exists hibernate_sequence; 2023-01-02 23:24:18.416 INFO 1432 --- [ restartedMain] p6spy : #1672669458416 | took 1ms | statement | connection 4| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 create sequence hibernate_sequence start with 1 increment by 1 create sequence hibernate_sequence start with 1 increment by 1; 2023-01-02 23:24:18.420 INFO 1432 --- [ restartedMain] p6spy : #1672669458420 | took 4ms | statement | connection 4| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 create table category (category_id bigint not null, name varchar(255), parent_id bigint, primary key (category_id)) create table category (category_id bigint not null, name varchar(255), parent_id bigint, primary key (category_id)); 2023-01-02 23:24:18.421 INFO 1432 --- [ restartedMain] p6spy : #1672669458421 | took 0ms | statement | connection 4| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 create table category_item (category_id bigint not null, item_id bigint not null) create table category_item (category_id bigint not null, item_id bigint not null); 2023-01-02 23:24:18.421 INFO 1432 --- [ restartedMain] p6spy : #1672669458421 | took 0ms | statement | connection 4| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 create table delivery (delivery_id bigint not null, city varchar(255), street varchar(255), zipcode varchar(255), status varchar(255), primary key (delivery_id)) create table delivery (delivery_id bigint not null, city varchar(255), street varchar(255), zipcode varchar(255), status varchar(255), primary key (delivery_id)); 2023-01-02 23:24:18.422 INFO 1432 --- [ restartedMain] p6spy : #1672669458422 | took 0ms | statement | connection 4| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 create table item (dtype varchar(31) not null, item_id bigint not null, name varchar(255), price integer not null, stock_quantity integer not null, artist varchar(255), etc varchar(255), author varchar(255), isbn varchar(255), actor varchar(255), director varchar(255), primary key (item_id)) create table item (dtype varchar(31) not null, item_id bigint not null, name varchar(255), price integer not null, stock_quantity integer not null, artist varchar(255), etc varchar(255), author varchar(255), isbn varchar(255), actor varchar(255), director varchar(255), primary key (item_id)); 2023-01-02 23:24:18.423 INFO 1432 --- [ restartedMain] p6spy : #1672669458423 | took 1ms | statement | connection 4| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 create table member (member_id bigint not null, city varchar(255), street varchar(255), zipcode varchar(255), name varchar(255), primary key (member_id)) create table member (member_id bigint not null, city varchar(255), street varchar(255), zipcode varchar(255), name varchar(255), primary key (member_id)); 2023-01-02 23:24:18.424 INFO 1432 --- [ restartedMain] p6spy : #1672669458424 | took 0ms | statement | connection 4| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 create table order_item (order_item_id bigint not null, count integer not null, order_price integer not null, item_id bigint, order_id bigint, primary key (order_item_id)) create table order_item (order_item_id bigint not null, count integer not null, order_price integer not null, item_id bigint, order_id bigint, primary key (order_item_id)); 2023-01-02 23:24:18.425 INFO 1432 --- [ restartedMain] p6spy : #1672669458425 | took 0ms | statement | connection 4| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 create table orders (order_id bigint not null, order_date timestamp, status varchar(255), delivery_id bigint, member_id bigint, primary key (order_id)) create table orders (order_id bigint not null, order_date timestamp, status varchar(255), delivery_id bigint, member_id bigint, primary key (order_id)); 2023-01-02 23:24:18.432 INFO 1432 --- [ restartedMain] p6spy : #1672669458432 | took 6ms | statement | connection 4| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 alter table category add constraint FK2y94svpmqttx80mshyny85wqr foreign key (parent_id) references category alter table category add constraint FK2y94svpmqttx80mshyny85wqr foreign key (parent_id) references category; 2023-01-02 23:24:18.433 INFO 1432 --- [ restartedMain] p6spy : #1672669458433 | took 0ms | statement | connection 4| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 alter table category_item add constraint FKu8b4lwqutcdq3363gf6mlujq foreign key (item_id) references item alter table category_item add constraint FKu8b4lwqutcdq3363gf6mlujq foreign key (item_id) references item; 2023-01-02 23:24:18.434 INFO 1432 --- [ restartedMain] p6spy : #1672669458434 | took 0ms | statement | connection 4| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 alter table category_item add constraint FKcq2n0opf5shyh84ex1fhukcbh foreign key (category_id) references category alter table category_item add constraint FKcq2n0opf5shyh84ex1fhukcbh foreign key (category_id) references category; 2023-01-02 23:24:18.435 INFO 1432 --- [ restartedMain] p6spy : #1672669458435 | took 0ms | statement | connection 4| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 alter table order_item add constraint FKija6hjjiit8dprnmvtvgdp6ru foreign key (item_id) references item alter table order_item add constraint FKija6hjjiit8dprnmvtvgdp6ru foreign key (item_id) references item; 2023-01-02 23:24:18.437 INFO 1432 --- [ restartedMain] p6spy : #1672669458437 | took 1ms | statement | connection 4| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 alter table order_item add constraint FKt4dc2r9nbvbujrljv3e23iibt foreign key (order_id) references orders alter table order_item add constraint FKt4dc2r9nbvbujrljv3e23iibt foreign key (order_id) references orders; 2023-01-02 23:24:18.438 INFO 1432 --- [ restartedMain] p6spy : #1672669458438 | took 0ms | statement | connection 4| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 alter table orders add constraint FKtkrur7wg4d8ax0pwgo0vmy20c foreign key (delivery_id) references delivery alter table orders add constraint FKtkrur7wg4d8ax0pwgo0vmy20c foreign key (delivery_id) references delivery; 2023-01-02 23:24:18.439 INFO 1432 --- [ restartedMain] p6spy : #1672669458439 | took 0ms | statement | connection 4| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 alter table orders add constraint FKpktxwhj3x9m4gth5ff6bkqgeb foreign key (member_id) references member alter table orders add constraint FKpktxwhj3x9m4gth5ff6bkqgeb foreign key (member_id) references member; 2023-01-02 23:24:18.442 INFO 1432 --- [ restartedMain] o.h.e.t.j.p.i.JtaPlatformInitiator : HHH000490: Using JtaPlatform implementation: [org.hibernate.engine.transaction.jta.platform.internal.NoJtaPlatform] 2023-01-02 23:24:18.450 INFO 1432 --- [ restartedMain] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default' 2023-01-02 23:24:18.465 INFO 1432 --- [ restartedMain] o.s.b.d.a.OptionalLiveReloadServer : LiveReload server is running on port 35729 2023-01-02 23:24:18.658 INFO 1432 --- [ restartedMain] p6spy : #1672669458658 | took 11ms | statement | connection 6| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 call next value for hibernate_sequence call next value for hibernate_sequence; 2023-01-02 23:24:18.695 INFO 1432 --- [ restartedMain] p6spy : #1672669458695 | took 0ms | statement | connection 6| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 call next value for hibernate_sequence call next value for hibernate_sequence; 2023-01-02 23:24:18.696 INFO 1432 --- [ restartedMain] p6spy : #1672669458696 | took 0ms | statement | connection 6| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 call next value for hibernate_sequence call next value for hibernate_sequence; 2023-01-02 23:24:18.700 INFO 1432 --- [ restartedMain] p6spy : #1672669458700 | took 0ms | statement | connection 6| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 call next value for hibernate_sequence call next value for hibernate_sequence; 2023-01-02 23:24:18.702 INFO 1432 --- [ restartedMain] p6spy : #1672669458702 | took 0ms | statement | connection 6| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 call next value for hibernate_sequence call next value for hibernate_sequence; 2023-01-02 23:24:18.705 INFO 1432 --- [ restartedMain] p6spy : #1672669458705 | took 0ms | statement | connection 6| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 call next value for hibernate_sequence call next value for hibernate_sequence; 2023-01-02 23:24:18.705 INFO 1432 --- [ restartedMain] p6spy : #1672669458705 | took 0ms | statement | connection 6| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 call next value for hibernate_sequence call next value for hibernate_sequence; 2023-01-02 23:24:18.736 INFO 1432 --- [ restartedMain] p6spy : #1672669458736 | took 0ms | statement | connection 6| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 insert into member (city, street, zipcode, name, member_id) values (?, ?, ?, ?, ?) insert into member (city, street, zipcode, name, member_id) values ('서울', '1', '1111', 'userA', 1); 2023-01-02 23:24:18.738 INFO 1432 --- [ restartedMain] p6spy : #1672669458738 | took 0ms | statement | connection 6| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 insert into item (name, price, stock_quantity, author, isbn, dtype, item_id) values (?, ?, ?, ?, ?, 'B', ?) insert into item (name, price, stock_quantity, author, isbn, dtype, item_id) values ('JPA1 BOOK', 10000, 100, NULL, NULL, 'B', 2); 2023-01-02 23:24:18.738 INFO 1432 --- [ restartedMain] p6spy : #1672669458738 | took 0ms | statement | connection 6| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 insert into item (name, price, stock_quantity, author, isbn, dtype, item_id) values (?, ?, ?, ?, ?, 'B', ?) insert into item (name, price, stock_quantity, author, isbn, dtype, item_id) values ('JPA2 BOOK', 20000, 100, NULL, NULL, 'B', 3); 2023-01-02 23:24:18.739 INFO 1432 --- [ restartedMain] p6spy : #1672669458739 | took 0ms | statement | connection 6| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 insert into delivery (city, street, zipcode, status, delivery_id) values (?, ?, ?, ?, ?) insert into delivery (city, street, zipcode, status, delivery_id) values ('서울', '1', '1111', NULL, 5); 2023-01-02 23:24:18.745 INFO 1432 --- [ restartedMain] p6spy : #1672669458745 | took 0ms | statement | connection 6| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 insert into orders (delivery_id, member_id, order_date, status, order_id) values (?, ?, ?, ?, ?) insert into orders (delivery_id, member_id, order_date, status, order_id) values (5, 1, '2023-01-02T23:24:18.700+0900', 'ORDER', 4); 2023-01-02 23:24:18.746 INFO 1432 --- [ restartedMain] p6spy : #1672669458746 | took 0ms | statement | connection 6| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 insert into order_item (count, item_id, order_id, order_price, order_item_id) values (?, ?, ?, ?, ?) insert into order_item (count, item_id, order_id, order_price, order_item_id) values (1, 2, 4, 10000, 6); 2023-01-02 23:24:18.746 INFO 1432 --- [ restartedMain] p6spy : #1672669458746 | took 0ms | statement | connection 6| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 insert into order_item (count, item_id, order_id, order_price, order_item_id) values (?, ?, ?, ?, ?) insert into order_item (count, item_id, order_id, order_price, order_item_id) values (2, 3, 4, 20000, 7); 2023-01-02 23:24:18.748 INFO 1432 --- [ restartedMain] p6spy : #1672669458748 | took 0ms | statement | connection 6| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 update item set name=?, price=?, stock_quantity=?, author=?, isbn=? where item_id=? update item set name='JPA1 BOOK', price=10000, stock_quantity=99, author=NULL, isbn=NULL where item_id=2; 2023-01-02 23:24:18.749 INFO 1432 --- [ restartedMain] p6spy : #1672669458749 | took 0ms | statement | connection 6| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 update item set name=?, price=?, stock_quantity=?, author=?, isbn=? where item_id=? update item set name='JPA2 BOOK', price=20000, stock_quantity=98, author=NULL, isbn=NULL where item_id=3; 2023-01-02 23:24:18.751 INFO 1432 --- [ restartedMain] p6spy : #1672669458751 | took 0ms | commit | connection 6| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 ; 2023-01-02 23:24:18.753 INFO 1432 --- [ restartedMain] p6spy : #1672669458753 | took 0ms | statement | connection 7| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 call next value for hibernate_sequence call next value for hibernate_sequence; 2023-01-02 23:24:18.753 INFO 1432 --- [ restartedMain] p6spy : #1672669458753 | took 0ms | statement | connection 7| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 call next value for hibernate_sequence call next value for hibernate_sequence; 2023-01-02 23:24:18.753 INFO 1432 --- [ restartedMain] p6spy : #1672669458753 | took 0ms | statement | connection 7| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 call next value for hibernate_sequence call next value for hibernate_sequence; 2023-01-02 23:24:18.753 INFO 1432 --- [ restartedMain] p6spy : #1672669458753 | took 0ms | statement | connection 7| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 call next value for hibernate_sequence call next value for hibernate_sequence; 2023-01-02 23:24:18.754 INFO 1432 --- [ restartedMain] p6spy : #1672669458754 | took 0ms | statement | connection 7| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 call next value for hibernate_sequence call next value for hibernate_sequence; 2023-01-02 23:24:18.754 INFO 1432 --- [ restartedMain] p6spy : #1672669458754 | took 0ms | statement | connection 7| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 call next value for hibernate_sequence call next value for hibernate_sequence; 2023-01-02 23:24:18.754 INFO 1432 --- [ restartedMain] p6spy : #1672669458754 | took 0ms | statement | connection 7| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 call next value for hibernate_sequence call next value for hibernate_sequence; 2023-01-02 23:24:18.755 INFO 1432 --- [ restartedMain] p6spy : #1672669458755 | took 0ms | statement | connection 7| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 insert into member (city, street, zipcode, name, member_id) values (?, ?, ?, ?, ?) insert into member (city, street, zipcode, name, member_id) values ('진주', '2', '2222', 'userB', 8); 2023-01-02 23:24:18.755 INFO 1432 --- [ restartedMain] p6spy : #1672669458755 | took 0ms | statement | connection 7| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 insert into item (name, price, stock_quantity, author, isbn, dtype, item_id) values (?, ?, ?, ?, ?, 'B', ?) insert into item (name, price, stock_quantity, author, isbn, dtype, item_id) values ('SPRING1 BOOK', 20000, 200, NULL, NULL, 'B', 9); 2023-01-02 23:24:18.756 INFO 1432 --- [ restartedMain] p6spy : #1672669458756 | took 0ms | statement | connection 7| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 insert into item (name, price, stock_quantity, author, isbn, dtype, item_id) values (?, ?, ?, ?, ?, 'B', ?) insert into item (name, price, stock_quantity, author, isbn, dtype, item_id) values ('SPRING2 BOOK', 40000, 300, NULL, NULL, 'B', 10); 2023-01-02 23:24:18.756 INFO 1432 --- [ restartedMain] p6spy : #1672669458756 | took 0ms | statement | connection 7| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 insert into delivery (city, street, zipcode, status, delivery_id) values (?, ?, ?, ?, ?) insert into delivery (city, street, zipcode, status, delivery_id) values ('진주', '2', '2222', NULL, 12); 2023-01-02 23:24:18.756 INFO 1432 --- [ restartedMain] p6spy : #1672669458756 | took 0ms | statement | connection 7| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 insert into orders (delivery_id, member_id, order_date, status, order_id) values (?, ?, ?, ?, ?) insert into orders (delivery_id, member_id, order_date, status, order_id) values (12, 8, '2023-01-02T23:24:18.753+0900', 'ORDER', 11); 2023-01-02 23:24:18.757 INFO 1432 --- [ restartedMain] p6spy : #1672669458757 | took 0ms | statement | connection 7| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 insert into order_item (count, item_id, order_id, order_price, order_item_id) values (?, ?, ?, ?, ?) insert into order_item (count, item_id, order_id, order_price, order_item_id) values (3, 9, 11, 20000, 13); 2023-01-02 23:24:18.757 INFO 1432 --- [ restartedMain] p6spy : #1672669458757 | took 0ms | statement | connection 7| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 insert into order_item (count, item_id, order_id, order_price, order_item_id) values (?, ?, ?, ?, ?) insert into order_item (count, item_id, order_id, order_price, order_item_id) values (4, 10, 11, 40000, 14); 2023-01-02 23:24:18.757 INFO 1432 --- [ restartedMain] p6spy : #1672669458757 | took 0ms | statement | connection 7| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 update item set name=?, price=?, stock_quantity=?, author=?, isbn=? where item_id=? update item set name='SPRING1 BOOK', price=20000, stock_quantity=197, author=NULL, isbn=NULL where item_id=9; 2023-01-02 23:24:18.758 INFO 1432 --- [ restartedMain] p6spy : #1672669458758 | took 0ms | statement | connection 7| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 update item set name=?, price=?, stock_quantity=?, author=?, isbn=? where item_id=? update item set name='SPRING2 BOOK', price=40000, stock_quantity=296, author=NULL, isbn=NULL where item_id=10; 2023-01-02 23:24:18.758 INFO 1432 --- [ restartedMain] p6spy : #1672669458758 | took 0ms | commit | connection 7| url jdbc:h2:mem:6f8c6a84-cb23-479e-9692-b04021f75d08 ; 2023-01-02 23:24:19.178 WARN 1432 --- [ restartedMain] JpaBaseConfiguration$JpaWebConfiguration : spring.jpa.open-in-view is enabled by default. Therefore, database queries may be performed during view rendering. Explicitly configure spring.jpa.open-in-view to disable this warning 2023-01-02 23:24:19.291 INFO 1432 --- [ restartedMain] o.s.s.concurrent.ThreadPoolTaskExecutor : Initializing ExecutorService 'applicationTaskExecutor' 2023-01-02 23:24:19.388 INFO 1432 --- [ restartedMain] o.s.b.a.w.s.WelcomePageHandlerMapping : Adding welcome page: class path resource [static/index.html] 2023-01-02 23:24:19.623 INFO 1432 --- [ restartedMain] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat started on port(s): 8080 (http) with context path '' 2023-01-02 23:24:19.631 INFO 1432 --- [ restartedMain] jpabook.jpashop.JpashopApplication : Started JpashopApplication in 6.631 seconds (JVM running for 7.385) 잘되던 h2 데이터베이스가 어느순간부터 테이블이 보이질 않습니다.. ㅠㅠ 모든 방법을 찾아봤는데 해결이 안되어 질문드립니다
- java
- JPA





