nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How can I connect Jira database to external application?

kumar

Dear Atlassian Group,

I am tring to produce the report using Netbeans in the Windows Environment from Jira Database HSQL where I need to connect the database remotly which exists in the linux environment(/var/atlassian/application-data/jira/database/jiradb).If i copy and paste in the Windows Environment,HSQL database connection is working fine as follows;

Class.forName("org.hsqldb.jdbcDriver");

conn = DriverManager.getConnection("jdbc:hsqldb:"

+ "file:C:\\Kumar\\Publish to Others\\28Jan2013\\jiradb",//db_file_name_prefix,

"sa", // username

"");

but I want to connect Jira database remotly. Please help me how can I connect HSQL database and give the connection string("DriverManager.getConnection("jdbc:hsqldb:"","sa","") "

Accepted answers

All comments

Onkar Ahire

Hi Kumar,

Dowaload the jar file http://www.java2s.com/Code/Jar/h/Downloadhsqljar.htm

and http://www.javaworkspace.com/connectdatabase/connectHSQLDB.do

this program will help you to connect to hsql database but please use this for read only,

The below link will help you to understand the JIRA database to generate desired reports.

https://developer.atlassian.com/display/JIRADEV/Database+Schema

Cheers,

kumar

Dear Onkar Ahire

Thanks for your quick reply.It works me , if i have a database file inside the localhost but In my case, My application(Report Application) access the external database(HSQL database) where Jira Application is running.Here I want to access the database remotly where Jira is running on linux.So I need the correct connection string like "DriverManager. getConnection ("jdbc:hsqldb: "", "sa" , "").

Linux Database Path="/var/atlassian/application-data/jira/database/jiradb"

Thanks in advance.

Best Regards

S.Indirakumar

Nic Brough -Adaptavist-

You won't get remote access to an HSQL database - there's nothing there publishing a connection. I don't know of any programs that would provide one either.

However, I'm not sure why you're bothering. The HSQL database is not a production system, you'll need to connect to the actual production database with your code, and they do expose remote connections for jdbc to connect to.

kumar

Dear Nic Brough

Thanks for your reply. We are using HSQL database in the production which is running on the linux machine. I am writting the application (Report) in the Windows XP machine using the Netbeans which connect to HSQL Database which I have brought from linux database .My application is working fine with local HSQL database, but i have the problem with connecting to HSQLdatabase which runs on linux.If you have any altermative idea,Please advise me

Thanks

Best regards

S.indirakumar.

Nic Brough -Adaptavist-

Right, there's so much wrong here I don't know where to start.

1. I already said "HSQL does not publish a connection". You can connect to it on the machine the data is on. There's nothing remote unless you find something that publishses it

2. YOU MUST NOT USE HSQL IN PRODUCTION.

You should not waste any time building reporting applications or trying to get HSQL to be accessible remotely, your main piece of work at the moment should be to get Jira on to a proper database as soon as possible.

kumar

Dear Nic Brough,

Thanks for your reply. In order to change the database from HSQL to MYSQL, I should clarify the management why we should not use HSQL in the production.I saw the warning message in the installation of Jira which says "You should not use HSQL in the production".Presently I am in the position to explain to management why we should not use in the production, but I don't know what are the reasons. Could you explain me why we should not use HSQL in the production sothat i can explain to management regarding this.

Furthermore I am familiar with MYSQL which is recommended by Atlassian Group , So i am going to migrate to this database.Please advise me on this as well

Thanks

Best Regards

S.Indirakumar

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

database

hsql