Sql plugin not running

We are having issues with the sql plugin. we are running confluence version 4.0 and have tried both sql plugin versions 4.2.1 and 4.2.0 with no success. The datasource we are is located at java:comp/env/jdbc/confluence. The table I am trying to access is called schedule_cal

even going of of the simple example statement from the plugin homepage does not run

{sql:datasource=confluence}

select * from schedule_cal

{sql}

we have also tried with the {sql-query} macro

if entered in the page body through the page editor the sql statement text will simply be displayed in the page once saved, if entered by inser>wiki markup the error: Unknown macro:'unmigrated-inline-wiki-markup' is displayed

what are we doing wrong? I have tried every combination I can think of but it is not recognizing it as a macro but plain txt instead

3 answers

Currently, you can only use sql macro on Confluence 4 via insert wiki markup. See/watch Confluence 4.0 compatibility for Table and other plugins for information on that. Regarding the unknown macro part - that is Confluence, check the plugin is properly installed and all macros enabled. Check the logs for related problems. If you still have problem, you can open a plugin issue with more details, but I suspect it is a installation issue.

Thats what I am confused about, can you explain the process for adding the sql macro through the insert wiki markup? I though you opened it, entered the sql macro statement in the wiki markup window and pressed insert, that simple. Am I missing something? Instalation stated successfull and plugin admin page shows 9 of 9 modules enabled, I dont understand why it is not running. Also I opended an issue and am waiting to hear back on that as well.

That is all. It is no different than any other wiki markup added that way. Suggest restarting Confluence to see if problem occurs after a fresh start.

Restarted with no change, it will run any of the included macros such as {column} but will not run any of the ones I have installed such as {sql} {table} or {run} for all three it produces the same unkown macro error. Do you have any other suggestions or ideas why it would not work with any of them?

Will have to see what Atlassian support says. What specific version of Confluence 4 are you at? Mine is 4.0

system info page just lists 4.0

RPAYNE, did you ever resolve this? I am experiencing the same issue. Am using Confluence 4.1.2.

Same here, any progress on this?

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Posted Jul 10, 2018 in Confluence

We want to see the templates you've created in Confluence!

Hi Community, Jessica here from the Confluence Product Marketing team!  July’s community challenge is all about sharing pictures  — and as an extension of our first post on what ...

703 views 21 12
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