We reverse engineered Oracle 10.2.0.4 schema and generated json rest services of the entities. When we hit the rest URL it gives out the following stack trace,

SEVERE: Servlet.service() for servlet [pima-rest-services] in context with path [/pima-rest-services] threw exception [Request processing failed; nested exception is flexjson.JSONException: Error trying to deepSerialize] with root cause
java.sql.SQLException: Unsupported feature
at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:208)
at oracle.jdbc.driver.PhysicalConnection.getDBAccessP roperties(PhysicalConnection.java:5115)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at flexjson.BeanProperty.getValue(BeanProperty.java:1 02)
at flexjson.transformer.ObjectTransformer.transform(O bjectTransformer.java:37)
at flexjson.transformer.TransformerWrapper.transform( TransformerWrapper.java:22)
at flexjson.transformer.ObjectTransformer.transform(O bjectTransformer.java:49)
at flexjson.transformer.TransformerWrapper.transform( TransformerWrapper.java:22)
at flexjson.transformer.ObjectTransformer.transform(O bjectTransformer.java:49)
at flexjson.transformer.TransformerWrapper.transform( TransformerWrapper.java:22)
at flexjson.transformer.ObjectTransformer.transform(O bjectTransformer.java:49)
at flexjson.transformer.TransformerWrapper.transform( TransformerWrapper.java:22)
at flexjson.transformer.ObjectTransformer.transform(O bjectTransformer.java:49)
at flexjson.transformer.TransformerWrapper.transform( TransformerWrapper.java:22)
at flexjson.JSONContext.transform(JSONContext.java:73 )
at flexjson.JSONSerializer.serialize(JSONSerializer.j ava:377)
at flexjson.JSONSerializer.serialize(JSONSerializer.j ava:235)
at com.scea.pima.rest.entity.Product_Roo_Json.ajc$int erMethod$com_scea_pima_rest_entity_Product_Roo_Jso n$com_scea_pima_rest_entity_Product$toJson(Product _Roo_Json.aj:16)
at com.scea.pima.rest.entity.Product.toJson(Product.j ava:1)
at com.scea.pima.rest.entity.Product_Roo_Json.ajc$int erMethodDispatch1$com_scea_pima_rest_entity_Produc t_Roo_Json$com_scea_pima_rest_entity_Product$toJso n(Product_Roo_Json.aj)
at com.scea.pima.rest.controller.ProductController_Ro o_Controller_Json.ajc$interMethod$com_scea_pima_re st_controller_ProductController_Roo_Controller_Jso n$com_scea_pima_rest_controller_ProductController$ showJson(ProductController_Roo_Controller_Json.aj: 30)
at com.scea.pima.rest.controller.ProductController.sh owJson(ProductController.java:1)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.web.method.support.InvocableHa ndlerMethod.invoke(InvocableHandlerMethod.java:213 )
at org.springframework.web.method.support.InvocableHa ndlerMethod.invokeForRequest(InvocableHandlerMetho d.java:126)
at org.springframework.web.servlet.mvc.method.annotat ion.ServletInvocableHandlerMethod.invokeAndHandle( ServletInvocableHandlerMethod.java:96)
at org.springframework.web.servlet.mvc.method.annotat ion.RequestMappingHandlerAdapter.invokeHandlerMeth od(RequestMappingHandlerAdapter.java:617)
at org.springframework.web.servlet.mvc.method.annotat ion.RequestMappingHandlerAdapter.handleInternal(Re questMappingHandlerAdapter.java:578)
at org.springframework.web.servlet.mvc.method.Abstrac tHandlerMethodAdapter.handle(AbstractHandlerMethod Adapter.java:80)
at org.springframework.web.servlet.DispatcherServlet. doDispatch(DispatcherServlet.java:923)
at org.springframework.web.servlet.DispatcherServlet. doService(DispatcherServlet.java:852)
at org.springframework.web.servlet.FrameworkServlet.p rocessRequest(FrameworkServlet.java:882)
at org.springframework.web.servlet.FrameworkServlet.d oGet(FrameworkServlet.java:778)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:621)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:722)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:210)
at org.springframework.web.filter.HiddenHttpMethodFil ter.doFilterInternal(HiddenHttpMethodFilter.java:7 7)
at org.springframework.web.filter.OncePerRequestFilte r.doFilter(OncePerRequestFilter.java:76)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:210)
at org.springframework.web.filter.CharacterEncodingFi lter.doFilterInternal(CharacterEncodingFilter.java :88)
at org.springframework.web.filter.OncePerRequestFilte r.doFilter(OncePerRequestFilter.java:76)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java:225)
at org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.java:123)
at org.apache.catalina.authenticator.AuthenticatorBas e.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:168)
at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:98)
at org.apache.catalina.valves.AccessLogValve.invoke(A ccessLogValve.java:927)
at org.apache.catalina.core.StandardEngineValve.invok e(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.servic e(CoyoteAdapter.java:407)
at org.apache.coyote.http11.AbstractHttp11Processor.p rocess(AbstractHttp11Processor.java:1001)
at org.apache.coyote.AbstractProtocol$AbstractConnect ionHandler.process(AbstractProtocol.java:585)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProce ssor.run(JIoEndpoint.java:310)
at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)


Tried Iterable transformer option as suggested in one of the threads which didn't work. We are using 2.1 version of flexjson jar. Any pointers are highly appreciated. Thanks,