I want to persist TODOs in a H2 DB facilitating a Spring Boot application. The following SQL script initializes the DB and it works properly: DROP TABLE IF EXISTS todos; CREATE TABLE todos ( id I...

I am using H2 as in memory database in a spring boot project for unit testing. However I am getting below error Caused by: org.hibernate.exception.SQLGrammarException: could not prepare statement ...

I use in application MySQL 5.7 and I have JSON columns. When I try running my integration tests don't work because the H2 database can't create the table. This is the error: 2016-09-21 16:35:29.72...

I'm having an issue with some of my code, I've searched and tried everything I know of, without any luck. Scenario: Application checks if JDBC driver exists, in this case, the H2 driver (org.h...

I have downloaded the H2 console from http://www.h2database.com/html/download.html and I have configured the URL in my jdbc.properties file to jdbc:h2:c:/data/Messaging. I am using the same URL in...

In Mysql there is a compare operator that is a null safe: <=>. I use this in my Java program when creating prepared statements like this: String routerAddress = getSomeValue(); String sql = "SE...

I am new to database and recently started writing test cases for H2 database. I want to know how to test a stored procedure in Eclipse. I have seen the following: http://www.h2database.com/html/fe...

We're using H2 database (persistent) embedded within our application. Even after we delete the tables, the h2.db file keeps growing. We tried disabling transaction isolation (LOCK_MODE=0), disa...

I am having problems with creating an in memory table, using H2 database, and accessing it outside of the JVM it is created and running in. The documentation structures the url as jdbc:h2:tcp://&l...

I have the following error using H2 (v1.3.154) with Oracle mode : <bean id="datasource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="driverClassNa...

Is there a (more or less) standard way to check not only whether a table named mytable exists, but also whether its schema is similar to what it should be? I'm experimenting with H2 database, and ...

I assume there is a way of doing this from code, at least some good workaround. Please consider that I do not want to delete all tables (I've seen this command), just to delete rows from them but ...

I am writing integration tests with H2 database. My database (generated) initialization include this script (because generated join table does not have this column): ALTER TABLE INT_USR ADD IU_INS...

I have successfully created a spring boot application that uses the H2 embedded database in-memory. I would now like to change this to a file based version that will persist. I have tried just ch...

I have noticed an odd behavior when trying to use the @DataJpaTest annotation in a Spring Boot test that also uses Flyway. Given the following entity class: @Entity public class MyEntity { @Id...

I have H2DB database which stores data in files. I have 3 files: test.18.log.db, test.data.db, and test.index.db. I want get SQL dump file like when I use mysqldump. Is it possible?

I would like to build up an web application with H2 database engine. However, I still don't know how to back up the data while the database is running after reading this tutorial: http://www.h2dat...

I want to keep all my tablenames as lowercase. example person I use Liquibase to setup my database and it looks like <databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog...

In an H2 database on a column of type TIMESTAMP how do I run a query SELECT * FROM RECORDS WHERE TRAN_DATE < '2012/07/24'

I am working on an Embedded database w/ a GUI to communicate with it. I am curious what the MV_STORE = false means in my URL? public DBconnect() throws SQLException, ClassNotFoundException{ client...

Hi I have a spring boot app (2.3.1.RELEASE, ojdbc8) and basically it is connected to an oracle database. The spring boot app starts find when it is connected to the oracle db.However fails to start...

I have a SpringBoot app. I have created this test: @ContextConfiguration(classes={TestConfig.class}) @RunWith(SpringRunner.class) @SpringBootTest public class SuncionServiceITTest { @Test public ...

Either I'm missing some core concept buried deep within some documentation (Spring, Spring Boot, H2, HSQLDB, Derby, IntelliJ) or I've been staring at this for too long. I have a Spring Boot proje...

I'm using Spring Boot 1.4.1 with the H2 database. I have enabled the H2 console as described in the reference guide by adding the following lines to my application.properties file: spring.h2.conso...

Can I get h2 to support Postgres array syntax CREATE TABLE artists ( release_id integer, artist_name text, roles text[] ) I use h2 to mimic Postgres in my unit tests, but it doesn't like the abo...