H2 « Database Product « Java Database Q&A

  1. Java Database Q&A
  2. Database Product
  3. H2




1. Embedding the Java h2 database programmatically    stackoverflow.com

At the moment we use HSQLDB as an embedded database, but we search for a database with less memory footprint as the data volume grows. Derby / JavaDB ...

2. Any real world experience with H2 database?    stackoverflow.com

Has anybody out there got any real world experience with the H2 database? I'm interested in:

  • performance
  • stability
  • bugs

3. How to back up the embedded H2 database engine while it is running?    stackoverflow.com

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 ...

4. Counting sentences: Database (like h2) vs. Lucene vs.?    stackoverflow.com

I am doing some linguistic research that depends on being able to query a corpus of 100 million sentences. The information I need from that corpus is along the lines: how ...

5. h2 (embedded mode ) database files problem    stackoverflow.com

There is a h2-database file in my src directory (Java, Eclipse): h2test.db The problem:

  • starting the h2.jar from the command line (and thus the h2 browser interface on port 8082), I have created ...

6. Relational Database arrays (H2, Java)    stackoverflow.com

I seem to have two options on how to implement arrays, and I want to know which I should go with:

  • Use the ARRAY data type and (from what I understand) effectively ...

7. How to get stream to "in-memory" database created via H2DB?    stackoverflow.com

I have to create such a mechanism:

  1. Create in-memory (H2DB) database;
  2. Create tables and fill them using some data;
  3. Get stream to that database;
  4. Send that stream via WebDAV or something else;
I know everything except ...

8. What are the best settings of the H2 database for high concurrency?    stackoverflow.com

There are a lot of settings that can be used in H2 database. AUTO_SERVER, MVCC, LOCK_MODE, FILE_LOCK and MULTI_THREADED. I wonder what combination works best for high concurrency setup e.g. one ...

9. Read paradox DBF files and import in H2 database    stackoverflow.com

can i import DBF files (i think it is files of paradox database) into H2 database? I think a good solution is to write a small wrapper in java to read dbf ...





10. The CHOICE : Firebird or H2    stackoverflow.com

i have to choice a database to use in server-mode for a java desktop application. I think both are great java database. In my opinion (im NOT well-informed): H2 PRO

  • Is java based
  • Develeopment say it ...

11. Liquibase drop constraint without knowing it's name    stackoverflow.com

We use liquibase to keep track of our database changes.. First changeSet contains those lines: 

<column name="SHORT_ID" type="INTEGER">
   <constraints unique="true" />
</column>
Basically it means that SHORT_ID column has unique constraint but the ...

12. H2 Database error message localization    stackoverflow.com

I have a problems with H2 Database exception messages. The language of the messages corresponds to the OS language(I'm using Windows). Is it possible to turn off localization feature to get ...

13. H2 Database WIth .NET Application    stackoverflow.com

I have created .NET APP that is supposed queries the H2 DB but at the time of "DriverManager.getConnection(DBUrl, DBUName, DBPassword);" it gives the following error:

Error : IO Exception: "java.io.FileNotFoundException: Access to the ...

14. H2 (embedded) Database in Java - StackOverflowError    stackoverflow.com

I use embedded H2 Database in Java SE project (jdbc:h2:file:...) with JPA 2.0 (EclipseLink 2.1.1). I set also set MODE=Derby in jdbc url connection. Everything worked perfect till I added some ...

15. How to embed H2 database into jar file delivered to the client?    stackoverflow.com

I use H2 database for a desktop application in embedded mode. When I compress the application into jar file the database file is omitted. So, when I run MyApplication.jar nothing works. ...

16. How to access CSV file within WAR using H2's CSVREAD() function/query?    stackoverflow.com

I'm trying to read a CSV file from within a web application (Tomcat 5.5.x) and all I get is 'FileNotFoundExceptions's: 

dbStatement.executeQuery("SELECT * FROM CSVREAD('csvfile.csv');");
I don't think I can/need to specify an ...





17. Faling to load large dataset into h2 database    stackoverflow.com

Here is the problem: At my company we have a large database that we want to perform some automated operations in it. To test that we got a small sample of ...

18. H2 console - looking at the database via browser shows old data    stackoverflow.com

I'm using H2 database for a simple web application. When I try and view the data via the H2 console web browser, it doesn't seem to update with the latest data in ...

19. How to create a h2 database from some fields of a CSV file    stackoverflow.com

i would like to create a new embedded h2 database from a CSV file. Here is the snippet of the csv file

Country,City,AccentCity,Region,Population,Latitude,Longitude ad,aixovall,Aixovall,06,,42.4666667,1.4833333 ad,andorra,Andorra,07,,42.5,1.5166667 ...

20. basic ORMLite database questions    stackoverflow.com

I have two questions about the examples listed on the ORMLIte website.

  • Where do I put the database and how do I import it?
  • Which class do I put the DAO ...

21. Load CSV file located in the classpath for H2 Database    stackoverflow.com

For tests purposes, I want to create and fill some tables using SQL scripts as well as CSV files. So I created a SQL script like this one: 

CREATE TABLE T_FOO (
  ...

22. H2 in memory database, what am I missing?    stackoverflow.com

I've got a H2 database with URL "jdbc:h2:test". I create a table using CREATE TABLE PERSON (ID INT PRIMARY KEY, FIRSTNAME VARCHAR(64), LASTNAME VARCHAR(64));. I then select everything from this (empty) ...

23. Issues with h2 upgrade to 1.2.147 - getNString exception    stackoverflow.com

I have recently upgraded to h2 1.2.147. My code throws an exception - Caused by: java.lang.AbstractMethodError: org.h2.jdbc.JdbcResultSet.getNString(Ljava/lang/String;)Ljava/lang/String; Any idea? Thanks, Anuprit

24. H2 database: how to protect with encryption, without exposing file encryption key    stackoverflow.com

We are using Java + H2 Database in server mode, because we do not want users from accessing database file. To add more protection to database file, we plan to use ...

25. H2 database: prevent users from dumping database content (SCRIPT, BACKUP, etc)    stackoverflow.com

We are using Java + H2 Database in server mode, because we do not want users from accessing database file. All database users created by admin are regular users (not admin). ...

26. (Multiple) Role definition and checking in H2    stackoverflow.com

Greetings, What is the meaning of database role in H2? Is it kind of rights or grants? Which approach should be used: A. multiple roles for one user ==or== B. one role for one ...

27. Where are my H2 database files?    stackoverflow.com

I'm just evaluating the H2 database... I downloaded and unpacked the installation and connect to a database at jdbc:h2:file:/home/konrad/test. /home/konrad is my home dir, test does not exist (I expect H2 ...

28. on Fedora 15, start Lift app on Fedora getting org.h2.jdbc.JdbcSQLException    stackoverflow.com

On Fedora 15, after doing mvn jetty:run, I am getting the following excetion when it's trying to initialize the MetaMapper for User 

org.h2.jdbc.JdbcSQLException: Exception opening port "H2 TCP Server (tcp://
192.168.1.105:33463)" (port may ...

29. How to use full text search in H2?    stackoverflow.com

Anybody please explain how to use the Full-Text search for H2 Embedded Database with the help of java program. Don't give that test example from H2 tutorial. I want a java program(j2se) ...

30. User-friendly tool to edit databases in Eclipse    stackoverflow.com

Is there any tool in Eclipse comparable with phpMyAdmin? The project is in Java and I want to use H2 database. I have installed DTP but it is not as much ...

31. h2database is very slow on order by    stackoverflow.com

I have a java applet what has embeeded h2 database, and table with 200.000 rows. Table: 

    CREATE TABLE `DB`.`TEST` (
        `id` INT ...

32. Adding aggregate function to external H2 database (SOLVED)    stackoverflow.com

Hello experts of the world :) I'm trying to create an aggregate function in my H2 database using Java. The function should return a custom median calculation from the given Double column. This calculation ...

33. Gerrit remove Need Verified +1 (Verified)    stackoverflow.com

I just installed a Gerrit server and wish to get rid of the Need Verified +1 (Verified) permission. Our team would only like to +2 changes instead of doing both things. I tried ...

34. Heap space error and H2 database corruption    stackoverflow.com

For our multithreaded application that uses H2 database, we saw the following error in our logs immediately following a heap space error:

java.util.concurrent.ExecutionException: java.lang.OutOfMemoryError: Java heap space ...

35. How to access the development database with the Play! framework?    stackoverflow.com

I want to see the tables of my Play! application with the H2 console, but all I see is a list of internal tables of the db engine. How can I ...

36. H2 database> How to compact / vacuum while running?    stackoverflow.com

Heading

In one of my projects I am using h2 database with file storage. According to h2 db documentation
"Empty space in the database file [is] re-used automatically. When closing ...

37. ORMLite + H2 error: "No database files have been found in directory..."    stackoverflow.com

I am very new to working with databases in Java. I am running an eclipse project that implements ORMLite over H2. The problem is that as long as I have just ...

38. Custom control to access H2 Database (JDBC) from .Net environment    stackoverflow.com

Our application needs to communicate via a H2 database (JDBC) from .Net Framework (WinForms). I have experience with C#/.Net Framework programming, but I need some guidance with respect to the following ...

39. H2 createTcpServer() does not create server?    stackoverflow.com

after reading the H2 documentation, I wrote this simple application to create a H2 database in a local directory: 

public static void main(String[] args) throws SQLException {

    ...

40. H2 database error: Database may be already in use: "Locked by another process"    stackoverflow.com

I am trying to use the H2 database from a Java application. I created the database and its tables through the H2 Console and then I try to connect from Java ...

41. NetBeans + H2 database    forums.netbeans.org

Hi There, Just wondering if anybody out there has ever used netbeans to create a database application using the H2 database in the embedded mode. I saw something about a project ...

42. H2 database locking    coderanch.com

Hi, I'm working with h2 db. My problem appears when I run my web app thru apache tomcat, the app is working with the db, and when it goes, I can't reach the db thru the manager - I get a message that the db is in use. What can I do ? Thanks.

43. H2 database consule lockings    coderanch.com

44. H2 database - index not found ???    coderanch.com

45. H2 database - how can I know if the database exsists or not    coderanch.com

46. H2 Database speed: file vs. tcp    coderanch.com

Hello Ranchers, I have encountered something which I find counter-intuitive and therefor probably has a direct problematic cause. I am getting significantly slower performance from my h2 database when connected to the database directly to a file (embedded only mode) vs local server (tcp://localhost:8082). Using the exact same identical program with the only change being the url of the database there ...

47. H2 database locking    forums.oracle.com

Hi, I'm working with h2 db. My problem appears when I run my web app thru apache tomcat, the app is working with the db, and when it goes, I can't reach the db thru the manager - I get a message that the db is in use. What can I do ? Thanks.

48. Anyone with experience of the H2 (son of HSQL) database?    forums.oracle.com

What's puzzling me is that a fairly straight forward SELECT statement, when executed via a PreparedStatement in my java program currently takes 41 seconds to return from the executeQuery statement. (i.e. before returning the first row). On the other hand, when I cut an past the SQL into the console program it comes back in a couple of seconds. I tried ...