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

How can I execute SQL with my plugin in Confluence ?

Alex_cwng7t

Hi everyone, i found a way to do it via jira, using

org.ofbiz.core.entity.jdbc.SQLProcessor sqlProcessor = null;

sqlProcessor = new org.ofbiz.core.entity.jdbc.SQLProcessor("defaultDS");

ResultSet rs=sqlProcessor.executeQuery(SQL_QUERY);

how can this be done in confluence ?

Accepted answers

Hana Kučerová

Hi @Alex ,

would you please provide us information what you are trying to achieve? Which query you want to execute and why? Thank you.

All comments

Hana Kučerová

Hi @Alex ,

would you please provide us information what you are trying to achieve? Which query you want to execute and why? Thank you.

Alex_cwng7t

Hi)) I want to execute sql queries in db confluence like in jira, https://community.atlassian.com/t5/Answers-Developer-Questions/How-can-I-execute-SQL-with-my-plugin/qaq-p/568809
for example, execute

SHOW TABLES

How can I do that with SQLProcessor in confluence?

Hana Kučerová

Hi @Alex ,

thank you. Please look at this article, whether it helps you.

It is still not very clear, what you're trying to do (besides getting the list of database tables). I'm asking because there are usually better ways how to achieve something then modify data directly in the database and I would strongly recommend you not to do it.

Alex_cwng7t

thank you))*

Welcome!

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

Quick Links

Find more posts tagged with

confluence

server

confluence-server