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

[Philippe Robichaud]

Same here, any progress on this?

[Matthew J. Horn]

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

[Bob Swift (personal)]

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.

[Ryan Payne]

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.

[Bob Swift (personal)]

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.

[Ryan Payne]

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?

[Bob Swift (personal)]

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

[Ryan Payne]

system info page just lists 4.0