Why my HSQL console shows not table listed?

Hi All, I have followed the instruction at http://confluence.atlassian.com/display/JIRA/Running+SQL+commands+in+a+HSQL+database and open the HSQL Database Manager, however, I only see a empty list to the left under jdbc:hsqldb:database/jiradb

is there some configuration I need to do the see the tables? Thanks.

1 answer

0 votes

You need to make sure that the path specified in the url parameter is valid (pointing to the right folder). Otherwise, you will see the empty list.

You can also supply absolute path in the url foe e.g.

java -cp hsqldb-1.8.0.5.jar org.hsqldb.util.DatabaseManager -user sa -url jdbc:hsqldb:C:\studio\jira-home\database\jiradb

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.