cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

I want to connect the database in mashup.

SOLVED
Regular Member

I want to connect the database in mashup.

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

1 ACCEPTED SOLUTION

Accepted Solutions

Re: I want to connect the database in mashup.

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

2 REPLIES 2

Re: I want to connect the database in mashup.

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

Highlighted

Re: I want to connect the database in mashup.

Thank you very very much.

I didn't expect that to be a problem.

Think you.PNG