Thu, 24 Sep 2026
Login

JDBC Question (Source of Datalist Builder)

Confluence User - 13 Nov, 2018

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

 

jdbc;datalist

3

Confluence User •
14 Nov, 2018 •
confluenceUser •
•
confluenceUser •

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.

Confluence User •
14 Nov, 2018 •
confluenceUser •
•
confluenceUser •

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!!

Confluence User •
15 Nov, 2018 •
confluenceUser •
•
confluenceUser •

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

1
CSV | Excel | XML | PDF
RELATED QUESTIONS
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
Create Folder on the Home Page
Async search list with ajax
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print