Hi All
Hoping you can help me on this?
I have a MS SQL 2012 connector with a basic TSQL query
SELECT iSiteID, cSiteName
FROM SiteCustomers
It work fine as an out of “array” i get the results in a list.list but when I want to change the array variable to a resultset variable i get an error
java.lang.reflect.InvocationTargetException
org.bonitasoft.engine.exception.BonitaRuntimeException: USERNAME=install | java.lang.ClassCastException: com.microsoft.sqlserver.jdbc.SQLServerResultSet cannot be cast to java.io.Serializable
i go the Scripting mode
My variable is a java.sql.resultset and i take the value of result set in the connector output
i am using bonita 7.0 and the driver is “com.microsoft.sqlserver.jdbc.SQLServerDriver”
jdbc:sqlserver://IP:Port;databaseName=xxxx
Driver is sqljdbc4.jar
Regards
Paul