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

Community Tip - Did you get called away in the middle of writing a post? Don't worry you can find your unfinished post later in the Drafts section of your profile page. X

How to use QueryHandler in DatabaseSystem?

ahanchat
7-Bedrock

How to use QueryHandler in DatabaseSystem?

Hi,

I have created a DatabaseSystem thing, but I don't know how to use the QueryHandler to query the Oracle database

An example and javadoc will help.

Thanks

Anirudha

3 REPLIES 3
AdamR
12-Amethyst
(To:ahanchat)

You create a new service and select SQL Query from the drop down at the top of the service definition.  You then simply write a SQL query and a dataset will be returned as an InfoTable type.

ahanchat
7-Bedrock
(To:AdamR)

Hi,

The answer you have give is for composer.

But I am writing it in java using the ThingWorx SDK 6.5.

Thanks

Anirudha

Still have to create service as mentioned by Adam Ressler​ and invoke it from your SDK.

Top Tags