ACCEPTED SOLUTION
Accepted Solutions
Hello,
I'm not quite sure if I understood you correctly - you're missing the mechanism between textbox and database? If yes, please find below my answer. If any step is already done by you, skip it.
1. I assume that you don't have the JDBC connector on your Thingworx yet. To create one and upload the Oracle Driver, you can use convenience extension that can be found here: https://marketplace.thingworx.com/Items/jdbc-connector-extension
All you need to do is to import the extension, navigate to the extension mashup, pick the Oracle DB Driver jar file: Oracle Database 11g Release 2 JDBC Driver Downloads
Then you can download the prepared JDBC extension and import it to the Thingworx Platform.
2. Then you need to create a Thing on the basis of Database Template. In the configuration panel you should put all the necessary settings (credentials, driver information, connection url).
3. The last step is to create a new service that would take as an input parameter a string value and perform an SQL Query. To do so, when you click on Add My Service button, you should pick the appropriate type from the drop down list near the New Service label.
Then you can put the SQL statement in the script box, using [[ parameter_name ]] as a parameter substitution (less error-prone) or << parameter_name >> as a string substitution (beware the SQL injection!).
4. After that, you need to add a newly created service to your mashup, bind the textbox Text parameter with your input parameter and the result of your service with grid.
Please note, that if you do not specify a data shape on the output InfoTable, you should mark the ShowAllColumns in the grid widget to true.
Hope that helps and I didn't misunderstood you. If you have any additional question, please let me know.
Regards,
J.
Hello,
I'm not quite sure if I understood you correctly - you're missing the mechanism between textbox and database? If yes, please find below my answer. If any step is already done by you, skip it.
1. I assume that you don't have the JDBC connector on your Thingworx yet. To create one and upload the Oracle Driver, you can use convenience extension that can be found here: https://marketplace.thingworx.com/Items/jdbc-connector-extension
All you need to do is to import the extension, navigate to the extension mashup, pick the Oracle DB Driver jar file: Oracle Database 11g Release 2 JDBC Driver Downloads
Then you can download the prepared JDBC extension and import it to the Thingworx Platform.
2. Then you need to create a Thing on the basis of Database Template. In the configuration panel you should put all the necessary settings (credentials, driver information, connection url).
3. The last step is to create a new service that would take as an input parameter a string value and perform an SQL Query. To do so, when you click on Add My Service button, you should pick the appropriate type from the drop down list near the New Service label.
Then you can put the SQL statement in the script box, using [[ parameter_name ]] as a parameter substitution (less error-prone) or << parameter_name >> as a string substitution (beware the SQL injection!).
4. After that, you need to add a newly created service to your mashup, bind the textbox Text parameter with your input parameter and the result of your service with grid.
Please note, that if you do not specify a data shape on the output InfoTable, you should mark the ShowAllColumns in the grid widget to true.
Hope that helps and I didn't misunderstood you. If you have any additional question, please let me know.
Regards,
J.
