I’m developing an app in Spring Boot. I use a PostreSQL DB for production, and I want my JUnit 5 tests to run on a H2 memory DB. Problem is, after some configuration, the tests still don’t seem to run on the in-memory db: I can access entities from the prod db (a saved entity doesn’t persist…
Tag: h2
h2 console not being found in browser while running springboot application
Im trying to get the h2 console in my browser while my my Springboot application. Whitelabel Error Page This application has no explicit mapping for /error, so you are seeing this as a fallback. Sun Apr 24 00:44:22 IST 2022 There was an unexpected error (type=Not Found, status=404). This is my application.pro…
How to display hashed MD5 value as text displayed in H2?
The H2 HASH function returns bytes, and SELECT HASH(‘MD5’, ‘test’) AS new_id FROM my_table; displays a text value: 098f6bcd4621d373cade4e832627b4f6 How to retrieve that same text value in Java? Using ResultSet.getBytes(“new_id”) gives the object’s address, something l…
My Spring JPA queries do not work with H2
This query below does not work and it generates me an exception When I used the MySQL database, the query worked fine. But now that I am using the H2 database, it suddenly does not work. Why? How do I fix this? Answer It would be better to use JPA. If you still wanna use nativeQuery, use like this:
Use a secondary h2 database for testing an API in Spring boot
I’m developing an API to manage a database in the company where I work, the problem is that when I have to run the different test I have to use the “real” dev database (in h2) where I have some real data. I thought about it and what I wanted to do is create a new h2 database that could
org.h2.jdbc.JdbcSQLSyntaxErrorException h2 database java
Exception in thread “main” org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement “INSERT INTO SMTP_DATA(SMTP_SERVER, SMTP_USERNAME, SMTP_PASSWORD, SMTP_FROM, SMTP_TO) VALUES (DEMO.STMP.COM, DEMOUSERNAME, DEMOPASSWORD, FROMDEMO@[*]MAIL.COM, TODEMO@MAIL.COM);”; expected …
I get empty list from findAll Spring data and h2 data base while the database is not empty
I have a spring boot API project with h2 database. I added some data in the data.sql but the data wasn’t inserted into the database however tables are created successfully when I call the findAll API I get an empty list due to the database tables are empty. Application.properties data.sql Pom.xml Main C…
Can’t start Spring Boot because of the class mapping
I was trying to start an Spring Boot application, with a simple class JPA mapping and H2 database, but every time I try to start the application, I have the same class error at the same column. Class with error: Error logged: The column that is with error is a table and already mapped: My H2 configurations: I…
Error while saving user to h2 using springboot
I’m trying to register a user entity through an API and add it to “users” table in my local dB. I keep getting the error mentioned below. I am sending a POST request with the following body: It states the “NULL not allowed for column “ID”” but I don’t understand…
How to store Form data in a H2 Database (currently works using POSTman, but not the website form)
I am just teaching myself the Spring framework and am trying to makie a simple library app which stores user (book) inputs in a form in the H2 Database, and then shows the user the newly inputted data from the H2 Database. Form submission attempt 1: I now have a working POST method which correctly saves a new…