Description:
When I make a JDBC call to procedure, thorws an exception.
java.sql.SQLException: ResultSet is from UPDATE. No Data.
14:52:40,463 INFO [STDOUT] at com.mysql.jdbc.ResultSet.next(ResultSet.java:6091)
14:52:40,464 INFO [STDOUT] at org.jboss.resource.adapter.jdbc.WrappedResultSet.next(WrappedResultSet.java:520)
14:52:40,465 INFO [STDOUT] at com.tfsm.oas.report.engine.DataGenerator.getQueryData(DataGenerator.java:1029)
14:52:40,465 INFO [STDOUT] at com.tfsm.oas.report.engine.DataGenerator.getReportData(DataGenerator.java:138)
14:52:40,466 INFO [STDOUT] at com.tfsm.oas.business.report.engine.ReportManagerBean.generateReport(ReportManagerBean.java:79)
14:52:40,466 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
14:52:40,467 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
14:52:40,467 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
14:52:40,468 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:585)
14:52:40,468 INFO [STDOUT] at org.jboss.invocation.Invocation.performCall(Invocation.java:345)
14:52:40,469 INFO [STDOUT] at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:214)
14:52:40,470 INFO [STDOUT] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:185)
14:52:40,470 INFO [STDOUT] at org.jboss.webservice.server.ServiceEndpointInterceptor.invoke(ServiceEndpointInterceptor.java:51)
14:52:40,471 INFO [STDOUT] at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:48)
14:52:40,471 INFO [STDOUT] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:105)
14:52:40,472 INFO [STDOUT] at org.jboss.ejb.plugins.AbstractTxInterceptorBMT.invokeNext(AbstractTxInterceptorBMT.java:153)
14:52:40,473 INFO [STDOUT] at org.jboss.ejb.plugins.TxInterceptorBMT.invoke(TxInterceptorBMT.java:62)
14:52:40,473 INFO [STDOUT] at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:130)
14:52:40,474 INFO [STDOUT] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:139)
14:52:40,474 INFO [STDOUT] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192)
14:52:40,475 INFO [STDOUT] at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
14:52:40,475 INFO [STDOUT] at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:624)
14:52:40,476 INFO [STDOUT] at org.jboss.ejb.Container.invoke(Container.java:873)
14:52:40,477 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
14:52:40,477 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
14:52:40,478 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
14:52:40,478 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:585)
14:52:40,479 INFO [STDOUT] at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
14:52:40,479 INFO [STDOUT] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
14:52:40,480 INFO [STDOUT] at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
14:52:40,480 INFO [STDOUT] at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249)
14:52:40,481 INFO [STDOUT] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
14:52:40,481 INFO [STDOUT] at org.jboss.invocation.jrmp.server.JRMPInvoker$MBeanServerAction.invoke(JRMPInvoker.java:805)
14:52:40,482 INFO [STDOUT] at org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:406)
14:52:40,482 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
14:52:40,483 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
14:52:40,483 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
14:52:40,484 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:585)
14:52:40,484 INFO [STDOUT] at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:294)
14:52:40,485 INFO [STDOUT] at sun.rmi.transport.Transport$1.run(Transport.java:153)
14:52:40,485 INFO [STDOUT] at java.security.AccessController.doPrivileged(Native Method)
14:52:40,486 INFO [STDOUT] at sun.rmi.transport.Transport.serviceCall(Transport.java:149)
14:52:40,487 INFO [STDOUT] at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
14:52:40,488 INFO [STDOUT] at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
14:52:40,488 INFO [STDOUT] at java.lang.Thread.run(Thread.java:595)
How to repeat:
when try to iterate through the resultset it throws above exception.