DataBase Connectors result assignment (Oracle)

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.

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.

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

thank you very much for this feedback !