I have installed the atlassian JDK. Now i want to look into all the projects that i createdby looking into the DB. Since i am using HSQLDB and also i have atlassian SDK installed, how can i see the tables list, their columns in the DB? I did refer https://confluence.atlassian.com/display/JIRA/Running+SQL+commands+in+a+HSQL+databasebut i am unable to find database subdirectory if i go by the tutorial link. I think since i installed SDK version of it this could be the reason. But can anyone help me to know is it still possible to look into the HSQLDB columns,tables if we have atlassian SDK?
i was unable to find that file. this is the content of target/jira/home for a JIRA 5.2.11 plugin made with SDK drwxrwxr-x 3 alexej alexej 4096 Jan 16 17:55 caches drwxrwxr-x 3 alexej alexej 4096 Jan 16 17:55 data -rw-rw-r-- 1 alexej alexej 411 Mai 28 2014 database.properties -rw-rw-r-- 1 alexej alexej 3859074 Jan 16 17:55 database.script -rw-rw-r-- 1 alexej alexej 325 Jan 16 17:55 dbconfig.xml drwxrwxr-x 2 alexej alexej 4096 Jan 16 17:55 export drwxrwxr-x 4 alexej alexej 4096 Jan 16 17:55 import drwxrwxr-x 2 alexej alexej 4096 Jan 16 17:55 log drwxrwxr-x 2 alexej alexej 4096 Jan 16 17:55 logos drwxrwxr-x 2 alexej alexej 4096 Jan 16 17:55 monitor drwxrwxr-x 5 alexej alexej 4096 Jan 16 17:55 plugins
In my scenario i have installed the atlassian jdk in D: drive. So this was the path D:\JIRA\amps-standalone\target\jira\webapp\WEB-INF\lib where my hsqldb-126.96.36.199 JAR FILE was present. Now in cmd prompt navigate to the this path D:\JIRA\amps-standalone\target\jira\webapp\WEB-INF\lib . Run this command java -cp hsqldb-188.8.131.52.jar org.hsqldb.util.DatabaseManager. You should be able to view the HSQL database. Default user id is sa and password is blank.
Thanks Onkar. I could get the HSQLdb manager as i listed in the comment section above. But i didnt get any tables in it. When i run the jira i can see some projects, but when i check in the tables list of the db manager there's nothing in it. why is it this way?
I followed this tutotial https://confluence.atlassian.com/display/JIRA/Running+SQL+commands+in+a+HSQL+database
Command : The below shows the command at the workign directory command prompt
D:\MY WORK\View Issue Plugin\tutorial-jira-add-content-to-view-issue-screen\target\jira\webapp\WEB-INF\lib> java -cp hsqldb-184.108.40.206.jar org.hsqldb.util.DatabaseManager -user sa -url jdbc:hsqldb:D:/MY WORK/View Issue Plugin/tutorial-jira-add-content-to-view-issue-screen/target/jira/home/database/jiradb
[Note: So it was my turn for Friday Fun and sadly I was sick thanks to rubbish sinus infection... so apologies to most of Europe and Asia for the delayed post. However, I finally got out of bed for t...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs