It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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
TAGS
Community showcase
Published in Confluence Cloud

Enhancements to the Confluence Mobile App

  Hey Community! I’m Stephanie Zhang, a Product Manager along with @Wei on the Confluence mobile app. Our team has been hard at work to deliver helpful enhancements to the Confluen...

216 views 0 10
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you