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; } } }

Port Jira connect plugin's database to server plugin

Dhara

I am porting existing JIRA connect plugin to server architecture. In connect, i was using mysql database with jdbc connection.

1> Can i directly use connect's mysql database in server plugin?

2> If not, then i am fine with Active Object too. But i am not getting exact detailed documentation on active objects. (How to create combo unique key, Joins between tables).

Accepted answers

Boris Georgiev [Appfire]

Server plugins should use Active Objects to store data - this is the recommended approach. If for some reason AO does not work for you you can always connect to other database, but this makes things a lot more complicated - for example:

You should bundle the appropriate JDBC connector
You need a UI for providing db connection settings - host, port, user, etc..
Who will create the database for your add-on ?
etc...

Here're some useful guides on Active Objects

https://developer.atlassian.com/docs/atlassian-platform-common-components/active-objects

https://developer.atlassian.com/docs/atlassian-platform-common-components/active-objects/getting-started-with-active-objects

And about the JOINS

https://developer.atlassian.com/docs/atlassian-platform-common-components/active-objects/developing-your-plugin-with-active-objects/the-active-objects-library/manytomany-relationship

https://developer.atlassian.com/docs/atlassian-platform-common-components/active-objects/developing-your-plugin-with-active-objects/the-active-objects-library/onetomany-relationship

All comments

Nic Brough -Adaptavist-

Yes, as long as it's not the JIRA database - you must never write to a JIRA database directly.

Dhara

@Nic Brough [Adaptavist] SO active objects is the only option in server plugin for Database. Right?

Nic Brough -Adaptavist-

You can't use the database in Connect either, so I'm not sure what you're doing. I'd assumed you were reading an external database and your addon will continue to do that.

Boris Georgiev [Appfire]

You should bundle the appropriate JDBC connector
You need a UI for providing db connection settings - host, port, user, etc..
Who will create the database for your add-on ?
etc...

Here're some useful guides on Active Objects

https://developer.atlassian.com/docs/atlassian-platform-common-components/active-objects

https://developer.atlassian.com/docs/atlassian-platform-common-components/active-objects/getting-started-with-active-objects

And about the JOINS

https://developer.atlassian.com/docs/atlassian-platform-common-components/active-objects/developing-your-plugin-with-active-objects/the-active-objects-library/manytomany-relationship

https://developer.atlassian.com/docs/atlassian-platform-common-components/active-objects/developing-your-plugin-with-active-objects/the-active-objects-library/onetomany-relationship

Boris Georgiev [Appfire]

This should give you all the details on the annoations for primary keys, unique keys, etc..

https://developer.atlassian.com/docs/atlassian-platform-common-components/active-objects/developing-your-plugin-with-active-objects/the-active-objects-library

Dhara

@Nic Brough [Adaptavist] : yes you are right. In case of connect i am using external database. But in server plugin, i don't want to use external database. I want to port that external database in JIRA itself through active objects.

Dhara

@Boris Georgiev Thanks Boris. Actually i checked all above links but not getting any good example for how to add combo unique key, On DELETE cascade on foreign key, add procedures and triggers in active objects.

Boris Georgiev [Appfire]

You can't create multi column keys - https://ecosystem.atlassian.net/browse/AO-96
AO does not support procedures and triggers - you might need to re-design your application and move this logic into the Java persistence layer
Also I don;t think there is a CASCADE delete, so you should also handle that in Java

Welcome!

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

Quick Links

Find more posts tagged with

jira

jira-core