Stack Overflow
Stack Overflow

Questions tagged [hsqldb]

HSQLDB (HyperSQL Database) is a relational database management system. It is written in Java.

HSQLDB (HyperSQL Database) is a relational database management system.

HSQLDB can be used inside Java application processes to serve local databases. HSQLDB also includes a database server, which allows access over the network.

Each HSQLDB instance can serve multiple databases. Each database can contain multiple schemas. The databases can be all-in-memory (mem: url) or persisted to disk (file: url). Persisted databases can use a mix of tables that are always kept in memory (MEMORY tables) and tables that are only cached in memory (CACHED tables) which can grow to many gigabytes and beyond the available memory.

HSQLDB is extremely fast, especially when used in memory, or when the database is relatively small.

HSQLDB supports a very extensive subset of the ISO Standard SQL:2011. It also features SQL syntax compatibility modes which simplify porting applications written for another database engine.

HSQLDB supports user-defined stored procedures, functions, aggregate functions, and triggers. These can be written in Java or in SQL procedural language (PSM). It also features an extensive list of built-in functions.

HSQLDB is fully multi threaded. It can operate in three different transaction models: the Two Phased Lock model (TPL), the Multiversion Concurrency Control Model (MVCC) and a mixed, pessimistic multiversion model with snapshot isolation. In each model, a transaction can run in read committed or serializable isolation levels.

HSQLDB has been around since 2001 and is supported by many Java frameworks and tools.

2521 questions
9
votes
6 answers

org.hsqldb.jdbcDriver ClassNotFoundException while running junit test for a method

I am using one method which return me a datasource. The method is as below: public static DataSource getDataSource(){ String url; //url="jdbc:hsqldb:file:"+filePath; url =…
Chitresh
  • 3,022
  • 12
  • 35
  • 40
9
votes
3 answers

Failed to get driver instance

I'm new to Spring (Boot) and trying to get a pooled database connection to a HSQLDB server. pom.xml org.springframework.boot spring-boot-starter-parent …
Pacman
  • 568
  • 3
  • 6
  • 17
9
votes
3 answers

HSQLDB cryptic exception message: "feature not supported"

I have JDBC code which inserts into a database table by executing a PreparedStatement. When I run the code on an in-memory HSQLDB database (as part of a JUnit test) I get a SQLFeatureNotSupportedException with the only information being the message…
James Adams
  • 8,448
  • 21
  • 89
  • 148
9
votes
5 answers

hibernate - could not execute statement; SQL [n/a] - saving nested object

I'm trying to save a nested object using hibernate and I receive could not execute statement; SQL [n/a] Exception CODE @Entity @Table(name = "listing") @Inheritance(strategy = InheritanceType.JOINED) public class Listing implements Serializable { …
Paul
  • 1,325
  • 2
  • 19
  • 41
9
votes
1 answer

Link a sequence with to an identity in hsqldb

In PostgreSql, one can define a sequence and use it as the primary key of a table. In HsqlDB, one can still accomplish creating an auto-increment identity column which doesn't link to any user defined sequence. Is it possible to use a user defined…
Candy Chiu
  • 6,579
  • 9
  • 48
  • 69
9
votes
1 answer

Embedded HSQLDB persist data to a file

I am creating a spring based web application that uses embedded hsqldb. My spring config is pretty simple:
user1745356
  • 4,462
  • 7
  • 42
  • 70
9
votes
2 answers

SQL standard UPSERT call

I'm looking for a standard SQL "UPSERT" statement. A one call for insert and update if exists. I'm looking for a working, efficient and cross platform call. I've seen MERGE, UPSERT, REPLACE, INSERT .. ON DUPLICATE UPDATE but no statement meets the…
BobTheBuilder
  • 18,858
  • 6
  • 40
  • 61
9
votes
2 answers

Maven hangs while running test case Eclipselink & hsqldb

Using jps and jstack I can get to the offending waiting thread but don't know how to troubleshoot it or what is causing it. See below the Maven dependencies and the jstack result and the waiting thread with tid=0x000000000022c000. Analysing further…
SkyWalker
  • 13,729
  • 18
  • 91
  • 187
8
votes
1 answer

Java (JVM) on ARMv7 (more specifically Cubox or BeagleBoard)?

I was wondering if anyone have gotten Java up and running on a BeagleBoard or Cubox? I'm thinking about buying one for a project I'm working on on my spare time, but as parts of this project is written in Java I first wanted to know if these tiny…
joscarsson
  • 4,789
  • 4
  • 35
  • 43
8
votes
3 answers

Multiple Java Applications accessing one HSQLDB causes app to hang

This is semi-related to my previous question. As that previous question states, I have a desktop app that calls off to a different Main method that will kick off a particular process. Both the desktop app and the separate Main method will access…
digiarnie
  • 22,305
  • 31
  • 78
  • 126
8
votes
1 answer

DROP NOT NULL CONSTRAINT

How to drop not null constraint that will work both in PostgreSql and HSQL? I'm using: ALTER TABLE tablename ALTER COLUMN columnname DROP NOT NULL; But it's not working in HSQL. This column was created: columnname TEXT NOT NULL,
kostepanych
  • 2,229
  • 9
  • 32
  • 47
8
votes
2 answers

Hsqldb - Return a Result Set from Stored Proc

I am trying to call a stored procedure in HsqlDB and return a Result Set My Stored proc is as follows CREATE PROCEDURE p_getTeamTasksForLastXDays(IN teamId BIGINT, IN numberOfDays BIGINT) READS SQL DATA DYNAMIC RESULT SETS 1 BEGIN ATOMIC …
Damien
  • 4,081
  • 12
  • 75
  • 126
8
votes
3 answers

Junit HSQLDB - user lacks privilege or object not found - THIS_.oh-ordnbr

I am getting an exception when my column name contains hyphen "-" Entity : this is the entity name. @Entity @Table(name = "RequestHeader") public class RequestHeader implements Serializable { .... .... @Column(name =…
Ram Subramanian
  • 101
  • 1
  • 1
  • 4
8
votes
1 answer

SimpleJdbcTestUtils.executeScript and multilines script

I want to load SQL script files for my unit tests. As I am using Spring 2.5.2, I decided to use the SimpleJdbcTestUtils.executeScript() method to load my script file, using the following code: DriverManagerDataSource dataSource = ... // getting my…
Romain Linsolas
  • 79,475
  • 49
  • 202
  • 273
8
votes
3 answers

Is it possible to backup and restore HSQLDB database?

In my java project, i want to use HSQLDB database for my application so i am studying HSQLDB, i just want to know is it possible to backup and restore HSQLDB database from within application or from outside of application ?
FullStack
  • 665
  • 11
  • 26
1 2 3
…
99 100