Skip to main content
K
KANGJAEHYUCK1-Visitor
1-Visitor
August 26, 2019
Solved

I want to connect the database in mashup.

  • August 26, 2019
  • 1 reply
  • 1176 views

I want to connect the database in mashup.

 

I've read this manual.

https://developer.thingworx.com/en/resources/guides/data-storage-methods/dsm-value-streams

and
https://developer.thingworx.com/en/resources/guides/external-databases/completed-examples-database
Connection succeeded.

 

row num :15 = result count : 14
If row num is 15 or less, the number of grids is 15. 
The number of row num 10 is 10 if the grid. 
The number I want is the same.
However, there are no values in the grid.

 

I put ojdbc6 in Tomcat and Java.

I thought about the cross domain, which is one of the browser constraints
But, The IP and thingworx IP of the database are the same.

 

I think I did it wrong. 
I'm new to Thinkworx.

 

I'd like to put data in the chart and the grid. 

Can you help me?

질문.PNG질문2.PNG

Best answer by Constantine

Hello,

 

Did you create a Data Shape to define the data structure you return from your service? If not, there's a handy "+ Data Shape" button on your first screenshot -- use it, specify this new data shape for the return type of your service and redo binding in your mashup. If you do everything correctly, you should see the CPUCLOCKS and CURDATES columns in your grid.

 

Regards,
Constantine

1 reply

C
Constantine18-OpalAnswer
18-Opal
August 26, 2019

Hello,

 

Did you create a Data Shape to define the data structure you return from your service? If not, there's a handy "+ Data Shape" button on your first screenshot -- use it, specify this new data shape for the return type of your service and redo binding in your mashup. If you do everything correctly, you should see the CPUCLOCKS and CURDATES columns in your grid.

 

Regards,
Constantine

    K
    KANGJAEHYUCK1-VisitorAuthor
    1-Visitor
    August 27, 2019

    Thank you very very much.

    I didn't expect that to be a problem.

    Think you.PNG

    Terms & ConditionsAccessibility statement