Search code examples
intellij-ideahsqldb

HSQLDB select shows no data in intellij IDEA

i have created and rund successul this sql using HSSQLDB (Connection type Embedded) :

CREATE TABLE IF NOT EXISTS PUBLIC.T1 (name CHAR(25), age INTEGER NOT NULL);
insert into T1 (name, age) values ('lise',99);
insert into T1 (name, age) values ('fred',199);
insert into T1 (name, age) values ('paul',299);
select * from PUBLIC.T1;

i'm used to doing a select in jetbrains idea so that i can see the data.

Here with (HSSQLDB Connection type: Embedded) no data is shown to me (scceenshow below).

Are there none or how can I see them?

enter image description here

Connection type with this HSSQLDB is Embedded as you could see in the screeshot below:

Connection type: Embedded

enter image description here

comparision with sqLite (no problems):

Since I still have the problem that with hssqldb no data is displayed via the IDEA database window, I have tried SqLite once and it does not cause any problems at all (see Screenshot):

enter image description here

comparision with HSSQLDB file (no problems):

enter image description here

Solution

  • As @eh3rrera explains here https://github.com/eh3rrera/minitwit/issues/11#issuecomment-795467775:

    "... I'm not sure if IntelliJ can access it, I think it can only be accessed by the Java program that created it.

    Unlike an in-memory db, with db in a file, changes are persisted after the app exits, they're saved to the file. ..."