Usage of SQL service

[shasegawa]

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.

[supandey]

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