I set the db url to
spring.datasource.url=jdbc:h2:~/test;INIT=RUNSCRIPT FROM
'~/Documents/Projects/regular-encourager/encourage/src/test/resources/data.sql'
In src/test/resources/data.sql I included a script like this:
*drop table ENCOURAGEMENT if exists; drop TYPE Category if exists; drop
TYPE Tone if exists; drop TYPE Topic if exists; CREATE TYPE Category AS
ENUM('WhoIAmInChrist','Default'); CREATE TYPE Tone AS ENUM('Default',
'Uplifting', 'Urging', 'Warning', 'Soothing', 'Comforting', 'Inspiring',
'Centering', 'Balanced'); CREATE TYPE Topic AS ENUM('Default',
'AcceptedInChrist', 'SignificantInChrist', 'SecureInChrist',
'NoAnxietyInChrist'); CREATE TABLE Encouragement(ID INT PRIMARY KEY,
CATEGORY Category, TOPIC Topic, TONE Tone, MESSAGE VARCHAR(512)); INSERT
INTO Encouragement VALUES(-1, 'Default', 'Default', 'Default', 'We walk by
Faith, not by Sight'); INSERT INTO Encouragement
VALUES(0,'WhoIAmInChrist','AcceptedInChrist','Uplifting','John 1:12 I am
God''s child.'); INSERT INTO Encouragement
VALUES(1,'WhoIAmInChrist','AcceptedInChrist','Uplifting','John 15:15 As a
disciple, I am a friend of Jesus Christ.'); .....*
When I run the test, I see
*Hibernate: drop table if exists encouragement CASCADE Hibernate: create
table encouragement (id bigint not null, category varchar(255), message
varchar(255), tone varchar(255), topic varchar(255), primary key (id))
2023-01-13 18:39:08.297 INFO 18108 --- [ main]
o.h.e.t.j.p.i.JtaPlatformInitiator : HHH000490: Using JtaPlatform
implementation:
[org.hibernate.engine.transaction.jta.platform.internal.NoJtaPlatform]*
No Inserts after this!
Why aren't the inserts happening?
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/2a545826-d1a7-429b-8d37-6f501bc66171n%40googlegroups.com.
