Fail to retrieve column list. Please check your configuration.

 
1
0
-1

Datalist binder am using CustomDatasource pointing to oracle database. 
When am executing/saving receiving error "Fail to retrieve column list. Please check your configuration."

There is no connection issue as as Test connection notify "Database connected"


When am executing same query on database it works 

    CommentAdd your comment...

    3 answers

    1.  
      2
      1
      0

      Either your query syntax is wrong or you have written two columns with the same name in the select clause

        CommentAdd your comment...
      1.  
        1
        0
        -1

        Remove semicolons from the end of the SQL statement.

          CommentAdd your comment...
        1.  
          1
          0
          -1

          What is the query statement you used when you got the error? Check in joget.log for more explanation of the error.

            CommentAdd your comment...