Skip to main content
A
ahanchat5-Regular Member
5-Regular Member
February 16, 2016
Question

How to use QueryHandler in DatabaseSystem?

  • February 16, 2016
  • 1 reply
  • 1632 views

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

    1 reply

    A
    AdamR14-Alexandrite
    14-Alexandrite
    February 16, 2016

    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.

    A
    ahanchat5-Regular MemberAuthor
    5-Regular Member
    February 17, 2016

    Hi,

    The answer you have give is for composer.

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

    Thanks

    Anirudha

    A
    arunkumar11-Visitor
    1-Visitor
    March 11, 2016

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

    Terms & ConditionsAccessibility statement