인프런 커뮤니티 질문&답변
작성한 질문수
h2 console 에 테이블이 보이질 않습니다.
작성
·
477
0
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 데이터베이스가 어느순간부터 테이블이 보이질 않습니다.. ㅠㅠ
모든 방법을 찾아봤는데 해결이 안되어 질문드립니다
