Question & Answer > View Question

Exec MSSQL stored procedure in datalist

Confluence User - 15 Feb, 2017

Hi Guy's hope you can help.

I am using JDBC Datalist Binder (using default datasource).

I need to call a stored proc with a parameter (i.e Exec 'stored proc name' 'parameter')

I'm getting FAILED TO RETRIEVE COLUMN LIST' exception.

Thanks for the help,

Cheers,

Ernest.

datalists

2

Confluence User •

17 Feb, 2017 •

confluenceUser •

•

confluenceUser •

Hi, I think the JDBC Datalist Binder only supports SQL SELECT statements. If you need something more you may need to develop a custom Datalist Binder Plugin.

Confluence User •

21 Mar, 2017 •

confluenceUser •

•

confluenceUser •

Hi

Good news! After months of intensive development, we're proud to announce the beta for Joget Workflow Version 6 is now available for download at http://www.joget.org/joget-workflow-v6/#next

Read what's new in Joget workflow Version 6 at http://www.joget.org/joget-workflow-v6/

1

CSV | Excel | XML | PDF

Your answer

Print

Exec MSSQL stored procedure in datalist

2

RELATED QUESTIONS

Your answer

To answer a question you'll need an account.

Exec MSSQL stored procedure in datalist.builder-style-a31a9edf-4f77-422e-b294-ad6b32ba0db7{background: #efefef59 !important; margin: 0px !important; padding: 10px !important; border-radius: 5px !important; border: 1px solid #ddd !important; text-align: left !important; color:#0E4A40 !important;}

2.builder-style-e52de13b-4cea-4c84-a7cf-fd1706497cd4{color:#008C60 !important;}

RELATED QUESTIONS

Your answer.builder-style-30ba0f93-9361-4148-90ba-542956c77ce3{color:#008C60 !important; margin-left:10px !important;}

To answer a question you'll need an account.

Exec MSSQL stored procedure in datalist

2

Your answer