Questions tagged [h2db]

H2 is an open source SQL database engine written in Java. It can be embedded in Java applications or run in the client-server mode. H2 supports regular disk-based as well as in-memory databases. The disk footprint (size of the jar file) is about 1 MB.

H2 is an open source SQL database engine written in Java. It can be embedded in Java applications or run in the client-server mode. H2 supports regular disk-based as well as in-memory databases. The disk footprint (size of the jar file) is about 1 MB.

The main author of H2 is Thomas Mueller, who also developed the Java database engine Hypersonic SQL. The name H2 stands for Hypersonic 2, however H2 does not share code with Hypersonic SQL or HSQLDB.

This tag is synonym for H2 tag

Wiki

Issues

93 questions
0
votes
1 answer

Logging queries to H2 database with Play Framework

I am using H2 database, in-memory, within Play Framework (1.2.7). In order to have a log of all queries I added ;TRACE_LEVEL_FILE=3 at the end of these parameters in Play's application.conf: db.url %prod.db.url %debug.db.url But nithing happens,…
OferBr
  • 297
  • 2
  • 13
-1
votes
2 answers

H2db jar not working on port other than 8082

I have a h2db jar which i want to run on port other than 8082. I tried java -jar -Dserver.port=XXXX but it is still running on 8082. Is there any way to run it on other port?
Yatin Kanyal
  • 195
  • 1
  • 13
-1
votes
1 answer

How bad is repeated select * on an empty table in h2 database (v1.4.195)?

So I have a h2 database event table, that I am monitoring for events. There is a thread that fires every 2 secs and checks with select * from eventTable limit 10 offset 0. I was wondering what is the performance impact of this hammering in an h2…
1 2 3 4 5 6
7