I have spring boot application which starts H2 db with below URL jdbc:h2:~/data/test;AUTO_SERVER=TRUE;DB_CLOSE_ON_EXIT=FALSE;TRACE_LEVEL_SYSTEM_OUT=3;AUTO_SERVE
I am having trouble getting an H2 In Memory database to populate. The idea here to have the BuildingCode which is unique as a primary key and id. I get the foll
SQL Server has bit type column to store true and false. In where clause we check column_name = 'false' it works fine on SQL Server (dev and prod env) but it fai
I have a strange problem with my unit test.. My goal is to run test on a H2 database and not on my Mysql database.. Actually the strange thing is that when i cl
I am new to H2 database. I have 3 tables in database for example, table t1 : ID desc something condition_id 1 EN 142868 151508 XYZ [4686, 4687] table condition
I've created a Java Spring Boot service using the WebFlux reactive module, H2 in-memory database, and R2DBC reactive driver. When I run the service, it fails wi
I recently updated the h2 database in my springboot project to 2.1.210. This induced some problems, most of them I was able to fix myself. The one that I can't
i am trying to make my tests on h2 database. But my first test always falling with error nested exception is io.r2dbc.spi.R2dbcBadGrammarException: [90079] [900
source code I want to use jsonb column type. When I used postgresql there is no problem. But when I use H2 I can not persist my entity. Native sql works but whe
I've below data.sql file in my src/main/resources/data.sql file. I would like user tabel to be created from user.csv file. DROP TABLE IF EXISTS `USER` CASCADE;
I have a spring boot 2.6.7 app, using Liquibase, Gradle and Spock. I have a class that uses a guid format string as the ID: @Entity @Table(name = "devices") pu
I am developing a spring command line application where I connect to a db using data r2dbc. For information, my application is written in Kotlin. the pom file c
I've used in-mem databases in Spring JPA tests many times, and never had a problem. This time, I have a bit more complex schema to initialize, and that schema m
After build the native image I've the following error I'm using a H2 database in file mode. Do I should understand that it's not possible to use H2 in native m
I have this project that I just started and using a model from my teacher I created a simple class to be mapped in the H2. So far no problems I run the applicat
I'm sending a very simple query to the database, but I'm getting an error. It feels like I'm missing something very simple. I guess it wouldn't allow me to crea
when merge native query is used using JPA, it is resulting into following error: {"ts":"2022-05-05T17:03:12.124+0000","level":"ERROR","message":"SQL Error: 500
When I used H2 database the database files are stored at C:\Users\MyName\TestDataBase.db directory. The H2 path is jdbc:h2:~/TestDataBase. This is default H2 da
I have this problem when testing a JPA repository: Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Column "CREATED_AT" not found; SQL statement: ins
I have this simple Table (just for test) : create table table ( key int not null primary key auto_increment, name varchar(30) ); Then I execute the followin