2025-01-11T20:00:20.975-06:00 INFO 29436 --- [demo] [ Test worker] t.c.s.AnnotationConfigContextLoaderUtils : Could not detect default configuration classes for test class [org.zheng.demo.repository.OrderRepoTest]: OrderRepoTest does not declare any static, non-private, non-final, nested classes annotated with @Configuration.
2025-01-11T20:00:21.027-06:00 INFO 29436 --- [demo] [ Test worker] .b.t.c.SpringBootTestContextBootstrapper : Found @SpringBootConfiguration org.zheng.demo.DemoApplication for test class org.zheng.demo.repository.OrderRepoTest
. ____ _ __ _ _
/\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
\\/ ___)| |_)| | | | | || (_| | ) ) ) )
' |____| .__|_| |_|_| |_\__, | / / / /
=========|_|==============|___/=/_/_/_/
:: Spring Boot :: (v3.4.0)
2025-01-11T20:00:21.075-06:00 INFO 29436 --- [demo] [ Test worker] o.zheng.demo.repository.OrderRepoTest : Starting OrderRepoTest using Java 17 with PID 29436 (started by azpm0 in C:\MaryTools\workspace\demomapsid)
2025-01-11T20:00:21.075-06:00 INFO 29436 --- [demo] [ Test worker] o.zheng.demo.repository.OrderRepoTest : No active profile set, falling back to 1 default profile: "default"
2025-01-11T20:00:21.190-06:00 INFO 29436 --- [demo] [ Test worker] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2025-01-11T20:00:21.208-06:00 INFO 29436 --- [demo] [ Test worker] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 16 ms. Found 4 JPA repository interfaces.
2025-01-11T20:00:21.232-06:00 INFO 29436 --- [demo] [ Test worker] beddedDataSourceBeanFactoryPostProcessor : Replacing 'dataSource' DataSource bean with embedded version
2025-01-11T20:00:21.270-06:00 INFO 29436 --- [demo] [ Test worker] o.s.j.d.e.EmbeddedDatabaseFactory : Starting embedded database: url='jdbc:h2:mem:aea30aee-74d9-4bb2-a586-0ea27b529be3;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa'
2025-01-11T20:00:21.308-06:00 INFO 29436 --- [demo] [ Test worker] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]
2025-01-11T20:00:21.311-06:00 INFO 29436 --- [demo] [ Test worker] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled
2025-01-11T20:00:21.329-06:00 INFO 29436 --- [demo] [ Test worker] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer
2025-01-11T20:00:21.332-06:00 WARN 29436 --- [demo] [ Test worker] org.hibernate.orm.deprecation : HHH90000025: H2Dialect does not need to be specified explicitly using 'hibernate.dialect' (remove the property setting and it will be selected by default)
2025-01-11T20:00:21.333-06:00 INFO 29436 --- [demo] [ Test worker] org.hibernate.orm.connections.pooling : HHH10001005: Database info:
Database JDBC URL [Connecting through datasource 'org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseFactory$EmbeddedDataSourceProxy@5fb8ad3d']
Database driver: undefined/unknown
Database version: 2.3.232
Autocommit mode: undefined/unknown
Isolation level: undefined/unknown
Minimum pool size: undefined/unknown
Maximum pool size: undefined/unknown
2025-01-11T20:00:21.424-06:00 INFO 29436 --- [demo] [ Test worker] o.h.e.t.j.p.i.JtaPlatformInitiator : HHH000489: No JTA platform available (set 'hibernate.transaction.jta.platform' to enable JTA platform integration)
Hibernate:
create table t_order (
id integer generated by default as identity,
name varchar(255),
primary key (id)
)
Hibernate:
create table t_order_item (
quantity integer,
order_id integer not null,
product_id integer not null,
primary key (order_id, product_id)
)
Hibernate:
create table t_product (
id integer generated by default as identity,
name varchar(255),
primary key (id)
)
Hibernate:
create table t_product_profile (
id integer generated by default as identity,
product_detail varchar(255),
primary key (id)
)
Hibernate:
alter table if exists t_order_item
add constraint FK2y83rerik30vumt2a1mff6606
foreign key (order_id)
references t_order
Hibernate:
alter table if exists t_order_item
add constraint FKn4krp2vsjtox6l7sj5h55inx0
foreign key (product_id)
references t_product
Hibernate:
alter table if exists t_product_profile
add constraint FKghkpnmy480sm9k7nwayvyj6c1
foreign key (id)
references t_product
2025-01-11T20:00:21.441-06:00 INFO 29436 --- [demo] [ Test worker] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2025-01-11T20:00:21.546-06:00 INFO 29436 --- [demo] [ Test worker] o.zheng.demo.repository.OrderRepoTest : Started OrderRepoTest in 0.514 seconds (process running for 8.758)
Hibernate:
insert
into
t_product
(name, id)
values
(?, default)
2025-01-11T20:00:21.593-06:00 TRACE 29436 --- [demo] [ Test worker] org.hibernate.orm.jdbc.bind : binding parameter (1:VARCHAR) <- [product 1]
Hibernate:
insert
into
t_product_profile
(product_detail, id)
values
(?, default)
2025-01-11T20:00:21.598-06:00 TRACE 29436 --- [demo] [ Test worker] org.hibernate.orm.jdbc.bind : binding parameter (1:VARCHAR) <- [some details]
Hibernate:
insert
into
t_product
(name, id)
values
(?, default)
2025-01-11T20:00:21.600-06:00 TRACE 29436 --- [demo] [ Test worker] org.hibernate.orm.jdbc.bind : binding parameter (1:VARCHAR) <- [product 2]
Hibernate:
insert
into
t_product_profile
(product_detail, id)
values
(?, default)
2025-01-11T20:00:21.603-06:00 TRACE 29436 --- [demo] [ Test worker] org.hibernate.orm.jdbc.bind : binding parameter (1:VARCHAR) <- [some details]
Hibernate:
insert
into
t_order
(name, id)
values
(?, default)
2025-01-11T20:00:21.607-06:00 TRACE 29436 --- [demo] [ Test worker] org.hibernate.orm.jdbc.bind : binding parameter (1:VARCHAR) <- [first order]
Hibernate:
select
oli1_0.order_id,
oli1_0.product_id,
o1_0.id,
o1_0.name,
p1_0.id,
p1_0.name,
oli1_0.quantity
from
t_order_item oli1_0
join
t_order o1_0
on o1_0.id=oli1_0.order_id
join
t_product p1_0
on p1_0.id=oli1_0.product_id
where
(
oli1_0.order_id, oli1_0.product_id
) in ((?, ?))
2025-01-11T20:00:21.613-06:00 TRACE 29436 --- [demo] [ Test worker] org.hibernate.orm.jdbc.bind : binding parameter (1:INTEGER) <- [1]
2025-01-11T20:00:21.613-06:00 TRACE 29436 --- [demo] [ Test worker] org.hibernate.orm.jdbc.bind : binding parameter (2:INTEGER) <- [1]
Hibernate:
select
oli1_0.order_id,
oli1_0.product_id,
o1_0.id,
o1_0.name,
p1_0.id,
p1_0.name,
oli1_0.quantity
from
t_order_item oli1_0
join
t_order o1_0
on o1_0.id=oli1_0.order_id
join
t_product p1_0
on p1_0.id=oli1_0.product_id
where
(
oli1_0.order_id, oli1_0.product_id
) in ((?, ?))
2025-01-11T20:00:21.615-06:00 TRACE 29436 --- [demo] [ Test worker] org.hibernate.orm.jdbc.bind : binding parameter (1:INTEGER) <- [1]
2025-01-11T20:00:21.615-06:00 TRACE 29436 --- [demo] [ Test worker] org.hibernate.orm.jdbc.bind : binding parameter (2:INTEGER) <- [2]
Hibernate:
insert
into
t_order_item
(quantity, order_id, product_id)
values
(?, ?, ?)
2025-01-11T20:00:21.618-06:00 TRACE 29436 --- [demo] [ Test worker] org.hibernate.orm.jdbc.bind : binding parameter (1:INTEGER) <- [null]
2025-01-11T20:00:21.619-06:00 TRACE 29436 --- [demo] [ Test worker] org.hibernate.orm.jdbc.bind : binding parameter (2:INTEGER) <- [1]
2025-01-11T20:00:21.619-06:00 TRACE 29436 --- [demo] [ Test worker] org.hibernate.orm.jdbc.bind : binding parameter (3:INTEGER) <- [1]
Hibernate:
insert
into
t_order_item
(quantity, order_id, product_id)
values
(?, ?, ?)
2025-01-11T20:00:21.620-06:00 TRACE 29436 --- [demo] [ Test worker] org.hibernate.orm.jdbc.bind : binding parameter (1:INTEGER) <- [null]
2025-01-11T20:00:21.620-06:00 TRACE 29436 --- [demo] [ Test worker] org.hibernate.orm.jdbc.bind : binding parameter (2:INTEGER) <- [1]
2025-01-11T20:00:21.620-06:00 TRACE 29436 --- [demo] [ Test worker] org.hibernate.orm.jdbc.bind : binding parameter (3:INTEGER) <- [2]
Hibernate:
select
oli1_0.order_id,
oli1_0.product_id,
oli1_0.quantity
from
t_order_item oli1_0
Hibernate:
insert
into
t_product
(name, id)
values
(?, default)
2025-01-11T20:00:21.631-06:00 TRACE 29436 --- [demo] [ Test worker] org.hibernate.orm.jdbc.bind : binding parameter (1:VARCHAR) <- [product 1]
Hibernate:
insert
into
t_product_profile
(product_detail, id)
values
(?, default)
2025-01-11T20:00:21.634-06:00 TRACE 29436 --- [demo] [ Test worker] org.hibernate.orm.jdbc.bind : binding parameter (1:VARCHAR) <- [some details]
Hibernate:
insert
into
t_product
(name, id)
values
(?, default)
2025-01-11T20:00:21.636-06:00 TRACE 29436 --- [demo] [ Test worker] org.hibernate.orm.jdbc.bind : binding parameter (1:VARCHAR) <- [product 2]
Hibernate:
insert
into
t_product_profile
(product_detail, id)
values
(?, default)
2025-01-11T20:00:21.639-06:00 TRACE 29436 --- [demo] [ Test worker] org.hibernate.orm.jdbc.bind : binding parameter (1:VARCHAR) <- [some details]
Hibernate:
insert
into
t_order
(name, id)
values
(?, default)
2025-01-11T20:00:21.641-06:00 TRACE 29436 --- [demo] [ Test worker] org.hibernate.orm.jdbc.bind : binding parameter (1:VARCHAR) <- [first order]
Hibernate:
select
oli1_0.order_id,
oli1_0.product_id,
o1_0.id,
o1_0.name,
p1_0.id,
p1_0.name,
oli1_0.quantity
from
t_order_item oli1_0
join
t_order o1_0
on o1_0.id=oli1_0.order_id
join
t_product p1_0
on p1_0.id=oli1_0.product_id
where
(
oli1_0.order_id, oli1_0.product_id
) in ((?, ?))
2025-01-11T20:00:21.645-06:00 TRACE 29436 --- [demo] [ Test worker] org.hibernate.orm.jdbc.bind : binding parameter (1:INTEGER) <- [2]
2025-01-11T20:00:21.645-06:00 TRACE 29436 --- [demo] [ Test worker] org.hibernate.orm.jdbc.bind : binding parameter (2:INTEGER) <- [3]
Hibernate:
insert
into
t_product
(name, id)
values
(?, default)
2025-01-11T20:00:21.661-06:00 TRACE 29436 --- [demo] [ Test worker] org.hibernate.orm.jdbc.bind : binding parameter (1:VARCHAR) <- [product 1]
Hibernate:
insert
into
t_product_profile
(product_detail, id)
values
(?, default)
2025-01-11T20:00:21.664-06:00 TRACE 29436 --- [demo] [ Test worker] org.hibernate.orm.jdbc.bind : binding parameter (1:VARCHAR) <- [some details]
Hibernate:
insert
into
t_product
(name, id)
values
(?, default)
2025-01-11T20:00:21.665-06:00 TRACE 29436 --- [demo] [ Test worker] org.hibernate.orm.jdbc.bind : binding parameter (1:VARCHAR) <- [product 2]
Hibernate:
insert
into
t_product_profile
(product_detail, id)
values
(?, default)
2025-01-11T20:00:21.667-06:00 TRACE 29436 --- [demo] [ Test worker] org.hibernate.orm.jdbc.bind : binding parameter (1:VARCHAR) <- [some details]
Hibernate:
insert
into
t_order
(name, id)
values
(?, default)
2025-01-11T20:00:21.669-06:00 TRACE 29436 --- [demo] [ Test worker] org.hibernate.orm.jdbc.bind : binding parameter (1:VARCHAR) <- [first order]
Hibernate:
select
oli1_0.order_id,
oli1_0.product_id,
o1_0.id,
o1_0.name,
p1_0.id,
p1_0.name,
oli1_0.quantity
from
t_order_item oli1_0
join
t_order o1_0
on o1_0.id=oli1_0.order_id
join
t_product p1_0
on p1_0.id=oli1_0.product_id
where
(
oli1_0.order_id, oli1_0.product_id
) in ((?, ?))
2025-01-11T20:00:21.672-06:00 TRACE 29436 --- [demo] [ Test worker] org.hibernate.orm.jdbc.bind : binding parameter (1:INTEGER) <- [3]
2025-01-11T20:00:21.672-06:00 TRACE 29436 --- [demo] [ Test worker] org.hibernate.orm.jdbc.bind : binding parameter (2:INTEGER) <- [5]
Hibernate:
insert
into
t_order_item
(quantity, order_id, product_id)
values
(?, ?, ?)
2025-01-11T20:00:21.678-06:00 TRACE 29436 --- [demo] [ Test worker] org.hibernate.orm.jdbc.bind : binding parameter (1:INTEGER) <- [null]
2025-01-11T20:00:21.678-06:00 TRACE 29436 --- [demo] [ Test worker] org.hibernate.orm.jdbc.bind : binding parameter (2:INTEGER) <- [3]
2025-01-11T20:00:21.678-06:00 TRACE 29436 --- [demo] [ Test worker] org.hibernate.orm.jdbc.bind : binding parameter (3:INTEGER) <- [5]
Hibernate:
update
t_order_item
set
quantity=?
where
order_id=?
and product_id=?
2025-01-11T20:00:21.686-06:00 TRACE 29436 --- [demo] [ Test worker] org.hibernate.orm.jdbc.bind : binding parameter (1:INTEGER) <- [2]
2025-01-11T20:00:21.686-06:00 TRACE 29436 --- [demo] [ Test worker] org.hibernate.orm.jdbc.bind : binding parameter (2:INTEGER) <- [3]
2025-01-11T20:00:21.686-06:00 TRACE 29436 --- [demo] [ Test worker] org.hibernate.orm.jdbc.bind : binding parameter (3:INTEGER) <- [5]
Hibernate:
select
oli1_0.order_id,
oli1_0.product_id,
oli1_0.quantity
from
t_order_item oli1_0