Questions tagged [hsqldb]
9 questions
3
votes
1 answer
HSQLDB get next value for IDENTITY column
I'm looking for a query to get the next IDENTITY value of a HSQL table. Like if I were to insert a new row into a table that has an auto id column, what value would that turn into.
I did some research and couldn't find anything…
BrainStone
- 143
- 1
- 8
2
votes
0 answers
What's the quickest way of porting thousands of PostrgreSQL queries to HSQLDB?
Lately we have been tasked with porting some existing DB infrastructure from PostgreSQL to HSQLDB. Yes, I know what you're thinking (why on Earth would anybody do such a thing?). But unfortunately for reasons I can't explain here this is our task…
Klangen
- 121
- 4
1
vote
1 answer
How to compute a membership expiration date on SQL
This is a follow up to this previously posted question. I'm using LibreOffice Base to work with some membership data. Further expansion might be possible in the future, but for now, the embedded database is fine, and it provides portability (I could…
phollox
- 123
- 3
1
vote
1 answer
Query to partially summarize data in a table using SQL
I'm learning how to handle databases, so this is a trivial question, and quite likely has been answered already. I'm just not familiar to the lingo and have no idea how to search for it (although I tried).
My data is on LibreOffice, which runs…
phollox
- 123
- 3
1
vote
1 answer
Will Derby, H2, or SQLite give faster load time and/or smaller file size than HSQL?
I have some flat files with the following columns; 3 integers, 3 reals, and 1 varchar(20). For querying I need an index that contains both 1 of the integer columns and the varchar column. Each file is around 1.8GB in size with around 38 million…
Edmund
- 733
- 3
- 10
- 23
1
vote
1 answer
HSQL DB grows large and is full of zeroes
I have an application whose HSQL database grows awfully large for some users, but not others. When I received one example where this problem happenned, I discovered that the database is nearly empty - it's almost 16GB of zeroes and only a couple…
JohnEye
- 173
- 9
0
votes
1 answer
How to determine character encoding in Hyper SQL database
I have Hyper SQL database and I don't know what is current character set. Is it set for whole DB or it can be different for every table? How to evaluate encoding in my base?
R. Nec
- 159
- 1
- 1
- 5
0
votes
2 answers
Group by arbitary monthly time period
I want to group the following data by an user defined period:
+------------+--------+
| DATE | Amount |
+------------+--------+
| 2019-03-12 | 300 |
| 2019-03-15 | 1500 |
| 2019-03-25 | 2500 |
| 2019-03-25 | 3000 |
| 2019-04-04 | …
Marius K.
- 103
- 1
0
votes
1 answer
Hsqldb transaction log rollback cause
I'm fairly new to the database world but I had to use an hsqldb-2.0.0 database for a netflow collector software. As the software shows no output even if the client is collecting the flows I investigated the database and it seems that after…
huginnmuninn
- 9
- 2