No graphic mode for Oracle connector
I am trying to connect to an Oracle 11G database using the wizard.
When I get to the mode step the graphic mode is greyed out:
If I test the query I get an exception (I have to select ojdbc6.jar in the list)
org.bonitasoft.engine.bpm.connector.ConnectorExecutionException: USERNAME=install | org.bonitasoft.engine.core.operation.exception.SOperationExecutionException: org.bonitasoft.engine.expression.exception.SExpressionEvaluationException: No value found for mandatory expression 'singleResult' of type Input Expression
If I go to the next step and store the result in a java.sql.ResultSet process variable and test again the exception is now :
org.bonitasoft.engine.exception.BonitaRuntimeException: USERNAME=install | java.lang.ClassCastException: oracle.jdbc.driver.ScrollableResultSet cannot be cast to java.io.Serializable
I have no problem performing this task with MySQL.
I think I have found what is wrong: graphical mode is only available for SELECT queries. I do not have an Oracle DB at hand to test but I tried to configure the connector and graphical mode was indeed available.
Also, this error:
oracle.jdbc.driver.ScrollableResultSet cannot be cast to java.io.Serializable occurs when you try to directly save the DB result directly as a process/task variable. That is not allowed as the
ResultSet represents a connection.
You need to scroll through the results programmatically and save them to a list if you work with the scripting mode.
Hope this helps,
Well... this is a SELECT query!
From what I see from MySQL tests graphical mode creates a script that scroll the results and store them in lists. I could probably replicate this. I believe the problem is that the wizard does not understand that a
oracle.jdbc.driver.ScrollableResultSet is a
javax.sql.ResultSet and then only provides the save as script fallback.