My question is how can I manually add records to hsqldb database. I mean using command line or some client. I know I can use hsqldb manager but I cannot execute any query with it. It says that there ...

I m evaluating the performance of an experimental system setup on an 8-core machine with 16GB RAM. I have two main-memory Java RDBMSs (hsqldb) running, and against each of these I run a TPCC client (...

I am using Hibernate annotations and entity manager (JPA) with HSQLDB. So I have an entity with an enum field: @Enumerated(EnumType.STRING) @Column(name = "access_level") public AccessLevel ...

I m trying to spot-test an Oracle backed database with hsqldb and dbunit, but I ve run into a snag. The problem is with the following EJB-QL (simplified a bit): SELECT o FROM Offer o WHERE :...

I wish to store UUIDs created using java.util.UUID in a HSQLDB database. The obvious option is to simply store them as strings (in the code they will probably just be treated as such), i.e. varchar(...

how to migrate Grail s HSQLDB embedded database(That contains my App s Data that I don t want to lose) into external one, such as MySQL or ApacheDerby?

I have a project of persistence with spring and hibernate built with maven, I m running the testing using Junit and a test database HSQLDB, when I do a test first initialize the database HSQLDB in ...

DROP VIEW V1 IF EXISTS; DROP TABLE T1 IF EXISTS; CREATE TABLE T1 (id INT, name VARCHAR(32), age int); CREATE VIEW V1 AS (SELECT * FROM T1 WHERE age < 21); I have no problem to execute the SQL ...