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
Community showcase
Posted Oct 24, 2018 in Confluence

Atlassian Research opportunity with Confluence templates

Do you use templates with Confluence? Take part in a remote 1-hr workshop. You'll receive USD $100 for your time!   We're looking for people to participate in a   remote 1-hr workshop...

1,027 views 15 13
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