[사진][사진][사진]영한쌤은 create, drop 이런식으로 나왔는데 저만 안뜨는건가요?

카테고리

질문 & 답변
세부 분야

백엔드
해결 여부

미해결

터미널에 create, drop이 안떠요

23.07.11 15:52 작성 조회수 356

스크린샷 2023-07-11 오후 3.50.11(2).png 스크린샷 2023-07-11 오후 3.49.58.png

영한쌤은 create, drop 이런식으로 나왔는데 저만 안뜨는건가요?

실전! 스프링 부트와 JPA 활용1 - 웹 애플리케이션 개발

JPA와 DB 설정, 동작확인

강의실 바로가기

답변 1

답변을 작성해보세요.

OMG

2023.07.12

안녕하세요. 이용준님, 공식 서포터즈 ~입니다.

올려주신 내용을 봤을 때 강의와 다른점이 확인이 되는데요,

password를 1234로 세팅하셨는데, 실제 h2 db를 연결하는 과정에서도 1234로 세팅하신게 맞을까요?

그리고 콘솔 창에 보면 스크롤바가 보이는데 스크롤 내렸을 때 하단 영역에도 로그가 없는지 확인이 필요할 것 같습니다 :)

확인해보셨을 때 답변 내용으로 확인이 안될 경우, 강의에서 제공해드리는 프로젝트 코드에서는 어떻게 실행되는지 확인 부탁드립니다!^^

감사합니다.

이용준

질문자

2023.07.16

18:43:59.328 [main] DEBUG org.springframework.test.context.junit4.SpringJUnit4ClassRunner - SpringJUnit4ClassRunner constructor called with [class jpabook.jpashop.MemberRepositoryTest]

18:43:59.332 [main] DEBUG org.springframework.test.context.BootstrapUtils - Instantiating CacheAwareContextLoaderDelegate from class [org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate]

18:43:59.335 [main] DEBUG org.springframework.test.context.BootstrapUtils - Instantiating BootstrapContext using constructor [public org.springframework.test.context.support.DefaultBootstrapContext(java.lang.Class,org.springframework.test.context.CacheAwareContextLoaderDelegate)]

18:43:59.356 [main] DEBUG org.springframework.test.context.BootstrapUtils - Instantiating TestContextBootstrapper for test class [jpabook.jpashop.MemberRepositoryTest] from class [org.springframework.boot.test.context.SpringBootTestContextBootstrapper]

18:43:59.361 [main] INFO org.springframework.boot.test.context.SpringBootTestContextBootstrapper - Neither @ContextConfiguration nor @ContextHierarchy found for test class [jpabook.jpashop.MemberRepositoryTest], using SpringBootContextLoader

18:43:59.363 [main] DEBUG org.springframework.test.context.support.AbstractContextLoader - Did not detect default resource location for test class [jpabook.jpashop.MemberRepositoryTest]: class path resource [jpabook/jpashop/MemberRepositoryTest-context.xml] does not exist

18:43:59.363 [main] INFO org.springframework.test.context.support.AbstractContextLoader - Could not detect default resource locations for test class [jpabook.jpashop.MemberRepositoryTest]: no resource found for suffixes {-context.xml, Context.groovy}.

18:43:59.363 [main] INFO org.springframework.test.context.support.AnnotationConfigContextLoaderUtils - Could not detect default configuration classes for test class [jpabook.jpashop.MemberRepositoryTest]: MemberRepositoryTest does not declare any static, non-private, non-final, nested classes annotated with @Configuration.

18:43:59.396 [main] DEBUG org.springframework.test.context.support.ActiveProfilesUtils - Could not find an 'annotation declaring class' for annotation type [org.springframework.test.context.ActiveProfiles] and class [jpabook.jpashop.MemberRepositoryTest]

18:43:59.441 [main] DEBUG org.springframework.context.annotation.ClassPathScanningCandidateComponentProvider - Identified candidate component class: file [/Users/iyongjun/Desktop/study/jpashop/out/production/classes/jpabook/jpashop/JpashopApplication.class]

18:43:59.444 [main] INFO org.springframework.boot.test.context.SpringBootTestContextBootstrapper - Found @SpringBootConfiguration jpabook.jpashop.JpashopApplication for test class jpabook.jpashop.MemberRepositoryTest

18:43:59.479 [main] DEBUG org.springframework.boot.test.context.SpringBootTestContextBootstrapper - @TestExecutionListeners is not present for class [jpabook.jpashop.MemberRepositoryTest]: using defaults.

18:43:59.479 [main] INFO org.springframework.boot.test.context.SpringBootTestContextBootstrapper - Loaded default TestExecutionListener class names from location [META-INF/spring.factories]: [org.springframework.boot.test.autoconfigure.restdocs.RestDocsTestExecutionListener, org.springframework.boot.test.autoconfigure.web.client.MockRestServiceServerResetTestExecutionListener, org.springframework.boot.test.autoconfigure.web.servlet.MockMvcPrintOnlyOnFailureTestExecutionListener, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverTestExecutionListener, org.springframework.boot.test.autoconfigure.webservices.client.MockWebServiceServerTestExecutionListener, org.springframework.boot.test.mock.mockito.MockitoTestExecutionListener, org.springframework.boot.test.mock.mockito.ResetMocksTestExecutionListener, org.springframework.test.context.web.ServletTestExecutionListener, org.springframework.test.context.support.DirtiesContextBeforeModesTestExecutionListener, org.springframework.test.context.event.ApplicationEventsTestExecutionListener, org.springframework.test.context.support.DependencyInjectionTestExecutionListener, org.springframework.test.context.support.DirtiesContextTestExecutionListener, org.springframework.test.context.transaction.TransactionalTestExecutionListener, org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener, org.springframework.test.context.event.EventPublishingTestExecutionListener]

18:43:59.485 [main] INFO org.springframework.boot.test.context.SpringBootTestContextBootstrapper - Using TestExecutionListeners: [org.springframework.test.context.web.ServletTestExecutionListener@82de64a, org.springframework.test.context.support.DirtiesContextBeforeModesTestExecutionListener@659499f1, org.springframework.test.context.event.ApplicationEventsTestExecutionListener@51e69659, org.springframework.boot.test.mock.mockito.MockitoTestExecutionListener@47e2e487, org.springframework.boot.test.autoconfigure.SpringBootDependencyInjectionTestExecutionListener@201a4587, org.springframework.test.context.support.DirtiesContextTestExecutionListener@61001b64, org.springframework.test.context.transaction.TransactionalTestExecutionListener@4310d43, org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener@54a7079e, org.springframework.test.context.event.EventPublishingTestExecutionListener@26e356f0, org.springframework.boot.test.autoconfigure.restdocs.RestDocsTestExecutionListener@47d9a273, org.springframework.boot.test.autoconfigure.web.client.MockRestServiceServerResetTestExecutionListener@4b8ee4de, org.springframework.boot.test.autoconfigure.web.servlet.MockMvcPrintOnlyOnFailureTestExecutionListener@27f981c6, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverTestExecutionListener@1b11171f, org.springframework.boot.test.autoconfigure.webservices.client.MockWebServiceServerTestExecutionListener@1151e434, org.springframework.boot.test.mock.mockito.ResetMocksTestExecutionListener@2dc54ad4]

18:43:59.485 [main] DEBUG org.springframework.test.annotation.ProfileValueUtils - Retrieved @ProfileValueSourceConfiguration [null] for test class [jpabook.jpashop.MemberRepositoryTest]

18:43:59.486 [main] DEBUG org.springframework.test.annotation.ProfileValueUtils - Retrieved ProfileValueSource type [class org.springframework.test.annotation.SystemProfileValueSource] for class [jpabook.jpashop.MemberRepositoryTest]

18:43:59.488 [main] DEBUG org.springframework.test.annotation.ProfileValueUtils - Retrieved @ProfileValueSourceConfiguration [null] for test class [jpabook.jpashop.MemberRepositoryTest]

18:43:59.488 [main] DEBUG org.springframework.test.annotation.ProfileValueUtils - Retrieved ProfileValueSource type [class org.springframework.test.annotation.SystemProfileValueSource] for class [jpabook.jpashop.MemberRepositoryTest]

18:43:59.488 [main] DEBUG org.springframework.test.annotation.ProfileValueUtils - Retrieved @ProfileValueSourceConfiguration [null] for test class [jpabook.jpashop.MemberRepositoryTest]

18:43:59.492 [main] DEBUG org.springframework.test.annotation.ProfileValueUtils - Retrieved @ProfileValueSourceConfiguration [null] for test class [jpabook.jpashop.MemberRepositoryTest]

18:43:59.492 [main] DEBUG org.springframework.test.annotation.ProfileValueUtils - Retrieved ProfileValueSource type [class org.springframework.test.annotation.SystemProfileValueSource] for class [jpabook.jpashop.MemberRepositoryTest]

18:43:59.493 [main] DEBUG org.springframework.test.annotation.ProfileValueUtils - Retrieved @ProfileValueSourceConfiguration [null] for test class [jpabook.jpashop.MemberRepositoryTest]

18:43:59.493 [main] DEBUG org.springframework.test.annotation.ProfileValueUtils - Retrieved ProfileValueSource type [class org.springframework.test.annotation.SystemProfileValueSource] for class [jpabook.jpashop.MemberRepositoryTest]

18:43:59.493 [main] DEBUG org.springframework.test.annotation.ProfileValueUtils - Retrieved @ProfileValueSourceConfiguration [null] for test class [jpabook.jpashop.MemberRepositoryTest]

18:43:59.494 [main] DEBUG org.springframework.test.annotation.ProfileValueUtils - Retrieved ProfileValueSource type [class org.springframework.test.annotation.SystemProfileValueSource] for class [jpabook.jpashop.MemberRepositoryTest]

18:43:59.495 [main] DEBUG org.springframework.test.context.support.AbstractDirtiesContextTestExecutionListener - Before test class: context [DefaultTestContext@470734c3 testClass = MemberRepositoryTest, testInstance = [null], testMethod = [null], testException = [null], mergedContextConfiguration = [WebMergedContextConfiguration@2cf3d63b testClass = MemberRepositoryTest, locations = '{}', classes = '{class jpabook.jpashop.JpashopApplication}', contextInitializerClasses = '[]', activeProfiles = '{}', propertySourceLocations = '{}', propertySourceProperties = '{org.springframework.boot.test.context.SpringBootTestContextBootstrapper=true}', contextCustomizers = set[org.springframework.boot.test.autoconfigure.actuate.metrics.MetricsExportContextCustomizerFactory$DisableMetricExportContextCustomizer@448ff1a8, org.springframework.boot.test.autoconfigure.properties.PropertyMappingContextCustomizer@0, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverContextCustomizerFactory$Customizer@45f45fa1, org.springframework.boot.test.context.filter.ExcludeFilterContextCustomizer@8e0379d, org.springframework.boot.test.json.DuplicateJsonObjectContextCustomizerFactory$DuplicateJsonObjectContextCustomizer@40e6dfe1, org.springframework.boot.test.mock.mockito.MockitoContextCustomizer@0, org.springframework.boot.test.web.client.TestRestTemplateContextCustomizer@5ef60048, org.springframework.boot.test.context.SpringBootTestArgs@1, org.springframework.boot.test.context.SpringBootTestWebEnvironment@544a2ea6], resourceBasePath = 'src/main/webapp', contextLoader = 'org.springframework.boot.test.context.SpringBootContextLoader', parent = [null]], attributes = map['org.springframework.test.context.web.ServletTestExecutionListener.activateListener' -> true]], class annotated with @DirtiesContext [false] with mode [null].

18:43:59.496 [main] DEBUG org.springframework.test.annotation.ProfileValueUtils - Retrieved @ProfileValueSourceConfiguration [null] for test class [jpabook.jpashop.MemberRepositoryTest]

18:43:59.496 [main] DEBUG org.springframework.test.annotation.ProfileValueUtils - Retrieved ProfileValueSource type [class org.springframework.test.annotation.SystemProfileValueSource] for class [jpabook.jpashop.MemberRepositoryTest]

. ____ _

/\\ / ___'_ __ (_)_ _ \ \ \ \

( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \

\\/ ___)| |_)| | | | | || (_| | ) ) ) )

' |____| .__|_| |_|_| |_\__, | / / / /

=========|_|==============|___/=/_/_/_/

:: Spring Boot :: (v2.7.13)

2023-07-16 18:43:59.656 INFO 73627 --- [ main] jpabook.jpashop.MemberRepositoryTest : Starting MemberRepositoryTest using Java 17.0.7 on iyongjun-ui-MacBookAir.local with PID 73627 (started by iyongjun in /Users/iyongjun/Desktop/study/jpashop)

2023-07-16 18:43:59.657 INFO 73627 --- [ main] jpabook.jpashop.MemberRepositoryTest : No active profile set, falling back to 1 default profile: "default"

2023-07-16 18:43:59.886 INFO 73627 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.

2023-07-16 18:43:59.892 INFO 73627 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 3 ms. Found 0 JPA repository interfaces.

2023-07-16 18:44:00.133 INFO 73627 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]

2023-07-16 18:44:00.155 INFO 73627 --- [ main] org.hibernate.Version : HHH000412: Hibernate ORM core version 5.6.15.Final

2023-07-16 18:44:00.217 INFO 73627 --- [ main] o.hibernate.annotations.common.Version : HCANN000001: Hibernate Commons Annotations {5.1.2.Final}

2023-07-16 18:44:00.231 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration boolean -> org.hibernate.type.BooleanType@422ad5e2

2023-07-16 18:44:00.231 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.lang.Boolean -> org.hibernate.type.BooleanType@422ad5e2

2023-07-16 18:44:00.231 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration numeric_boolean -> org.hibernate.type.NumericBooleanType@44286963

2023-07-16 18:44:00.231 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration true_false -> org.hibernate.type.TrueFalseType@35adf623

2023-07-16 18:44:00.231 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration yes_no -> org.hibernate.type.YesNoType@5232e3f1

2023-07-16 18:44:00.231 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration byte -> org.hibernate.type.ByteType@5a08b084

2023-07-16 18:44:00.231 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.lang.Byte -> org.hibernate.type.ByteType@5a08b084

2023-07-16 18:44:00.232 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration character -> org.hibernate.type.CharacterType@552cede7

2023-07-16 18:44:00.232 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration char -> org.hibernate.type.CharacterType@552cede7

2023-07-16 18:44:00.232 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.lang.Character -> org.hibernate.type.CharacterType@552cede7

2023-07-16 18:44:00.232 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration short -> org.hibernate.type.ShortType@19e21f89

2023-07-16 18:44:00.232 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.lang.Short -> org.hibernate.type.ShortType@19e21f89

2023-07-16 18:44:00.232 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration integer -> org.hibernate.type.IntegerType@2efd2f21

2023-07-16 18:44:00.232 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration int -> org.hibernate.type.IntegerType@2efd2f21

2023-07-16 18:44:00.232 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.lang.Integer -> org.hibernate.type.IntegerType@2efd2f21

2023-07-16 18:44:00.232 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration long -> org.hibernate.type.LongType@6909f6be

2023-07-16 18:44:00.232 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.lang.Long -> org.hibernate.type.LongType@6909f6be

2023-07-16 18:44:00.233 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration float -> org.hibernate.type.FloatType@5bcec67e

2023-07-16 18:44:00.233 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.lang.Float -> org.hibernate.type.FloatType@5bcec67e

2023-07-16 18:44:00.233 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration double -> org.hibernate.type.DoubleType@721d5b74

2023-07-16 18:44:00.233 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.lang.Double -> org.hibernate.type.DoubleType@721d5b74

2023-07-16 18:44:00.233 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration big_decimal -> org.hibernate.type.BigDecimalType@202d9236

2023-07-16 18:44:00.233 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.math.BigDecimal -> org.hibernate.type.BigDecimalType@202d9236

2023-07-16 18:44:00.233 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration big_integer -> org.hibernate.type.BigIntegerType@7ecda95b

2023-07-16 18:44:00.233 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.math.BigInteger -> org.hibernate.type.BigIntegerType@7ecda95b

2023-07-16 18:44:00.233 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration string -> org.hibernate.type.StringType@77b3752b

2023-07-16 18:44:00.234 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.lang.String -> org.hibernate.type.StringType@77b3752b

2023-07-16 18:44:00.234 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration nstring -> org.hibernate.type.StringNVarcharType@35bfa1bb

2023-07-16 18:44:00.234 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration ncharacter -> org.hibernate.type.CharacterNCharType@357bc488

2023-07-16 18:44:00.234 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration url -> org.hibernate.type.UrlType@1af4955e

2023-07-16 18:44:00.234 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.net.URL -> org.hibernate.type.UrlType@1af4955e

2023-07-16 18:44:00.234 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration Duration -> org.hibernate.type.DurationType@66e21568

2023-07-16 18:44:00.234 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.time.Duration -> org.hibernate.type.DurationType@66e21568

2023-07-16 18:44:00.234 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration Instant -> org.hibernate.type.InstantType@3d615b2e

2023-07-16 18:44:00.234 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.time.Instant -> org.hibernate.type.InstantType@3d615b2e

2023-07-16 18:44:00.235 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration LocalDateTime -> org.hibernate.type.LocalDateTimeType@5efeb117

2023-07-16 18:44:00.235 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.time.LocalDateTime -> org.hibernate.type.LocalDateTimeType@5efeb117

2023-07-16 18:44:00.235 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration LocalDate -> org.hibernate.type.LocalDateType@5d508d22

2023-07-16 18:44:00.235 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.time.LocalDate -> org.hibernate.type.LocalDateType@5d508d22

2023-07-16 18:44:00.235 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration LocalTime -> org.hibernate.type.LocalTimeType@35650279

2023-07-16 18:44:00.235 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.time.LocalTime -> org.hibernate.type.LocalTimeType@35650279

2023-07-16 18:44:00.235 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration OffsetDateTime -> org.hibernate.type.OffsetDateTimeType@faea4da

2023-07-16 18:44:00.235 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.time.OffsetDateTime -> org.hibernate.type.OffsetDateTimeType@faea4da

2023-07-16 18:44:00.236 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration OffsetTime -> org.hibernate.type.OffsetTimeType@3a7c678b

2023-07-16 18:44:00.236 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.time.OffsetTime -> org.hibernate.type.OffsetTimeType@3a7c678b

2023-07-16 18:44:00.236 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration ZonedDateTime -> org.hibernate.type.ZonedDateTimeType@25b38203

2023-07-16 18:44:00.236 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.time.ZonedDateTime -> org.hibernate.type.ZonedDateTimeType@25b38203

2023-07-16 18:44:00.236 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration date -> org.hibernate.type.DateType@1a950fdd

2023-07-16 18:44:00.236 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.sql.Date -> org.hibernate.type.DateType@1a950fdd

2023-07-16 18:44:00.236 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration time -> org.hibernate.type.TimeType@6c977dcf

2023-07-16 18:44:00.236 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.sql.Time -> org.hibernate.type.TimeType@6c977dcf

2023-07-16 18:44:00.237 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration timestamp -> org.hibernate.type.TimestampType@12417468

2023-07-16 18:44:00.237 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.sql.Timestamp -> org.hibernate.type.TimestampType@12417468

2023-07-16 18:44:00.237 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.util.Date -> org.hibernate.type.TimestampType@12417468

2023-07-16 18:44:00.237 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration dbtimestamp -> org.hibernate.type.DbTimestampType@2233cac0

2023-07-16 18:44:00.237 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration calendar -> org.hibernate.type.CalendarType@79b18230

2023-07-16 18:44:00.237 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.util.Calendar -> org.hibernate.type.CalendarType@79b18230

2023-07-16 18:44:00.237 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.util.GregorianCalendar -> org.hibernate.type.CalendarType@79b18230

2023-07-16 18:44:00.237 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration calendar_date -> org.hibernate.type.CalendarDateType@902fdbe

2023-07-16 18:44:00.238 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration calendar_time -> org.hibernate.type.CalendarTimeType@2a8b33ba

2023-07-16 18:44:00.238 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration locale -> org.hibernate.type.LocaleType@2401856

2023-07-16 18:44:00.238 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.util.Locale -> org.hibernate.type.LocaleType@2401856

2023-07-16 18:44:00.238 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration currency -> org.hibernate.type.CurrencyType@69a024a0

2023-07-16 18:44:00.238 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.util.Currency -> org.hibernate.type.CurrencyType@69a024a0

2023-07-16 18:44:00.238 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration timezone -> org.hibernate.type.TimeZoneType@23cd5d42

2023-07-16 18:44:00.238 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.util.TimeZone -> org.hibernate.type.TimeZoneType@23cd5d42

2023-07-16 18:44:00.238 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration class -> org.hibernate.type.ClassType@4b425577

2023-07-16 18:44:00.238 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.lang.Class -> org.hibernate.type.ClassType@4b425577

2023-07-16 18:44:00.238 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration uuid-binary -> org.hibernate.type.UUIDBinaryType@21e45a6f

2023-07-16 18:44:00.238 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.util.UUID -> org.hibernate.type.UUIDBinaryType@21e45a6f

2023-07-16 18:44:00.238 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration uuid-char -> org.hibernate.type.UUIDCharType@388c519

2023-07-16 18:44:00.239 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration binary -> org.hibernate.type.BinaryType@747835f5

2023-07-16 18:44:00.239 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration byte[] -> org.hibernate.type.BinaryType@747835f5

2023-07-16 18:44:00.239 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration [B -> org.hibernate.type.BinaryType@747835f5

2023-07-16 18:44:00.239 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration wrapper-binary -> org.hibernate.type.WrapperBinaryType@47a7c93e

2023-07-16 18:44:00.239 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration Byte[] -> org.hibernate.type.WrapperBinaryType@47a7c93e

2023-07-16 18:44:00.239 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration [Ljava.lang.Byte; -> org.hibernate.type.WrapperBinaryType@47a7c93e

2023-07-16 18:44:00.239 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration row_version -> org.hibernate.type.RowVersionType@5bde57ab

2023-07-16 18:44:00.239 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration image -> org.hibernate.type.ImageType@7bbcf6f0

2023-07-16 18:44:00.239 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration characters -> org.hibernate.type.CharArrayType@794f11cd

2023-07-16 18:44:00.239 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration char[] -> org.hibernate.type.CharArrayType@794f11cd

2023-07-16 18:44:00.239 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration [C -> org.hibernate.type.CharArrayType@794f11cd

2023-07-16 18:44:00.240 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration wrapper-characters -> org.hibernate.type.CharacterArrayType@171dc7c3

2023-07-16 18:44:00.240 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration [Ljava.lang.Character; -> org.hibernate.type.CharacterArrayType@171dc7c3

2023-07-16 18:44:00.240 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration Character[] -> org.hibernate.type.CharacterArrayType@171dc7c3

2023-07-16 18:44:00.240 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration text -> org.hibernate.type.TextType@55c57422

2023-07-16 18:44:00.240 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration ntext -> org.hibernate.type.NTextType@1d6751e3

2023-07-16 18:44:00.240 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration blob -> org.hibernate.type.BlobType@733e6df7

2023-07-16 18:44:00.240 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.sql.Blob -> org.hibernate.type.BlobType@733e6df7

2023-07-16 18:44:00.240 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration materialized_blob -> org.hibernate.type.MaterializedBlobType@4ea56bdb

2023-07-16 18:44:00.241 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration clob -> org.hibernate.type.ClobType@71664560

2023-07-16 18:44:00.241 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.sql.Clob -> org.hibernate.type.ClobType@71664560

2023-07-16 18:44:00.241 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration nclob -> org.hibernate.type.NClobType@2180e789

2023-07-16 18:44:00.241 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.sql.NClob -> org.hibernate.type.NClobType@2180e789

2023-07-16 18:44:00.241 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration materialized_clob -> org.hibernate.type.MaterializedClobType@2ba42204

2023-07-16 18:44:00.241 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration materialized_nclob -> org.hibernate.type.MaterializedNClobType@2de6f1bc

2023-07-16 18:44:00.242 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration serializable -> org.hibernate.type.SerializableType@4e140497

2023-07-16 18:44:00.242 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration object -> org.hibernate.type.ObjectType@5ed5b321

2023-07-16 18:44:00.242 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.lang.Object -> org.hibernate.type.ObjectType@5ed5b321

2023-07-16 18:44:00.242 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration imm_date -> org.hibernate.type.AdaptedImmutableType@d54d0f5

2023-07-16 18:44:00.242 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration imm_time -> org.hibernate.type.AdaptedImmutableType@6d6bff89

2023-07-16 18:44:00.242 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration imm_timestamp -> org.hibernate.type.AdaptedImmutableType@541bf968

2023-07-16 18:44:00.243 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration imm_dbtimestamp -> org.hibernate.type.AdaptedImmutableType@739265f1

2023-07-16 18:44:00.243 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration imm_calendar -> org.hibernate.type.AdaptedImmutableType@58eac00e

2023-07-16 18:44:00.243 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration imm_calendar_date -> org.hibernate.type.AdaptedImmutableType@6acffb2d

2023-07-16 18:44:00.243 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration imm_binary -> org.hibernate.type.AdaptedImmutableType@61149fa5

2023-07-16 18:44:00.243 DEBUG 73627 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration imm_serializable -> org.hibernate.type.AdaptedImmutableType@149c39b

2023-07-16 18:44:00.256 INFO 73627 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting...

2023-07-16 18:44:00.292 INFO 73627 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed.

2023-07-16 18:44:00.304 INFO 73627 --- [ main] org.hibernate.dialect.Dialect : HHH000400: Using dialect: org.hibernate.dialect.H2Dialect

2023-07-16 18:44:00.318 DEBUG 73627 --- [ main] o.h.type.spi.TypeConfiguration$Scope : Scoping TypeConfiguration [org.hibernate.type.spi.TypeConfiguration@72c9ebfa] to MetadataBuildingContext [org.hibernate.boot.internal.MetadataBuildingContextRootImpl@686cf8ad]

2023-07-16 18:44:00.427 DEBUG 73627 --- [ main] org.hibernate.type.EnumType : Using NAMED-based conversion for Enum jpabook.jpashop.domain.DeliveryStatus

2023-07-16 18:44:00.427 DEBUG 73627 --- [ main] org.hibernate.type.EnumType : Using ORDINAL-based conversion for Enum jpabook.jpashop.domain.OrderStatus

2023-07-16 18:44:00.427 DEBUG 73627 --- [ main] o.h.type.spi.TypeConfiguration$Scope : Scoping TypeConfiguration [org.hibernate.type.spi.TypeConfiguration@72c9ebfa] to SessionFactoryImpl [org.hibernate.internal.SessionFactoryImpl@3d033453]

2023-07-16 18:44:00.588 DEBUG 73627 --- [ main] org.hibernate.SQL : drop table if exists category CASCADE

2023-07-16 18:44:00.591 INFO 73627 --- [ main] p6spy : #1689500640591 | took 1ms | statement | connection 1| url jdbc:h2:tcp://localhost/~/jpashop

drop table if exists category CASCADE

drop table if exists category CASCADE ;

2023-07-16 18:44:00.591 DEBUG 73627 --- [ main] org.hibernate.SQL : drop table if exists category_item CASCADE

2023-07-16 18:44:00.591 INFO 73627 --- [ main] p6spy : #1689500640591 | took 0ms | statement | connection 1| url jdbc:h2:tcp://localhost/~/jpashop

drop table if exists category_item CASCADE

drop table if exists category_item CASCADE ;

2023-07-16 18:44:00.591 DEBUG 73627 --- [ main] org.hibernate.SQL : drop table if exists delivery CASCADE

2023-07-16 18:44:00.592 INFO 73627 --- [ main] p6spy : #1689500640592 | took 0ms | statement | connection 1| url jdbc:h2:tcp://localhost/~/jpashop

drop table if exists delivery CASCADE

drop table if exists delivery CASCADE ;

2023-07-16 18:44:00.592 DEBUG 73627 --- [ main] org.hibernate.SQL : drop table if exists item CASCADE

2023-07-16 18:44:00.593 INFO 73627 --- [ main] p6spy : #1689500640593 | took 0ms | statement | connection 1| url jdbc:h2:tcp://localhost/~/jpashop

drop table if exists item CASCADE

drop table if exists item CASCADE ;

2023-07-16 18:44:00.593 DEBUG 73627 --- [ main] org.hibernate.SQL : drop table if exists member CASCADE

2023-07-16 18:44:00.593 INFO 73627 --- [ main] p6spy : #1689500640593 | took 0ms | statement | connection 1| url jdbc:h2:tcp://localhost/~/jpashop

drop table if exists member CASCADE

drop table if exists member CASCADE ;

2023-07-16 18:44:00.593 DEBUG 73627 --- [ main] org.hibernate.SQL : drop table if exists member1 CASCADE

2023-07-16 18:44:00.594 INFO 73627 --- [ main] p6spy : #1689500640594 | took 0ms | statement | connection 1| url jdbc:h2:tcp://localhost/~/jpashop

drop table if exists member1 CASCADE

drop table if exists member1 CASCADE ;

2023-07-16 18:44:00.594 DEBUG 73627 --- [ main] org.hibernate.SQL : drop table if exists order_item CASCADE

2023-07-16 18:44:00.595 INFO 73627 --- [ main] p6spy : #1689500640595 | took 0ms | statement | connection 1| url jdbc:h2:tcp://localhost/~/jpashop

drop table if exists order_item CASCADE

drop table if exists order_item CASCADE ;

2023-07-16 18:44:00.595 DEBUG 73627 --- [ main] org.hibernate.SQL : drop table if exists orders CASCADE

2023-07-16 18:44:00.595 INFO 73627 --- [ main] p6spy : #1689500640595 | took 0ms | statement | connection 1| url jdbc:h2:tcp://localhost/~/jpashop

drop table if exists orders CASCADE

drop table if exists orders CASCADE ;

2023-07-16 18:44:00.595 DEBUG 73627 --- [ main] org.hibernate.SQL : drop sequence if exists hibernate_sequence

2023-07-16 18:44:00.596 INFO 73627 --- [ main] p6spy : #1689500640596 | took 0ms | statement | connection 1| url jdbc:h2:tcp://localhost/~/jpashop

drop sequence if exists hibernate_sequence

drop sequence if exists hibernate_sequence;

2023-07-16 18:44:00.596 DEBUG 73627 --- [ main] org.hibernate.SQL : create sequence hibernate_sequence start with 1 increment by 1

2023-07-16 18:44:00.597 INFO 73627 --- [ main] p6spy : #1689500640597 | took 0ms | statement | connection 2| url jdbc:h2:tcp://localhost/~/jpashop

create sequence hibernate_sequence start with 1 increment by 1

create sequence hibernate_sequence start with 1 increment by 1;

2023-07-16 18:44:00.597 DEBUG 73627 --- [ main] org.hibernate.SQL : create table category (category_id bigint not null, name varchar(255), parent_id bigint, primary key (category_id))

2023-07-16 18:44:00.597 INFO 73627 --- [ main] p6spy : #1689500640597 | took 0ms | statement | connection 2| url jdbc:h2:tcp://localhost/~/jpashop

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-07-16 18:44:00.597 DEBUG 73627 --- [ main] org.hibernate.SQL : create table category_item (category_id bigint not null, item_id bigint not null)

2023-07-16 18:44:00.598 INFO 73627 --- [ main] p6spy : #1689500640598 | took 0ms | statement | connection 2| url jdbc:h2:tcp://localhost/~/jpashop

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-07-16 18:44:00.598 DEBUG 73627 --- [ main] org.hibernate.SQL : 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-07-16 18:44:00.599 INFO 73627 --- [ main] p6spy : #1689500640599 | took 0ms | statement | connection 2| url jdbc:h2:tcp://localhost/~/jpashop

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-07-16 18:44:00.599 DEBUG 73627 --- [ main] org.hibernate.SQL : 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-07-16 18:44:00.599 INFO 73627 --- [ main] p6spy : #1689500640599 | took 0ms | statement | connection 2| url jdbc:h2:tcp://localhost/~/jpashop

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-07-16 18:44:00.599 DEBUG 73627 --- [ main] org.hibernate.SQL : create table member (id bigint not null, username varchar(255), primary key (id))

2023-07-16 18:44:00.600 INFO 73627 --- [ main] p6spy : #1689500640600 | took 0ms | statement | connection 2| url jdbc:h2:tcp://localhost/~/jpashop

create table member (id bigint not null, username varchar(255), primary key (id))

create table member (id bigint not null, username varchar(255), primary key (id));

2023-07-16 18:44:00.600 DEBUG 73627 --- [ main] org.hibernate.SQL : create table member1 (member_id bigint not null, city varchar(255), street varchar(255), zipcode varchar(255), name varchar(255), primary key (member_id))

2023-07-16 18:44:00.600 INFO 73627 --- [ main] p6spy : #1689500640600 | took 0ms | statement | connection 2| url jdbc:h2:tcp://localhost/~/jpashop

create table member1 (member_id bigint not null, city varchar(255), street varchar(255), zipcode varchar(255), name varchar(255), primary key (member_id))

create table member1 (member_id bigint not null, city varchar(255), street varchar(255), zipcode varchar(255), name varchar(255), primary key (member_id));

2023-07-16 18:44:00.600 DEBUG 73627 --- [ main] org.hibernate.SQL : 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-07-16 18:44:00.601 INFO 73627 --- [ main] p6spy : #1689500640601 | took 0ms | statement | connection 2| url jdbc:h2:tcp://localhost/~/jpashop

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-07-16 18:44:00.601 DEBUG 73627 --- [ main] org.hibernate.SQL : create table orders (order_id bigint not null, order_date timestamp, status integer, delivery_id bigint, member_id bigint, primary key (order_id))

2023-07-16 18:44:00.601 INFO 73627 --- [ main] p6spy : #1689500640601 | took 0ms | statement | connection 2| url jdbc:h2:tcp://localhost/~/jpashop

create table orders (order_id bigint not null, order_date timestamp, status integer, delivery_id bigint, member_id bigint, primary key (order_id))

create table orders (order_id bigint not null, order_date timestamp, status integer, delivery_id bigint, member_id bigint, primary key (order_id));

2023-07-16 18:44:00.601 DEBUG 73627 --- [ main] org.hibernate.SQL : alter table category add constraint FK2y94svpmqttx80mshyny85wqr foreign key (parent_id) references category

2023-07-16 18:44:00.603 INFO 73627 --- [ main] p6spy : #1689500640603 | took 1ms | statement | connection 2| url jdbc:h2:tcp://localhost/~/jpashop

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-07-16 18:44:00.603 DEBUG 73627 --- [ main] org.hibernate.SQL : alter table category_item add constraint FKu8b4lwqutcdq3363gf6mlujq foreign key (item_id) references item

2023-07-16 18:44:00.604 INFO 73627 --- [ main] p6spy : #1689500640604 | took 0ms | statement | connection 2| url jdbc:h2:tcp://localhost/~/jpashop

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-07-16 18:44:00.604 DEBUG 73627 --- [ main] org.hibernate.SQL : alter table category_item add constraint FKcq2n0opf5shyh84ex1fhukcbh foreign key (category_id) references category

2023-07-16 18:44:00.605 INFO 73627 --- [ main] p6spy : #1689500640605 | took 1ms | statement | connection 2| url jdbc:h2:tcp://localhost/~/jpashop

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-07-16 18:44:00.605 DEBUG 73627 --- [ main] org.hibernate.SQL : alter table order_item add constraint FKija6hjjiit8dprnmvtvgdp6ru foreign key (item_id) references item

2023-07-16 18:44:00.606 INFO 73627 --- [ main] p6spy : #1689500640606 | took 0ms | statement | connection 2| url jdbc:h2:tcp://localhost/~/jpashop

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-07-16 18:44:00.606 DEBUG 73627 --- [ main] org.hibernate.SQL : alter table order_item add constraint FKt4dc2r9nbvbujrljv3e23iibt foreign key (order_id) references orders

2023-07-16 18:44:00.607 INFO 73627 --- [ main] p6spy : #1689500640607 | took 0ms | statement | connection 2| url jdbc:h2:tcp://localhost/~/jpashop

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-07-16 18:44:00.607 DEBUG 73627 --- [ main] org.hibernate.SQL : alter table orders add constraint FKtkrur7wg4d8ax0pwgo0vmy20c foreign key (delivery_id) references delivery

2023-07-16 18:44:00.608 INFO 73627 --- [ main] p6spy : #1689500640608 | took 0ms | statement | connection 2| url jdbc:h2:tcp://localhost/~/jpashop

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-07-16 18:44:00.608 DEBUG 73627 --- [ main] org.hibernate.SQL : alter table orders add constraint FK3f2ughr8bl6p25v9w89kx8oin foreign key (member_id) references member1

2023-07-16 18:44:00.608 INFO 73627 --- [ main] p6spy : #1689500640608 | took 0ms | statement | connection 2| url jdbc:h2:tcp://localhost/~/jpashop

alter table orders add constraint FK3f2ughr8bl6p25v9w89kx8oin foreign key (member_id) references member1

alter table orders add constraint FK3f2ughr8bl6p25v9w89kx8oin foreign key (member_id) references member1;

2023-07-16 18:44:00.609 INFO 73627 --- [ main] o.h.e.t.j.p.i.JtaPlatformInitiator : HHH000490: Using JtaPlatform implementation: [org.hibernate.engine.transaction.jta.platform.internal.NoJtaPlatform]

2023-07-16 18:44:00.612 TRACE 73627 --- [ main] o.h.type.spi.TypeConfiguration$Scope : Handling #sessionFactoryCreated from [org.hibernate.internal.SessionFactoryImpl@3d033453] for TypeConfiguration

2023-07-16 18:44:00.612 INFO 73627 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'

2023-07-16 18:44:00.699 WARN 73627 --- [ main] 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-07-16 18:44:00.795 INFO 73627 --- [ main] o.s.b.a.w.s.WelcomePageHandlerMapping : Adding welcome page: class path resource [static/index.html]

2023-07-16 18:44:00.906 INFO 73627 --- [ main] jpabook.jpashop.MemberRepositoryTest : Started MemberRepositoryTest in 1.397 seconds (JVM running for 1.752)

2023-07-16 18:44:00.935 INFO 73627 --- [ main] o.s.t.c.transaction.TransactionContext : Began transaction (1) for test context [DefaultTestContext@470734c3 testClass = MemberRepositoryTest, testInstance = jpabook.jpashop.MemberRepositoryTest@6d41200c, testMethod = testMember@MemberRepositoryTest, testException = [null], mergedContextConfiguration = [WebMergedContextConfiguration@2cf3d63b testClass = MemberRepositoryTest, locations = '{}', classes = '{class jpabook.jpashop.JpashopApplication}', contextInitializerClasses = '[]', activeProfiles = '{}', propertySourceLocations = '{}', propertySourceProperties = '{org.springframework.boot.test.context.SpringBootTestContextBootstrapper=true}', contextCustomizers = set[org.springframework.boot.test.autoconfigure.actuate.metrics.MetricsExportContextCustomizerFactory$DisableMetricExportContextCustomizer@448ff1a8, org.springframework.boot.test.autoconfigure.properties.PropertyMappingContextCustomizer@0, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverContextCustomizerFactory$Customizer@45f45fa1, org.springframework.boot.test.context.filter.ExcludeFilterContextCustomizer@8e0379d, org.springframework.boot.test.json.DuplicateJsonObjectContextCustomizerFactory$DuplicateJsonObjectContextCustomizer@40e6dfe1, org.springframework.boot.test.mock.mockito.MockitoContextCustomizer@0, org.springframework.boot.test.web.client.TestRestTemplateContextCustomizer@5ef60048, org.springframework.boot.test.context.SpringBootTestArgs@1, org.springframework.boot.test.context.SpringBootTestWebEnvironment@544a2ea6], resourceBasePath = 'src/main/webapp', contextLoader = 'org.springframework.boot.test.context.SpringBootContextLoader', parent = [null]], attributes = map['org.springframework.test.context.web.ServletTestExecutionListener.activateListener' -> true, 'org.springframework.test.context.web.ServletTestExecutionListener.populatedRequestContextHolder' -> true, 'org.springframework.test.context.web.ServletTestExecutionListener.resetRequestContextHolder' -> true, 'org.springframework.test.context.event.ApplicationEventsTestExecutionListener.recordApplicationEvents' -> false]]; transaction manager [org.springframework.orm.jpa.JpaTransactionManager@214e3185]; rollback [true]

2023-07-16 18:44:00.991 DEBUG 73627 --- [ main] org.hibernate.SQL : call next value for hibernate_sequence

2023-07-16 18:44:00.998 INFO 73627 --- [ main] p6spy : #1689500640998 | took 3ms | statement | connection 3| url jdbc:h2:tcp://localhost/~/jpashop

call next value for hibernate_sequence

call next value for hibernate_sequence;

2023-07-16 18:44:01.028 INFO 73627 --- [ main] p6spy : #1689500641028 | took 0ms | rollback | connection 3| url jdbc:h2:tcp://localhost/~/jpashop

;

2023-07-16 18:44:01.029 INFO 73627 --- [ main] o.s.t.c.transaction.TransactionContext : Rolled back transaction for test: [DefaultTestContext@470734c3 testClass = MemberRepositoryTest, testInstance = jpabook.jpashop.MemberRepositoryTest@6d41200c, testMethod = testMember@MemberRepositoryTest, testException = [null], mergedContextConfiguration = [WebMergedContextConfiguration@2cf3d63b testClass = MemberRepositoryTest, locations = '{}', classes = '{class jpabook.jpashop.JpashopApplication}', contextInitializerClasses = '[]', activeProfiles = '{}', propertySourceLocations = '{}', propertySourceProperties = '{org.springframework.boot.test.context.SpringBootTestContextBootstrapper=true}', contextCustomizers = set[org.springframework.boot.test.autoconfigure.actuate.metrics.MetricsExportContextCustomizerFactory$DisableMetricExportContextCustomizer@448ff1a8, org.springframework.boot.test.autoconfigure.properties.PropertyMappingContextCustomizer@0, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverContextCustomizerFactory$Customizer@45f45fa1, org.springframework.boot.test.context.filter.ExcludeFilterContextCustomizer@8e0379d, org.springframework.boot.test.json.DuplicateJsonObjectContextCustomizerFactory$DuplicateJsonObjectContextCustomizer@40e6dfe1, org.springframework.boot.test.mock.mockito.MockitoContextCustomizer@0, org.springframework.boot.test.web.client.TestRestTemplateContextCustomizer@5ef60048, org.springframework.boot.test.context.SpringBootTestArgs@1, org.springframework.boot.test.context.SpringBootTestWebEnvironment@544a2ea6], resourceBasePath = 'src/main/webapp', contextLoader = 'org.springframework.boot.test.context.SpringBootContextLoader', parent = [null]], attributes = map['org.springframework.test.context.web.ServletTestExecutionListener.activateListener' -> true, 'org.springframework.test.context.web.ServletTestExecutionListener.populatedRequestContextHolder' -> true, 'org.springframework.test.context.web.ServletTestExecutionListener.resetRequestContextHolder' -> true, 'org.springframework.test.context.event.ApplicationEventsTestExecutionListener.recordApplicationEvents' -> false]]

2023-07-16 18:44:01.032 INFO 73627 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'

2023-07-16 18:44:01.032 TRACE 73627 --- [ionShutdownHook] o.h.type.spi.TypeConfiguration$Scope : Handling #sessionFactoryClosed from [org.hibernate.internal.SessionFactoryImpl@3d033453] for TypeConfiguration

2023-07-16 18:44:01.032 DEBUG 73627 --- [ionShutdownHook] o.h.type.spi.TypeConfiguration$Scope : Un-scoping TypeConfiguration [org.hibernate.type.spi.TypeConfiguration$Scope@1e8770f2] from SessionFactory [org.hibernate.internal.SessionFactoryImpl@3d033453]

2023-07-16 18:44:01.032 INFO 73627 --- [ionShutdownHook] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown initiated...

2023-07-16 18:44:01.037 INFO 73627 --- [ionShutdownHook] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown completed.

Process finished with exit code 0

log는 이렇게 나왔고 스크린샷 2023-07-16 오후 6.45.10(2).png 코드는 다음과 같습니다

이용준

터미널에 create, drop이 안떠요

이 글과 비슷한 Q&A

Service, Repository 트랜잭션

기본키에 대해서

서비스계층과컨트롤러(3) 상품수정

싱글톤 해결방안