[SOLVED] Understand about database into plugin Edited

Hello everyone,

I'm new developer with jira plugins, I'm java programmer.

I developed my first plugin. I built a CRUD and all things are working. I saw that jira plugin work with H2 memory database.

I'm working with Active Object and mapped my class with:

@Preload
@Table("NAME_TABLE")

I generated my .jar and put in my jira standalone. My standalone is looking to Oracle database and my "NAME_TABLE" exist there. When I save my information, this information appear in my list on screen but I couldn't see into my database.

Is this information saving into H2 database ?

Anydody has an idea whats happen ? maybe Do I need to  configure something ?

thanks

1 answer

0 votes

JIRA only uses one database at a time, (unless you add code that explicitly reads another) so yes, your data is being stored in the Oracle database, if that's where the JIRA database is.

Generally, you should not worry about the database, you should not be accessing it directly.

 

good. but where informations that I saved ? I can't see into oracle database. the table is there but I couldn't see but it saved because my dao is getting this information.

It's in the active objects tables.

when I have oracle database, my active object will look to my oracle database ? when I put @Table("NAME_TABLE") am I referring a table into my oracle database ?

Generally, yes, but not always.  Have a look for all the AO tables in there.  You should find loads, with formats AO_<number>_<name>.

(The number is based on your add-on key, so it's unique and groups related tables together)

yeah ! a saw and I got it ! I solved my problem. Thanks a lot for your help ;-)

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

2,772 views 11 18
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot