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

Access to ActiveObjects tables via JDBC?

Claudio Kirchhoff

I wonder if I can get a JDBC connection to the JIRA/Confluence database from plugin code and access the tables created by the ActiveObjects plugin.

Is that possible?

If so: Would that still work reliably on a different JIRA/Confluence instance with different configuration, specifically with a different database vendor?

Accepted answers

Jobin Kuruvilla [Adaptavist]

You can definitely get the DS info or Connection from plugin code and use it to access AO tables.

DatasourceInfo datasourceInfo = new DefaultOfBizConnectionFactory().getDatasourceInfo();
Connection connection = new DefaultOfBizConnectionFactory().getConnection();

AO tables follows a unique naming strategy, which you can find at https://developer.atlassian.com/docs/atlassian-platform-common-components/active-objects/developing-your-plugin-with-active-objects/active-objects-faq/table-names. The names stay the same across instances.

Having said that, it is recommended to use the ActiveObjects APIs to interact with the AO tables.

All comments

Jobin Kuruvilla [Adaptavist]

You can definitely get the DS info or Connection from plugin code and use it to access AO tables.

DatasourceInfo datasourceInfo = new DefaultOfBizConnectionFactory().getDatasourceInfo();
Connection connection = new DefaultOfBizConnectionFactory().getConnection();

Having said that, it is recommended to use the ActiveObjects APIs to interact with the AO tables.

Claudio Kirchhoff

Thanks a lot, Jobin, I will try that! Are you aware of specific dangers of accessing AO tables directly view JDBC?

Jobin Kuruvilla [Adaptavist]

Not really. I mostly opt for AO APIs but have done it via direct JDBC calls for complex scenarios. Other than that, it is normal JDBC!

Daniel Wester

Be very careful. AO does have some caching built in so if you mix the access algorithm (API vs direct jdbc) you might see some strange results.

Claudio Kirchhoff

Is there a way to make that work for Confluence? I can only find DefaultOfBizConnectionFactory in the com.atlassian.jira.ofbiz package.

davidbalducci

Hi,

Is it still possible to access the db via jdbc connection?

The code above with jira version 8.4.0 does not work. How can we do otherwise?

Thanks

Welcome!

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

Quick Links

Find more posts tagged with

confluence

jira

active-objects

jdbc