Sql plugin not running

Ryan Payne

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

Bob Swift

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.