All Questions

Tagged with
Filter by
Sorted by
Tagged with
94votes
11answers
118kviews

View content of H2 or HSQLDB in-memory database

Is there a way to browse the content of an H2 or an HSQLDB in-memory database for viewing? For example, during a debugging session with Hibernate in order to check when the flush is executed; or to ...
user avatar
  • 2,128
91votes
2answers
85kviews

Which is better H2 or HSQLDB? [closed]

HSQLDB 2.0 is soon to be released. I wonder if it will outperform H2 since, as far as I know, most users prefer H2 than HSQLDB. I am interested in the MVCC support of HSQLDB 2.0. I have learned that ...
user avatar
  • 1,829
33votes
4answers
24kviews

Create an in-memory database structure from an Oracle instance

I have an application where many "unit" tests use a real connection to an Oracle database during their execution. As you can imagine, these tests take too much time to be executed, as they need to ...
user avatar
21votes
1answer
12kviews

File based h2 persisted but not loaded in Spring Boot

I made a small application based on Spring Boot: spring-boot-starter-web spring-boot-starter-data-jpa The application has simply one domain class Post.java. Accordingly there is a RestController and ...
user avatar
  • 558
9votes
2answers
12kviews

Junit with HSQL/H2 without Spring/Hibernate

I am trying to use H2 or HSQL for my unit testing. But my application is not of spring and hibernate. It seems most of the references are there only with spring and hibernate for HSQL/H2 in memory db ...
user avatar
  • 2,177
6votes
1answer
3kviews

How to retrieve column names from an in memory database?

Here's the code that gives me headaches: public List<String> listColumnsForTable(String tableName) throws SQLException { List<String> columns = new ArrayList<String>(); ...
user avatar
  • 9,301
6votes
0answers
4kviews

H2 vs HSQLDB vs Derby | In-memory RDBMS for a Reporting APP

I'm designing a Data REST API for the purpose of dynamic reporting. Basically, you pass in the data to it (along with the functions to manipulate the data) and it returns you a HTML with the functions ...
user avatar
  • 1,671
4votes
3answers
2kviews

Concurrency in embedded (in-proces) databases H2, Hsqldb, Apache Derby, SQLite (JDBC)

Is it possible to use embedded databases concurrently (read/write) on the same machine (no server) with different processes. And what about concurrent read/writes in one multithreaded process? Iam ...
user avatar
4votes
3answers
887views

Spring Boot + HSQLDB/H2 always displays 'port was already in use' on Windows 10

I am developing a Spring Boot application and I'm receiving the following error when I try to run the application with a embedded database(HSQLDB or H2, in-memory or file), even with the port not ...
user avatar
3votes
1answer
2kviews

How to integrate Kettle with H2

I am trying to integrate Kettle (v 5.4.0) with an in memory relational database like h2 or hsqldb. I tried some versions of h2 and hsqldb but I am not able to connect to these dbs from spoon in an ...
user avatar
  • 3,641
3votes
1answer
12kviews

SequenceGenerator problem with unit testing in Hsqldb/H2

I have tried using both Hsqldb and H2 for unit testing but facing problem with sequence generators. Field declaration looks like this. @Id @GeneratedValue(strategy=GenerationType.SEQUENCE, generator="...
user avatar
3votes
1answer
4kviews

Which embedded RDBMS should I use with Java? Why? What about backup and maintenance? [closed]

I'm relatively new to Java and using DBs with it, and I need help deciding which embedded RDBMS to use with a simple J2SE system. My criteria and concerns are: performance, low system requirements, ...
user avatar
  • 39
2votes
1answer
15kviews

How to integrate HSQL DB with java application [closed]

I would like to integrate HSQL in my Java application for testing purposes. Is there any tutorial that describes in a simple way how to integrate it-I want to distribute it with my app. I'm not ...
user avatar
  • 8,804
2votes
2answers
1kviews

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 ...
user avatar
2votes
4answers
1kviews

H2, HSQLDB or any other embedded database using an InputStream

Can I use H2, HSQLDB, or any other embedded database, with a database from an InputStream instead of a file? I'm planning to use AssetManager.open() on Android, which can return an InputStream in ...
user avatar
  • 57.1k

15 30 50 per page