2,542 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
2
votes
2
answers
85
views
hsqldb create function not finding the implementation
I want to use SymmetricDS on an embedded HSQLDB. Symmetric needs some administrative tables and functions for this. These can be created using symadmin, for one of the functions it executes this SQL:
...
0
votes
0
answers
115
views
Query with limit offset - bad performance despite index
Hsqldb 2.7.4
If I use OFFSET in an index query, the index should be used for offset calculation, as far as I understand the documentation!?
That does not work for me. Any ideas?
SELECT id FROM news ...
-1
votes
2
answers
110
views
Query for "grouping" rows
I'm trying to set up a query that would display the data in a certain way, but I can't manage it.
Tables:
CREATE TABLE T_EMPLOYEES (
EMP_ID INTEGER IDENTITY NOT NULL,
EMP_LASTNAME VARCHAR (32) ...
1
vote
2
answers
58
views
Adding decimal value to time value
I'm looking to add decimal values to times. Table columns :
ARRIVAL TIME NOT NULL
DURATION DECIMAL (4,2) NOT NULL
For DURATION, values are entered as follows: 1, 1.25, 1.5 or 1.75
In a query, I'd ...
0
votes
1
answer
59
views
Difference in handling of reserved SQL keywords by HSQL server and in-memory mode?
I have a small spring boot application that uses HSQB in server mode for its database and liquibase to maintain the schema. This works fine.
spring.datasource.url=jdbc:hsqldb:hsql://localhost:5678/...
0
votes
0
answers
45
views
How to initialise the look and feel for hsqldb DatabaseManagerSwing v2.7.4
I have recently upgraded our version of hsqldb to v2.7.4. We use the DatabaseManagerSwing Frame in our Java Swing desktop application. We initialise the look and feel for our app to a custom look and ...
-1
votes
1
answer
38
views
Hypersql (HSQL) startup time and heap memory uses
I am using HSQL with java, HSQL database file size is 3 GB then it need 10 GB heap memory and approx. 5-7 minute database boot time while creating datasource.
Need suggestions to bring down heap ...
1
vote
2
answers
89
views
Column called index issue when upgrading to hsqldb 2.7.4
I'm trying to upgrade from hsqldb 2.4.1 to 2.7.4.
I have an alter statement of the form
ALTER TABLE abc ADD Index INT DEFAULT 0 NOT NULL
Executing this statement results in this exception
Caused by: ...
0
votes
1
answer
32
views
How to temporarily disable system versioning with HsqlDB
On a HsqlDB 2.7.3 database I use tables with system versioning.
I would like to know if it is possible to deactivate system versioning temporarily and more precisely for the duration of an update, a ...
0
votes
1
answer
104
views
CAST AS DECIMAL returns text, why?
In a Libre Base query can anyone say why the following would fail to produce a numeric character with 4 decimals and instead return a column formatted as text showing two decimals? I want the query to ...
0
votes
1
answer
82
views
HSQLDB mvlocks concurrency model blocks reads when used with Hibernate
When using a HSQLDB with Hibernate and Spring, I run into a concurrency issue. I have two threads accessing the same table. One thread has a long running read write transaction, the other thread ...
2
votes
0
answers
146
views
Hsqldb and PostgreSQL string_agg: object not found
My Spring Boot web application uses PostgreSQL v12 for production and h2 v2.1.214 embedded database for unit testing.
It worked well until I have a native query to test.
This query uses the string_agg ...
0
votes
2
answers
108
views
HsqlDb : how to make sure that data is really written to disk and crash resistant?
I have a java EE web application running under Tomee.
HsqlServer as well as the clint code is running within the same Java EE web application.
Everything is running fine.
But when the server crashes, ...
0
votes
1
answer
102
views
Connect to HSQLDB running on Tomcat Server
I have a web service application that includes code to start HSQLDB when the application is loaded into the database. Everything within the application functions as expected, including connecting to ...
-1
votes
1
answer
31
views
Building a minimal jar in Eclipse
I'm building a small java project in Eclipse and exporting a runnable jar with package library handling. The jar runs fine. The program needs an HSQLDB JDBC driver so the requisite jar is packaged. ...