Active Object: Use mysql plugin to manage my Jira database

Jira Development Jira Server
,
#1

Hi,
I have put this jdbc connection (MYSQL: https://bitbucket.org/activeobjects/ao/overview) in my code, done the plugin (well compiled), but I don’t know how to use it in mi Jira (I want to use it installing it with it’s .jar)…
After doing the active object with the jdbc, how I could use it?
Best regards and thanks,
David

#2

Oh you don’t need to add that - you want to look at https://developer.atlassian.com/docs/atlassian-platform-common-components/active-objects/getting-started-with-active-objects

All of the JDBC connections etc will be taken care of by JIRA. ActiveObjects will pretty much take of all of the magical sql/jdbc connection pooling for you.

1 Like
#3

Hi Daniel:

Thank you for your answer, I have completed the tutorial of ActiveObjets, but at the end, after make the tests, I don’t know how to connect the Todo class to my Mysql database (in the tutorial they use hsql).
To connect it, I need another class with the connections or how it manage the Jira connections?

Best regards and thanks,
David

#4

You don’t need to worry about that - In theory ActiveObjects will take care of everything database related for you regardless of which version/type of database that’s being used.

Note though: There are a couple of peculiarities depending on the database that’s being used - make sure to test against at least 1 real database.

1 Like
#5

Thank you!, I have added the plugin and checked that it insert values in my database.
Now I want to implement my own method, to alter a table of the database for example, or to add a value in the table that I want. Is there any tutorial that does this?
Best regards,
David Sierra

#6

ActiveObjects is an ORM so you really shouldn’t be interacting with the database directly but rather through the ActiveObjects interface (that way you’ll get to participate with the import/exports).

The above tutorial will walk you through creation: https://developer.atlassian.com/docs/atlassian-platform-common-components/active-objects/getting-started-with-active-objects#GettingStartedwithActiveObjects-Step5.Createyourfirstentity

and finding: https://developer.atlassian.com/docs/atlassian-platform-common-components/active-objects/getting-started-with-active-objects#GettingStartedwithActiveObjects-Step7.ImplementsomeMethods

As far as altering the table - take a look at https://developer.atlassian.com/docs/atlassian-platform-common-components/active-objects/handling-ao-upgrade-tasks

1 Like
#7

Thank you Daniel!
I have solved the issue.
David Sierra