Stack Overflow
Stack Overflow

Questions tagged [h2]

H2 is a relational database management system 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 software is available as open source software under modified versions of the Mozilla Public License or the original Eclipse Public License. The main features of H2 are:

  • Very fast, open source, JDBC API
  • Embedded and server modes; in-memory databases
  • Browser based Console application
  • Small footprint: around 2 MB jar file size

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.

Wiki

Issues

API

4948 questions
2
votes
2 answers

What tool can I use to view the changes in an in-memory H2 database?

I switched to using an in-memory H2 database for development. It works great, but I'm not able to see my changes as I make them. This is their suggested list of tools: http://h2database.com/html/links.html#tools I tried DB Visualizer and SQL…
Jack
  • 16,506
  • 19
  • 100
  • 167
2
votes
2 answers

Cannot transfer blob from MySQL to H2

I have some blob hexadecimal values that I exported from a MySQL database using MAMP. I tried to add those values to a H2 database but I keep getting the error : org.h2.jdbc.JdbcSQLException: Hexadecimal string with odd number of characters:…
user1502150
  • 357
  • 1
  • 4
  • 11
2
votes
1 answer

h2 database home

I was looking into derby database and found property which sets derby home directory. Are there property in h2 database like to derby.system.home to set home directory?
michael nesterenko
  • 14,222
  • 25
  • 114
  • 182
2
votes
1 answer

sonar on h2 database

I wonder is it possible to run sonar 3.1.1 with h2 database? I tried to deploy sonar configured with h2 database and got following exception: 21-Jul-2012 23:32:45 org.apache.catalina.core.StandardContext listenerStart SEVERE: Exception sending…
michael nesterenko
  • 14,222
  • 25
  • 114
  • 182
2
votes
1 answer

porting index logic and join logic from H2 database, but any good information on indexes?

So, we are about to port H2 code to a have a noSQL store instead of on the filesystem for our use in a large system(though with trillions of smaller indexes). When looking at lucene and H2, at first glance it almost looks like they both use one…
Dean Hiller
  • 19,235
  • 25
  • 129
  • 212
2
votes
1 answer

h2.db file size difference

I have an application that generates an H2 database. When I execute the application on Windows XP it generates an .h2.db file with size 176K, but when I execute the same application on Unix (SunOS) it generates an .h2.db file with size 1126K,…
Martin
  • 1,777
  • 1
  • 14
  • 18
2
votes
1 answer

H2 database growing out of control quickly

Hi hopefully someone can help me, I am currently running a H2 database that when cached grows out of control quickly. After completing the cache I found it should be about 32MB but after a small stretch of time it has grown to be nearly 5GB. I have…
user1463805
  • 21
  • 1
2
votes
2 answers

Embedded Java Databases for Large Data Sets

I would like to port a PHP/MySQL-based client/server application to be a standalone desktop application written in Java. The database has grown to be fairly large, with several tables with hundreds of thousands of rows. I expect these could grow to…
Hybrid System
  • 798
  • 12
  • 25
2
votes
2 answers

H2 database fail in playframework2

I developing small application with play 2.0.1 and find very usefull using internal H2 database for make customer's preview. There are just few rows in database and one or two users. It is very comfortable to compile app in my laptop and make tar…
Alex Povar
  • 4,890
  • 3
  • 29
  • 44
2
votes
1 answer

Using column aliases in derived selects or views breaks simple select queries

I have a genuine use-case which requires referring to column aliases in a "where" clause. I'm trying to use the techniques outlined here, which I expect to work in Sybase and MySQL but don't seem to work in either H2 or…
David B
  • 455
  • 6
  • 13
2
votes
1 answer

Why doesn't ScalaQuery create ddl for foreign key?

I have the following table definitions using ScalaQuery 0.10.0-M1: import org.scalaquery.ql.basic.{ BasicTable => Table } object Nodes extends Table[(String, String)]("node") { def id = column[String]("id", O.PrimaryKey) def name =…
Jens Schauder
  • 77,657
  • 34
  • 181
  • 348
2
votes
1 answer

Collation list h2 database

I am trying to set the collation of a new H2 Database over an Android device, and I have two doubts: If I don't specify the collation name of the database with collation is used for it. Where I can find a list of the differents collations that…
user1151835
2
votes
1 answer

Get a olap4j.OlapConnection from a org.h2.jdbc.JdbcConnection

Is there a way to get a olap4j.OlapConnection from a org.h2.jdbc.JdbcConnection? Right now I am trying this (as shown there ): Class.forName("org.h2.Driver"); Class.forName("mondrian.olap4j.MondrianOlap4jDriver"); Connection conn =…
Drahakar
  • 5,986
  • 6
  • 43
  • 58
2
votes
1 answer

How to include full H2 sources to Java project?

I want to use an H2 database in my Java project, but unfortunately I can't use any external .jar or .class files. (It's a build system out of my control and I can only submit source files to it, stupid as that is.) So I thought to simply download…
Matthias
  • 9,817
  • 14
  • 66
  • 125
2
votes
1 answer

How to access Jar file located within source folders?

in my Java project I am using an H2 in-memory database, for which I have to load the JDBC driver when I initialize my application. I want/need to load the H2 .jar file dynamically, so I do the following: String classname = "org.h2.Driver"; URL u =…
Matthias
  • 9,817
  • 14
  • 66
  • 125
1 2 3
…
99
100