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....
Please recheck that you are connected to database.
and try query this like this,
SELECT id FROM PUBLIC.JIRAISSUE LIMIT 10;
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.