JDBC Question (Source of Datalist Builder)

 
1
0
-1

I have tried a lot of times and cannot get the data from external database.I connected the Databased but I cannot get the data to the column list.

Below is the pic of my setting

Test connection success

Fail to get the data.

 

Below is my SQL table. And I have tried all below SQL option to run and fail. Please help~~

SELECT * FROM s729nownetcn.dbprojectdevelopmenthk.dbo.BrandInfo

SELECT * FROM dbprojectdevelopmenthk.dbo.BrandInfo

SELECT * FROM dbo.BrandInfo

SELECT * FROM BrandInfo

 

    CommentAdd your comment...

    3 answers

    1.  
      1
      0
      -1

      Hi, I believe this could be due to security restrictions as mentioned in Problem connecting external Database in Joget onDemand

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

        Matthew, Thanks for your advice~~

        I have include the field name in "Primary Key" already....

        I am using cloud version of Joget to test, so I cannot find the log. cloud named: "duraflex.cloud.joget.com"

        May I know how I can get the log for cloud version? Thanks!!

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

          Hi

          In Configure Datalist Binder, the field "Primary Key" must be a field name that exists in your database table.

          Also do check the "C:\...\apache-tomcat-8.5.23\logs\joget.log" file for detail explanation of the reason why the JDBC SQL failed.

          Thank you.

            CommentAdd your comment...