Bug #15499 ResultSet is from UPDATE. No Data.
Submitted: 5 Dec 2005 20:21 Modified: 6 Dec 2005 7:23
Reporter: Jayant Deshpande Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version: OS:Linux (Linux)
Assigned to: CPU Architecture:Any

[5 Dec 2005 20:21] Jayant Deshpande
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.
[6 Dec 2005 7:23] Aleksey Kishkin
duplicate of http://bugs.mysql.com/bug.php?id=15500