# Executing basic SQL Insert,Update statements

**URL:** <https://community.ofelia.com/t/executing-basic-sql-insert-update-statements/5138>\
**Category:** Q&A\
**Created:** [11 September 2014 22:15 UTC](https://community.ofelia.com/t/executing-basic-sql-insert-update-statements/5138 "2014-09-11T22:15:10Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![edgarsilva](https://avatars.discourse-cdn.com/v4/letter/e/c68b51/32.png) [@edgarsilva](https://community.ofelia.com/u/edgarsilva)\
**Post date:** [11 September 2014 22:15 UTC](https://community.ofelia.com/t/executing-basic-sql-insert-update-statements/5138/1 "2014-09-11T22:15:10Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![haris.subasic](https://avatars.discourse-cdn.com/v4/letter/h/5daacb/32.png) [@haris.subasic](https://community.ofelia.com/u/haris.subasic)\
**Post date:** [12 September 2014 09:05 UTC](https://community.ofelia.com/t/executing-basic-sql-insert-update-statements/5138/2 "2014-09-12T09:05:33Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Mauricio.Barrantes](https://avatars.discourse-cdn.com/v4/letter/m/858c86/32.png) [@Mauricio.Barrantes](https://community.ofelia.com/u/Mauricio.Barrantes)\
**Post date:** [12 September 2014 02:38 UTC](https://community.ofelia.com/t/executing-basic-sql-insert-update-statements/5138/3 "2014-09-12T02:38:20Z")

</div>

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
