• 카테고리

    질문 & 답변
  • 세부 분야

    백엔드

  • 해결 여부

    미해결

h2 console 에 테이블이 보이질 않습니다.

23.01.02 23:30 작성 조회수 314

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 데이터베이스가 어느순간부터 테이블이 보이질 않습니다.. ㅠㅠ

모든 방법을 찾아봤는데 해결이 안되어 질문드립니다

 

답변 1

답변을 작성해보세요.

0

OMG님의 프로필

OMG

2023.01.03

안녕하세요. omimabi77님, 공식 서포터즈 OMG입니다.

yml은 띄어쓰기가 중요한데 강의자료와 비교해보시면 아시겠지만 띄어쓰기가 많이 다른 것 같습니다.

띄어쓰기 외에도 datasource.url 도 메모리를 이용하는 것 같고, ddl-auto도 create네요..

본 강의에서는 거의 대부분이 테스트로 진행되기 때문에 /h2-console에 직접 접근할 일이 없을것 같은데 어떤 상황에서 학습을 진행하신것인지 부가적인 설명 부탁드립니다.


.

image

image
.
감사합니다.