Top "H2" questions

Why am I getting JdbcSQLException (non-hex characters) with my H2 database / Spring boot application?

So the short version, I'm guessing I've some sort of character encoding issue, or the DB is storing/returning the …

java hibernate spring-boot spring-data-jpa h2

Accessing play project database with h2-browser

I am having some trouble accessing the mem database via the h2-browser on a Play framework project. With the …

playframework playframework-2.0 h2

File based h2 persisted but not loaded in Spring Boot

I made a small application based on Spring Boot: spring-boot-starter-web spring-boot-starter-data-jpa The application has simply one domain class Post.java. …

java maven hsqldb h2 spring-boot

Make H2 treat quoted name and unquoted name as the same

H2 seems to make a difference between name with quote and name without quote. Is there a way to make …

sql database h2 double-quotes

jhipster liquibase validation error after modify entity

I was trying to add an field to my entity as a CLOB. When using the JHipster CLI it was …

spring spring-boot h2 jhipster

Set default timezone H2 database

How can I explicitly set the time zone H2 should use? Now it gets the timezone to use from the …

h2

Spring Boot 2 - H2 Database - @SpringBootTest - Failing on org.h2.jdbc.JdbcSQLException: Table already exists

Unable to test Spring Boot & H2 with a script for creation of table using schema.sql. So, what’s …

jpa spring-boot spring-data-jpa h2

Oracle MERGE statement in H2 database

We started to use the H2 in memory database for automated testing. We use Oracle for our production & dev …

sql h2 sql-merge

DbUnit H2 in memory db with Spring and Hibernate

Hi I'm trying a little POC with JPA and unit test to verify that the DB schema is created. I'm …

spring hibernate unit-testing h2 dbunit

ROW_NUMBER() OVER () with order by in H2

i'm trying to execute a query on a table in H2 database with ROW_NUMBER clause. Here is my query: …

database h2 row-number