SELECT « hsqldb « Java Database Q&A

1. hsqldb extremely slow with SELECT * FROM [table]

Im trying to start an embedded version of hsqldb, and it works fine with the tool that are included, they're not slow or anything. But when i try to use the following ...

2. Selecting from a HSQLDB table with a BIT column

I have a table with a column of data type bit.

> CREATE MEMORY TABLE Dummy (name varchar(10), flag bit)
> INSERT INTO Dummy VALUES ('foo', 1)
> INSERT INTO Dummy VALUES ('bar', 0)
> ...