[JDBC Datalist DatabaseBinder] Can't display data directly

Confluence User - 09 May, 2018

I create a datalist named "My Applications" using JDBC database binder , then create  a menu of list also named "My Applications" to display this datalist 

but after clicked this menu, it show 2 records but can't display directly 

only when I click icon of  up, down, it can show results , do anyone help ? thanks in advance

datalists;userviews

4


13 May, 2018
confluenceUser
confluenceUser

Hi, perhaps you can check the console or logs for error messages when the datalist is empty. There might be an exception which will give a clue as to what is happening.

14 May, 2018
confluenceUser
confluenceUser

Dear Anders Thanks for your reply. I check Logs of joget, it shows : ERROR 14 May 2018 10:48:53 org.joget.plugin.enterprise.JdbcDataListBinder - java.sql.SQLSyntaxErrorException: ORA-00904: "TEMP"."TRAVELAPPLICATIONREF": invalid identifier java.sql.SQLSyntaxErrorException: ORA-00904: "TEMP"."TRAVELAPPLICATIONREF": invalid identifier; In my form , there is a field "Travelapplicationref" but in table , it named "C_travelapplicationref". My Joget is V5 and use Oracle XE 11.2.0 as database. I tried to remove condition to let SQL simply like : select * from app_fd_SHAZI18A1_Home_App. the same error happened. Could you help?

14 May, 2018
confluenceUser
confluenceUser

Hi Joget Workflow creates the database columns prefix with "c_", example "c_myField". Do download the free app Simple Leave & Vacation (https://marketplace.joget.org/jw/web/userview/mp/mpp/_/vad?id=APP_leave-v1) from Joget Marketplace. The datalists in this app uses JDBC which you can view and learn the SQL usage (However the SQL was designed for MySQL database type).

14 May, 2018
confluenceUser
1
confluenceUser

Resolved.

I just create a new datalist , all are same as old one. But it can work

So still don't know what happen for the old one ....

RELATED QUESTIONS

Your answer


To answer a question you'll need an account.

Print