Connecting to hsql db of datahub in local set up

[rahulverma94]

Hi Experts,

Can you help me with steps to connect to the hsql database tables for local datahub set up? Currently I can not query using the hsql jar present in the lib folder of the datahub server.

Regards Rahul

[former_member333910]

Please provide more details about your problem. Errors? Relevant section of the log?

[rahulverma94 · Accepted solution]

Thanks for the workaround. I resolved the issue by replacing HSQL DB with MySQL DB on my local machine and then query on the datahub db schema with Razor SQL as usual.

[Former Member]

In HSQL either you can connect via hybris application or by below command but one at a time as HSQL only supports one connect at a time.

STEPS

• go to \hybris\bin\platform\lib\dbdriver>

• Run java -jar hsqldb-2.2.9.jar

• A pop will open and Enter below configuration

• 1) Type = HSQL Database Engine Standalone

• 2) Driver - org.hsqldb.jdbcDriver

• 3) Path - jdbc:hsqldb:file:E:\Hybris65\hybris\data\hsqldb\mydb

• Enter OK

Tested at my end

[rahulverma94]

, It does not work with Razor SQL as hsql is in session db and can not be queried upon while the server is up and running.

[Former Member]

Hi ,

DataHub ootb uses the same HSQLDB , so no additional steps needed , But if you want a Gui to query with HSQL , you need to use some tools like RazorSql to work with that ,

Thanks ,

D

[former_member333910]

Ae you saying that Data Hub connects and runs successfully using HSQLDB but that you want to query it separately? If so, HSQLDB has limited capability to query from outside the connected application. You can consult the HSQLDB docs for more info on your options (be sure to consult the docs for the HSQLDB version that is shipped with Data Hub).

However, I would not go this route. It is quite simple to run a local setup using MySQL which provides much more robust querying capabilities.

[rahulverma94]

Simply put, How do I query on the hsql db of datahub?