Thu, 24 Sep 2026
Login

Possibe bug: jdbc Fail to retrieve column list

Confluence User - 07 Sep, 2017

When I try to enter a SQL- statement I get continuously the following message:

It seems the JDBC-connection gets stuck,

  

bug;datalists;jdbc

4

Confluence User •
08 Sep, 2017 •
confluenceUser •
•
confluenceUser •

Hi Arend-Henk Huzenyest

If you use a JDBC Binder in a selectbox, you need to pass in two parameters to populate the select box id and value, for example:

    SELECT id, c_name FROM app_fd_mytable

or

    SELECT id, CONCAT(c_name, c_telno, c_email) AS myValue FROM app_fd_mytable

Confluence User •
08 Sep, 2017 •
confluenceUser •
•
confluenceUser •

Thx for your quick rely

Confluence User •
08 Sep, 2017 •
confluenceUser •
•
confluenceUser •

Maybe the documentation can be updated on this point: https://dev.joget.org/community/display/KBv6/JDBC+Options+Binder

Confluence User •
14 Sep, 2017 •
confluenceUser •
•
confluenceUser •

Thank you for your feedback Arend-Henk Huzen. We have updated the documentation :-).

1
CSV | Excel | XML | PDF
RELATED QUESTIONS
Select Box
Error storing data
Can I make list that read the Running Processes ? I want to add my own list and not using the list in monitor
Can I make list that read the Running Processes ? I want to add my own list and not using the list in monitor
How to customize datalist process formatter
Please help me fix the problem. The text field is pulling data from a datalist with more than 50k records and the browser hangs.
Please help me fix the problem. The Pop up select box is pulling data from a datalist with more than 50k records and the browser hangs.
I want to have a visibility control for hyperlink based on the date in a list builder, what type of operator I should use and how?
I Want to Add , Add to Cart functionality like Swiggy or Zomato This is possible in joget?
List Question
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print