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
0
votes
1 answer

How to know if Hsqldb "MERGE INTO" has made an insert or an update

Is it possible that a procedure using MERGE INTO returns the status of the action performed (inserted or updated). I use Hsqldb 2.5.0.
psilocybe
  • 35
  • 6
0
votes
2 answers

Hibernate not updating database (despite it commits and reads it)

I have no exceptions and everything seems to be okay, but after inserting some data into the database it doesn't persist. I don't know if I need some specific annotation or I failed at some Spring configuration. Entity…
Niedon
  • 15
  • 1
  • 8
0
votes
1 answer

HSQL embedded connection

I'm trying to connect to my hsqlDb via java script but what ever i add in the db it can't be saved and it doesnt generate any error ! the same when i try to get data from the db and i use Result.next() it generete nulPointerExeption even i have data…
Fatiha IMOUSSAINE
  • 330
  • 1
  • 9
0
votes
1 answer

HSQL problem when using TIMESTAMP value as IN parameter in stored procedure

Overview HSQL IN parameter of type TIMESTAMP doesn't work as expected for HSQL stored procedure. Given the following DDL : CREATE TABLE TS_STORE ( ID_COL VARCHAR(20) NOT NULL PRIMARY KEY, TS TIMESTAMP ); A DML statement such as : INSERT…
garfield
  • 571
  • 9
  • 21
0
votes
1 answer

Cannot persist in HSQLDB using JPA 2.0, Spring 2.5.6, Hibernate 3.6.1 and Maven

I'm trying to setup Spring using Hibernate and JPA, but when trying to persist an object, nothing seems to be added to the database. I'm using the following:
Noesje
  • 1
  • 1
0
votes
1 answer

HSQLDB 2.4 How to use UNIX_MILLIS() as default value for BIGINT column

I run the next SQL (JDBC) CREATE TABLE IF NOT EXISTS PUBLIC.MY_DATA( ID BIGINT IDENTITY PRIMARY KEY NOT NULL, ..., LAST_MODIFIED BIGINT DEFAULT UNIX_MILLIS() NOT NULL) and get SQLSyntaxErrorException: unexpected token: UNIX_MILLIS But according to…
Gennadij Degterjow
  • 98
  • 7
0
votes
1 answer

setting sequence value as default for column in HSQL

I have a query that looks like this in postgres: ALTER TABLE alias_table ALTER COLUMN iddb SET DEFAULT nextval('alias_table_iddb_seq'); I would like to translate it into hsql. I know that I can do it by enabling PostgreSQL syntax Compatibility: SET…
gawi
  • 2,843
  • 4
  • 29
  • 44
0
votes
1 answer

Hibernate Entity with no Primary Key and nullable fields

I've seen similar cases but not this exact combination of difficulties and any solutions I've seen have not been working. I'm upgrading some library from Spring-data 1.X and Hibernate 4.X to Spring-data 2.X and Hibernate 5.X and I think this is…
Sloloem
  • 1,587
  • 2
  • 15
  • 37
0
votes
0 answers

hsqldb raise a java.lang.IncompatibleClassChangeError when executing Open/Libre Office Uno XPreparedStatement.executeQuery()

I had fun writing an Open/Libre Office Python extension gContactOOo allowing to recover these Google contacts under Open / Libre Office. To do this, I wrote a Driver, which loads when the protocol: sdbc:google:people is called and returns an…
psilocybe
  • 35
  • 6
0
votes
0 answers

How to use INTERVAL types in HSQL JRT function?

I am trying to create a JRT function that accepts a parameter of type INTERVAL. My query can provide any type of INTERVAL but I'd prefer to use INTERVAL DAY type if possible. According to the HSQL documentation, my function should look something…
Jezor
  • 3,253
  • 2
  • 19
  • 43
0
votes
1 answer

How to set connect URL to connect to more than 1 databases in HSQLDB

I've started the HSQLDB server with two databases open. i'm using the server protocol for connection i.e. jdbc:hsqldb:hsql://localhost/portdb portdb is just one database, how can i tweak this URL such that it connects to this and the other db? I've…
shrekish
  • 39
  • 4
0
votes
1 answer

HSQLDB - Read-only mode does not fetch the latest records inserted by the applications

I am using HSQLDB in my application and want to check the rows inserted by the application without stopping my application. Though i am able to connect to the database file in read-only mode, the "select * from table-name" does not fetch the latest…
user2048204
  • 729
  • 4
  • 13
  • 27
0
votes
0 answers

How to close a CMD window from Java code, which was opened from command line?

I am running a batch file that Opens CMD CD to HSQLDB home directory Start Database The database server starts in a CMD window. I have added a Shutdownhook in my program. Inside it's run method I need to close the server/CMD window. I have tried…
Aman jangra
  • 268
  • 1
  • 16
0
votes
1 answer

How to get the window closed event after I invoke the main method of DatabaseManagerSwing class in HSQLDB jar?

I am using HSQL in memory database in my java application. I am opening the GUI manager provided by the HSQLDB by invoking main method of DatabaseManagerSwing class. It opened successfully. I need to register a callback or notified when the user…
Aman jangra
  • 268
  • 1
  • 16
0
votes
1 answer

Don't get connection to HSQLDB database

I have already existed database. When I test my connection, I get this exception java.sql.SQLInvalidAuthorizationSpecException: invalid authorization specification: SA at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at…
Krit
  • 1
  • 1
1 2 3
…
99
100