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 ?.
Community moderators have prevented the ability to post new answers.
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.
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 ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I have around 1 lack records in that table and iterating each records is time consuming issue.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.