# Accessing oracle.sql.ARRAY values (filled from a mysql query)

**URL:** <https://community.ofelia.com/t/accessing-oracle-sql-array-values-filled-from-a-mysql-query/4137>\
**Category:** Q&A\
**Created:** [22 January 2014 13:39 UTC](https://community.ofelia.com/t/accessing-oracle-sql-array-values-filled-from-a-mysql-query/4137 "2014-01-22T13:39:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![bjnobre](https://avatars.discourse-cdn.com/v4/letter/b/a9a28c/32.png) [@bjnobre](https://community.ofelia.com/u/bjnobre)\
**Post date:** [22 January 2014 13:39 UTC](https://community.ofelia.com/t/accessing-oracle-sql-array-values-filled-from-a-mysql-query/4137/1 "2014-01-22T13:39:00Z")

</div>

Hi,

I am using BOS 6.2.1 and I am&nbsp;trying to access the ResultSet data from a query on my mySQL database. I configure the connector using de wizard and set the tableResult (on the last form of the configuration process, the grafics&nbsp;mode) to&nbsp;my pool variable rset (of type&nbsp;java.sql.ARRAY). When I test the connector, it's just work properly, and I can see the data on the form test result.

I need to show the data on a table widget on the next task form and I tried to setup the widget on a script with the code below (that I found here:&nbsp;[http://community.ofelia.com/answers/fill-table-widget-values-db](http://community.ofelia.com/answers/fill-table-widget-values-db)), but it does'nt work for me.

_final List\<List\<Object\>\> resultTable = new ArrayList\<List\<Object\>\>();  
 int maxColumn = rset.getMetaData().getColumnCount()+1;  
 &nbsp;&nbsp; &nbsp;while(rset.next()){  
 &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;final List\<Object\> row = new ArrayList\<Object\>();  
 &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;for(int colIndex = 1; colIndex \< maxColumn ; colIndex++){  
 &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;row.add(rset.getObject(colIndex));  
 &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;}  
 &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;resultTable.add(Collections.unmodifiableList(row));  
 &nbsp;&nbsp; &nbsp;}  
 return resultTable;_

Here is the engine log result:

_Jan 22, 2014 10:32:07 AM org.bonitasoft.console.server.listener.StudioWatchdogListener$1 run  
 Advertência: Bonita Studio watchdog process has started on 6969 with a delay of 20000ms  
 Jan 22, 2014 10:34:29 AM org.bonitasoft.forms.server.provider.impl.FormServiceProviderImpl resolveExpressions  
 Grave: Error while communicating with the engine.  
 org.bonitasoft.forms.server.exception.BPMEngineException: Error when evaluating expressions on activity instance 4  
 &nbsp;&nbsp; &nbsp;at org.bonitasoft.forms.server.accessor.api.ExpressionEvaluatorEngineClient.evaluateExpressionsOnActivityInstance(ExpressionEvaluatorEngineClient.java:44)  
 &nbsp;&nbsp; &nbsp;at org.bonitasoft.forms.server.api.impl.FormExpressionsAPIImpl.evaluateActivityExpressions(FormExpressionsAPIImpl.java:876)  
 &nbsp;&nbsp; &nbsp;at org.bonitasoft.forms.server.api.impl.FormWorkflowAPIImpl.getActivityFieldsValues(FormWorkflowAPIImpl.java:807)  
 &nbsp;&nbsp; &nbsp;at org.bonitasoft.forms.server.provider.impl.FormServiceProviderImpl.resolveExpressions(FormServiceProviderImpl.java:887)  
 &nbsp;&nbsp; &nbsp;at org.bonitasoft.forms.server.api.impl.util.FormFieldValuesUtil.setFormWidgetsValues(FormFieldValuesUtil.java:877)  
 &nbsp;&nbsp; &nbsp;at org.bonitasoft.forms.server.FormsServlet.getFormFirstPage(FormsServlet.java:218)  
 &nbsp;&nbsp; &nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  
 &nbsp;&nbsp; &nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)  
 &nbsp;&nbsp; &nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)  
 &nbsp;&nbsp; &nbsp;at java.lang.reflect.Method.invoke(Unknown Source)  
 &nbsp;&nbsp; &nbsp;at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:561)  
 &nbsp;&nbsp; &nbsp;at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:208)  
 &nbsp;&nbsp; &nbsp;at org.bonitasoft.forms.server.FormsServlet.processCall(FormsServlet.java:130)  
 &nbsp;&nbsp; &nbsp;at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:248)  
 &nbsp;&nbsp; &nbsp;at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)  
 &nbsp;&nbsp; &nbsp;at javax.servlet.http.HttpServlet.service(HttpServlet.java:643)  
 &nbsp;&nbsp; &nbsp;at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)  
 &nbsp;&nbsp; &nbsp;at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)  
 &nbsp;&nbsp; &nbsp;at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)  
 &nbsp;&nbsp; &nbsp;at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)  
 &nbsp;&nbsp; &nbsp;at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)  
 &nbsp;&nbsp; &nbsp;at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)  
 &nbsp;&nbsp; &nbsp;at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)  
 &nbsp;&nbsp; &nbsp;at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77)  
 &nbsp;&nbsp; &nbsp;at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)  
 &nbsp;&nbsp; &nbsp;at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)  
 &nbsp;&nbsp; &nbsp;at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)  
 &nbsp;&nbsp; &nbsp;at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)  
 &nbsp;&nbsp; &nbsp;at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)  
 &nbsp;&nbsp; &nbsp;at java.lang.Thread.run(Unknown Source)  
 Caused by: org.bonitasoft.engine.expression.ExpressionEvaluationException: org.bonitasoft.engine.expression.exception.SInvalidExpressionException: Declared return type unknown: oracle.sql.ARRAY for expression rset  
 &nbsp;&nbsp; &nbsp;at org.bonitasoft.engine.api.impl.ProcessAPIImpl.evaluateExpressionsOnActivityInstance(ProcessAPIImpl.java:5418)  
 &nbsp;&nbsp; &nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  
 &nbsp;&nbsp; &nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)  
 &nbsp;&nbsp; &nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)  
 &nbsp;&nbsp; &nbsp;at java.lang.reflect.Method.invoke(Unknown Source)  
 &nbsp;&nbsp; &nbsp;at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:292)  
 &nbsp;&nbsp; &nbsp;at org.bonitasoft.engine.api.impl.ServerAPIImpl.access$000(ServerAPIImpl.java:63)  
 &nbsp;&nbsp; &nbsp;at org.bonitasoft.engine.api.impl.ServerAPIImpl$1.call(ServerAPIImpl.java:261)  
 &nbsp;&nbsp; &nbsp;at org.bonitasoft.engine.transaction.JTATransactionServiceImpl.executeInTransaction(JTATransactionServiceImpl.java:207)  
 &nbsp;&nbsp; &nbsp;at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPIInTransaction(ServerAPIImpl.java:268)  
 &nbsp;&nbsp; &nbsp;at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:219)  
 &nbsp;&nbsp; &nbsp;at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:105)  
 &nbsp;&nbsp; &nbsp;at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:88)  
 &nbsp;&nbsp; &nbsp;at com.sun.proxy.$Proxy13.evaluateExpressionsOnActivityInstance(Unknown Source)  
 &nbsp;&nbsp; &nbsp;at org.bonitasoft.forms.server.accessor.api.ExpressionEvaluatorEngineClient.evaluateExpressionsOnActivityInstance(ExpressionEvaluatorEngineClient.java:42)  
 &nbsp;&nbsp; &nbsp;... 29 more  
 Caused by: org.bonitasoft.engine.expression.exception.SInvalidExpressionException: Declared return type unknown: oracle.sql.ARRAY for expression rset  
 &nbsp;&nbsp; &nbsp;at org.bonitasoft.engine.expression.impl.ExpressionServiceImpl.checkReturnType(ExpressionServiceImpl.java:161)  
 &nbsp;&nbsp; &nbsp;at org.bonitasoft.engine.expression.impl.ExpressionServiceImpl.evaluate(ExpressionServiceImpl.java:132)  
 &nbsp;&nbsp; &nbsp;at org.bonitasoft.engine.core.expression.control.api.impl.ExpressionResolverServiceImpl.evaluateExpressionsOfKind(ExpressionResolverServiceImpl.java:161)  
 &nbsp;&nbsp; &nbsp;at org.bonitasoft.engine.core.expression.control.api.impl.ExpressionResolverServiceImpl.evaluateExpressionsFlatten(ExpressionResolverServiceImpl.java:104)  
 &nbsp;&nbsp; &nbsp;at org.bonitasoft.engine.core.expression.control.api.impl.ExpressionResolverServiceImpl.evaluate(ExpressionResolverServiceImpl.java:72)  
 &nbsp;&nbsp; &nbsp;at org.bonitasoft.engine.api.impl.transaction.expression.EvaluateExpressionsInstanceLevel.execute(EvaluateExpressionsInstanceLevel.java:69)  
 &nbsp;&nbsp; &nbsp;at org.bonitasoft.engine.api.impl.ProcessAPIImpl.evaluateExpressionsInstanceLevel(ProcessAPIImpl.java:5457)  
 &nbsp;&nbsp; &nbsp;at org.bonitasoft.engine.api.impl.ProcessAPIImpl.evaluateExpressionsOnActivityInstance(ProcessAPIImpl.java:5414)  
 &nbsp;&nbsp; &nbsp;... 43 more  
 Caused by: java.lang.ClassNotFoundException: oracle.sql.ARRAY  
 &nbsp;&nbsp; &nbsp;at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1680)  
 &nbsp;&nbsp; &nbsp;at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1526)  
 &nbsp;&nbsp; &nbsp;at org.bonitasoft.engine.classloader.BonitaClassLoader.loadClass(BonitaClassLoader.java:136)  
 &nbsp;&nbsp; &nbsp;at org.bonitasoft.engine.classloader.VirtualClassLoader.loadClass(VirtualClassLoader.java:57)  
 &nbsp;&nbsp; &nbsp;at org.bonitasoft.engine.classloader.ParentRedirectClassLoader.loadClass(ParentRedirectClassLoader.java:23)  
 &nbsp;&nbsp; &nbsp;at org.bonitasoft.engine.classloader.BonitaClassLoader.loadClass(BonitaClassLoader.java:136)  
 &nbsp;&nbsp; &nbsp;at org.bonitasoft.engine.classloader.VirtualClassLoader.loadClass(VirtualClassLoader.java:57)  
 &nbsp;&nbsp; &nbsp;at org.bonitasoft.engine.classloader.ParentRedirectClassLoader.loadClass(ParentRedirectClassLoader.java:23)  
 &nbsp;&nbsp; &nbsp;at org.bonitasoft.engine.classloader.BonitaClassLoader.loadClass(BonitaClassLoader.java:136)  
 &nbsp;&nbsp; &nbsp;at org.bonitasoft.engine.classloader.VirtualClassLoader.loadClass(VirtualClassLoader.java:57)  
 &nbsp;&nbsp; &nbsp;at org.bonitasoft.engine.expression.impl.ExpressionServiceImpl.checkReturnType(ExpressionServiceImpl.java:154)  
 &nbsp;&nbsp; &nbsp;... 50 more_

_Jan 22, 2014 10:34:29 AM org.bonitasoft.forms.server.FormsServlet getFormFirstPage  
 Grave: Error while getting the first page for application Pool4--1.0--Passo2$entry  
 org.bonitasoft.forms.server.exception.FormNotFoundException: Error while communicating with the engine.  
 &nbsp;&nbsp; &nbsp;at org.bonitasoft.forms.server.provider.impl.FormServiceProviderImpl.resolveExpressions(FormServiceProviderImpl.java:941)  
 &nbsp;&nbsp; &nbsp;at org.bonitasoft.forms.server.api.impl.util.FormFieldValuesUtil.setFormWidgetsValues(FormFieldValuesUtil.java:877)  
 &nbsp;&nbsp; &nbsp;at org.bonitasoft.forms.server.FormsServlet.getFormFirstPage(FormsServlet.java:218)  
 &nbsp;&nbsp; &nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  
 &nbsp;&nbsp; &nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)  
 &nbsp;&nbsp; &nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)  
 &nbsp;&nbsp; &nbsp;at java.lang.reflect.Method.invoke(Unknown Source)  
 &nbsp;&nbsp; &nbsp;at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:561)  
 &nbsp;&nbsp; &nbsp;at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:208)  
 &nbsp;&nbsp; &nbsp;at org.bonitasoft.forms.server.FormsServlet.processCall(FormsServlet.java:130)  
 &nbsp;&nbsp; &nbsp;at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:248)  
 &nbsp;&nbsp; &nbsp;at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)  
 &nbsp;&nbsp; &nbsp;at javax.servlet.http.HttpServlet.service(HttpServlet.java:643)  
 &nbsp;&nbsp; &nbsp;at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)  
 &nbsp;&nbsp; &nbsp;at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)  
 &nbsp;&nbsp; &nbsp;at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)  
 &nbsp;&nbsp; &nbsp;at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)  
 &nbsp;&nbsp; &nbsp;at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)  
 &nbsp;&nbsp; &nbsp;at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)  
 &nbsp;&nbsp; &nbsp;at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)  
 &nbsp;&nbsp; &nbsp;at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77)  
 &nbsp;&nbsp; &nbsp;at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)  
 &nbsp;&nbsp; &nbsp;at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)  
 &nbsp;&nbsp; &nbsp;at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)  
 &nbsp;&nbsp; &nbsp;at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)  
 &nbsp;&nbsp; &nbsp;at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)  
 &nbsp;&nbsp; &nbsp;at java.lang.Thread.run(Unknown Source)_

Thanks for any help!!!

Bene.

---

<div class="post-metadata">

**Author:** ![romain.bioteau](https://dub1.discourse-cdn.com/flex013/user_avatar/community.ofelia.com/romain.bioteau/32/720_2.png) [@romain.bioteau](https://community.ofelia.com/u/romain.bioteau)\
**Post date:** [23 January 2014 12:09 UTC](https://community.ofelia.com/t/accessing-oracle-sql-array-values-filled-from-a-mysql-query/4137/2 "2014-01-23T12:09:45Z")

</div>

Hello&nbsp;bjnobre,

The problem comes from the call of :&nbsp;rset.getObject(colIndex) in your script.

The getObject method returns a&nbsp;oracle.sql.ARRAY object that is not in the classpath of the process.

To avoid this use a more typed method from the ResultSet.

The fact that this object is returned also implied that your not querying a MySQL database but an Oracle database.

Regards.

---

<div class="post-metadata">

**Author:** ![bjnobre](https://avatars.discourse-cdn.com/v4/letter/b/a9a28c/32.png) [@bjnobre](https://community.ofelia.com/u/bjnobre)\
**Post date:** [23 January 2014 12:15 UTC](https://community.ofelia.com/t/accessing-oracle-sql-array-values-filled-from-a-mysql-query/4137/3 "2014-01-23T12:15:11Z")

</div>

Thank U, rb.

I used the help from Christopherf and Haris at&nbsp;[http://community.ofelia.com/answers/fill-table-widget-values-db](http://community.ofelia.com/answers/fill-table-widget-values-db) and it just worked for me.

But your information will be usefull in the future.

&nbsp;