Accessing H2 database - no tables found

[Ron Grosberg]

Hi,

Our team is starting to work on JIRA and we are still on the H2 database.

I need to do something on the database (temporarily unlock a locked field - it's another story and also deserves a discussion but not here :)), I went through the steps here:

https://confluence.atlassian.com/jirakb/how-to-unlock-a-locked-jira-software-field-779158866.html

connecting to the H2 Database according to this:

https://confluence.atlassian.com/jirakb/accessing-jira-s-h2-embedded-database-776818136.html

And indeed I was able to login to the database using the XML fie and the sa user but it does not find the tables... when I try to query wich tables I have

(SELECT * FROM INFORMATION_SCHEMA.TABLES)

I don't see any JIRA table.

any idea? I have no clue how to even debug what I am dong....

[DPKJ · Accepted solution]

Please recheck that you are connected to database.

and try query this like this,

SELECT id FROM PUBLIC.JIRAISSUE LIMIT 10;

[Ron Grosberg]

So... it was my bad, I had a mistake in the URL I used.... but for some reason the H2 did seem to connect normally and I could run SQL queries which is what caused me to think I was connected correctly....

Thanks for helping!