All Questions
46
questions
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 ...
- 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 ...
- 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 ...
- 76.4k
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 ...
- 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 ...
- 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>();
...
- 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 ...
- 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 ...
- 51
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 ...
- 260
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 ...
- 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="...
- 6,526
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, ...
- 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 ...
- 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 ...
- 788
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 ...
- 57.1k