Executing basic SQL Insert,Update statements

Q&A
1

Hi All,

I am aware of that it is not a best practice, but can I add a Database connector do just execute a SQL w/o ResultSet as return?

How can I configure it please?

Cheers

Edgar

2

Hello edgarsilva,
yes, you can use database connectors for insert and update statements, as well. You can use them for any kind of query you need to execute. In case of insert or update, you don’t have to handle the output on your connector configuration and that’s all
Hope this helps,
Haris

3

You can use a basic implementation of Java ResultSet implementation, but, instead of returning java.sql.ResultSet, declare a org.bonitasoft.connectors.database.RowSet and use java.sql.ResultSet to initialize the object (Bonita 5.X). Greetings