can we view tables in HSQL database in hybris

[Hari_prasad]

hi experts

I want to know whether can we view tables stored in HSQL databse

[Former Member · Accepted solution]

Let's assume, you have installed hybris at C:\HYBRISCOMM6400P_0-70002841. Please make sure that your hybrisserver is stopped.

Please follow the steps given below:

• Enter the following command from command prompt:

  C:\HYBRISCOMM6400P_0-70002841\hybris\bin\platform\lib\dbdriver>java -cp hsqldb-2.3.4.jar org.hsqldb.util.DatabaseManagerSwing

Note: Please use the version of hsqldb jar that is present in C:\HYBRISCOMM6400P_0-70002841\hybris\bin\platform\lib\dbdriver. It will open a dialog box.

• Enter jdbc:hsqldb:file:C:\HYBRISCOMM6000P_0-80001481\hybris\data\hsqldb\mydb in the URL field of the dialog box and press 'Ok'.

• Now, you should be able to see the tables. Please test the same by executing the SQL command 'SELECT * FROM PRODUCTS'

Screenshot-1:

Screenshot-2:

[xianfeng187 · Accepted solution]

nice , get it