Can we connect JIRA database through JAVA JDBC API ?

Ramesh Udari1 May 24, 2015

Hi,

I would like to ask question regarding JIRA database. Can we connect JIRA database and update tables(tables created trough active objects) using JAVA JDBC API ?. If we do so, is there any impact on JIRA ?.

1 answer

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

Post a new question

2 votes
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 24, 2015

Yes, you'll break it.  JIRA maintains an index and caches, and if you write to the database directly, you won't be updating those, so they'll go wrong and you will end up with corrupted data that may not even be recoverable.

Ramesh Udari1 May 24, 2015

Hi Nic, Thanks for quick update. Here my point is the i want to play with active objects tables, which do not have any index and cache dependency. Let me give you details about complete story. I have created entity(Table) in jira database through active objects and this table contains only our custom application data(custom data), which is not related to JIRA indexes and cache. I have situation where i want to do bulk update on this table, which is not possible with active object api. To achieve this i want to connect jira database and update that table. Is it possible or not ?

Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 24, 2015

No, don't do it. I'm not sure where you get the idea that AO tables are not cached, because they are - I've had to unpick the damage done by SQL updates to one of them quite recently. Use the API. A bulk update is a simple matter of iterating in your code.

Ramesh Udari1 May 25, 2015

I have around 1 lack records in that table and iterating each records is time consuming issue.

Ramesh Udari1 May 25, 2015

Hi Nic, Any suggestion on my above comment.

TAGS
AUG Leaders

Atlassian Community Events