Executing basic SQL Insert,Update statements

Submitted by edgarsilva on Fri, 09/12/2014 - 00:15
1
0
-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

Comments

Submitted by Mauricio.Barrantes on Fri, 09/12/2014 - 04:38

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

Permalink
1 answer

Submitted by haris.subasic on Fri, 09/12/2014 - 11:05
1
0
-1

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

Notifications