1 Reply Latest reply on Sep 28, 2017 3:22 AM by supandey RSS
    shasegawa Newbie

    Usage of SQL service

    We can write Thing service with SQL by importing Relational Databases Connectors or JDBC Connector Extension. However I could not find usage manual. I'd like to know detailed usage, capability (e.g. What statement can be used?  Can I use transaction? etc.) and limitations. I also found some fragmented information in the thingworx community. But I want coherent document.

      • Re: Usage of SQL service
        supandey Collaborator

        Hi Satoshi , are you looking for information on what sort of SQL queries could be used? I'm not sure if there's any specific documentation on that since via JDBC you can pretty much call all sorts of SQL queries, PL/SQL packages, etc. I have so far managed to use all the CRUD SQL statements and PL/SQL blocks from the ThingWorx SQL Service