# DataBase Connectors result assignment (Oracle)

**URL:** https://community.ofelia.com/t/database-connectors-result-assignment-oracle/4598
**Category:** Q&A
**Created:** [22 May 2014 15:38 UTC](https://community.ofelia.com/t/database-connectors-result-assignment-oracle/4598 "2014-05-22T15:38:10Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![joteam03](https://avatars.discourse-cdn.com/v4/letter/j/919ad9/32.png) [@joteam03](https://community.ofelia.com/u/joteam03)
#### Post date: [22 May 2014 15:38 UTC](https://community.ofelia.com/t/database-connectors-result-assignment-oracle/4598/1 "2014-05-22T15:38:10Z")

</div>

I try to assign the output of an Oracle Database Connector to a process variable (typed : java.sql.ResultSet), but I have the following error :

java.lang.reflect.InvocationTargetException  
org.bonitasoft.engine.exception.BonitaRuntimeException: USERNAME=install | java.lang.ClassCastException: oracle.jdbc.driver.ScrollableResultSet cannot be cast to java.io.Serializable

If i remove the output assignment (script option), the connector work.

I don’t understand why it doesn’t work, any idea ?

I used to work with 5.9 edition and it was possible to assign the output of a database connector (typed rowSet) to a process variable of the same type.

---

<div class="post-metadata">

### Author: ![joteam03](https://avatars.discourse-cdn.com/v4/letter/j/919ad9/32.png) [@joteam03](https://community.ofelia.com/u/joteam03)
#### Post date: [23 May 2014 19:27 UTC](https://community.ofelia.com/t/database-connectors-result-assignment-oracle/4598/2 "2014-05-23T19:27:38Z")

</div>

I answer to my own question because I found by myself.

As I m not a developper i didn’t know the difference between resultset and rowset and I think i found it :  
a resultset is connected to the database so we can’t assign it to a process variable outside the connector environnement  
a rowset is disconnected so the difference explain why it was impossible to do what i was trying to do.

If a java developper could confirm this it would be interesting.

---

<div class="post-metadata">

### Author: ![FatmaGh](https://avatars.discourse-cdn.com/v4/letter/f/3e96dc/32.png) [@FatmaGh](https://community.ofelia.com/u/FatmaGh)
#### Post date: [17 September 2020 10:21 UTC](https://community.ofelia.com/t/database-connectors-result-assignment-oracle/4598/3 "2020-09-17T10:21:21Z")

</div>

how did you solve the problem , cauz the return result is resultSet ., is not compatible with a buisness variable&nbsp;

---

<div class="post-metadata">

### Author: ![system](https://europe1.discourse-cdn.com/flex013/uploads/community_bonitasoft/original/2X/6/6b7b18c0478f2645369e82e009b65e3b97f2cc12.svg) [@system](https://community.ofelia.com/u/system)
#### Post date: [26 May 2014 13:49 UTC](https://community.ofelia.com/t/database-connectors-result-assignment-oracle/4598/4 "2014-05-26T13:49:34Z")

</div>

thank you very much for this feedback !