SmartClient showcase locally HSQLDB question

[Blama]

Hi Isomorphic,

creating this testcase I wasn't able to recreate one or the errors I got (the double validation request). I assume this is because my DataSource has more fields an a more complicated validator.
In order to recreate this more complicated validator I need to add field to the ds.xml and therefore also columns to the mediaLibrary-table in your HSQLDB.

How can I access the HSQLDB and modify the table? I'd be happy to do that when your "start_embedded_server" is running or also when it's not running.
jdbc:hsqldb:file:localhost/isomorphic and
jdbc:hsqldb:file:C:\Users\myuser\workspace\libs\SmartClient_v121p_2025-07-29_Evaluation\smartclientSDK\WEB-INF\db\hsqldb\isomorphic/isomorphic
both only showed default schemas when used in DataGrip.

Thank you & Best regards
Blama

[Isomorphic]

You can get a SQL console to the embedded HSQLDB - just by running a command-line based on the .jars we ship, or by separately downloading the tools and just connecting:

https://chatgpt.com/share/68ae011e-7...b-ff593497144a

But it's also OK to just provide DDL for the tables and data in some other common database, like MySQL / MariaDB.

[Blama]

Hi Isomorphic,

that chat wasn't really helpful, in the end it worked with these settings:



Perhaps I had this before already, but did not notice it as DataGrip does not display your tables. But a select * from animals; did work.

I know that other databases are also possible and did this before for BuiltInDS based samples, but I thought I'll try this now, as this might actually be easier to setup for me and recreate for you once it is working.

Thank you & Best regards
Blama

[Blama]

Hi @all,

this worked, and eventually DataGrip did also show the tables under the PUBLIC schema.
As the connection to the database is though the filesystem and not a database service, for obvious reasons only one of Showcase and DataGrip can access the database at a time.

Regarding adding my column, this also worked but there is a pitfall. SmartClient comes with hsqldb-2.3.4.jar and by default DataGrip uses HSQLDB 2.7.0 right now.
When you edit the DB with the newer version, the SmartClient HSQLDB then can't read the database files any more. So always use the same version SmartClient uses also in DataGrip. This is easily done, as you can just change this in DataGrip.
Updating SmartClient HSQLDB to 2.7.0 is not possible (at least in 12.1) because of the Java version used.

Best regards
Blama