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.
Comments
thank you very much for this feedback !