Top "H2" questions

H2 is a relational database management system written in Java.

Performance issues using H2 DB in embedded mode with heavy load of data in database

I am working a java application using H2 Database in embedded mode. My Application consumes 150mb of heap memory. Problem: …

h2 database-performance
"Create table if not exists" - how to check the schema, too?

Is there a (more or less) standard way to check not only whether a table named mytable exists, but also …

sql database h2 create-table
H2-Console is not showing in browser

I am working on SpringBoot api and using H2 database with following property settings. spring.h2.console.enabled=true spring.…

spring-boot h2
Why we need a connection pooling for JDBC?

What are the benefits of using a JDBC connection pooling tool like DBCP or c3p0 ? in case of a …

java jdbc threadpool connection-pooling h2
Why does the H2 console in Spring Boot show a blank screen after logging in?

I'm using Spring Boot 1.4.1 with the H2 database. I have enabled the H2 console as described in the reference guide …

java spring-boot h2
Quick SQL question: Correct syntax for creating a table with a primary key in H2?

I'm currently starting a new Java application using the H2 database, but I have some confusion about basic SQL use …

sql database h2 create-table
Spring Boot. @DataJpaTest H2 embedded database create schema

I have couple of entities in my data layer stored in particular schema. For example: @Entity @Table(name = "FOO", schema = "…

spring-boot integration-testing h2 spring-test embedded-database
H2 - How to create a database trigger that log a row change to another table?

How to create a database trigger that log a row change to another table in H2? In MySQL, this can …

java sql triggers h2 jooq
Connect Python to H2

I'm trying to make a connection from python2.7 to H2 (h2-1.4.193.jar - latest) H2 (is running and available): …

python-2.7 h2 jaydebeapi
Access to h2 web console while running junit test in a Spring application

I'm building a Spring application and I need to inspect my H2 in-memory database while I'm running my JUnit tests …

spring junit h2