Is there possiblity to make custom databace tables to Jira

Jira Development
1

Is there possiblity to make custom databace tables to JiraIs there possiblity to make custom database tables to Jira.

If yes then how?

2

Hi @matti.kiviharju,

you can use Active Objects to create your own database tables in Jira. Active Object is a wrapper around the database logic. like Hibernate. Here you can find the documentation: Atlassian SDK - Active Object

Regards,
Alexander

3

Ok. Good. Is there a risk to database table made with Active Object come to have various database depended issues. Like I only have MySQL my self on my servers and then AO not work in Oragle or PostgreSQL?

4

From Getting started with Active Objects:

21 pm
21 pm1514×660 121 KB

5

In 95% of the time you’ll be fine - activeobjects will be convert things properly. The biggest gotcha is the spacing issue with the queries and the casing. As long as you add in spaces around things and upper case items you’re good - ie:
MY_COL = ?