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

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.

1 answer

This one is the BEST answer!

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.


Submitted by ttoine on Mon, 05/26/2014 - 15:49

thank you very much for this feedback !