Possibe bug: jdbc Fail to retrieve column list

 
1
0
-1

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

It seems the JDBC-connection gets stuck,

  

  1. Walter

    What is the error that you are getting from the server log?

  2. Arend-Henk Huzen

    The log shows no error

CommentAdd your comment...

1 answer

  1.  
    2
    1
    0

    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

    1. Arend-Henk Huzen

      Thx for your quick rely

    2. Arend-Henk Huzen

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

    3. Andrew

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

    CommentAdd your comment...