java.sql.SQLException: No data found
1 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   struts_problem
Posted On:   Wednesday, August 22, 2007 05:55 AM

hi pls solve my problem, i am connecting to ms access database i am getting resultset,connection using jboss, it is throwing exception at rs.getXX() method java.sql.SQLException: No data found 15:13:12,765 INFO [STDOUT] at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7138) 15:13:12,765 INFO [STDOUT] at sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(JdbcOdbc.java:3907) 15:13:12,765 INFO [STDOUT] at sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(JdbcOdbcResultSet.java:5698) 15:13:12,765 INFO [STDOUT] at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:354) 15:13:12,765 INFO [STDOUT] at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:411) 15:13:12,765 INF   More>>

hi pls solve my problem,
i am connecting to ms access database i am getting resultset,connection using jboss, it is throwing exception at rs.getXX() method


java.sql.SQLException: No data found
15:13:12,765 INFO [STDOUT] at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7138)
15:13:12,765 INFO [STDOUT] at sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(JdbcOdbc.java:3907)
15:13:12,765 INFO [STDOUT] at sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(JdbcOdbcResultSet.java:5698)
15:13:12,765 INFO [STDOUT] at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:354)
15:13:12,765 INFO [STDOUT] at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:411)
15:13:12,765 INFO [STDOUT] at org.jboss.resource.adapter.jdbc.WrappedResultSet.getString(WrappedResultSet.java:405)
15:13:12,765 INFO [STDOUT] at esoftejb.MyTestSessionBean.getCandidate(MyTestSessionBean.java:100)
15:13:12,765 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
15:13:12,765 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
15:13:12,765 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
15:13:12,765 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:597)
15:13:12,765 INFO [STDOUT] at org.jboss.invocation.Invocation.performCall(Invocation.java:345)
15:13:12,765 INFO [STDOUT] at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:214)
15:13:12,765 INFO [STDOUT] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:185)
15:13:12,765 INFO [STDOUT] at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:113)
15:13:12,765 INFO [STDOUT] at org.jboss.webservice.server.ServiceEndpointInterceptor.invoke(ServiceEndpointInterceptor.java:51)
15:13:12,765 INFO [STDOUT] at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:48)
15:13:12,765 INFO [STDOUT] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:105)
15:13:12,765 INFO [STDOUT] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:316)
15:13:12,765 INFO [STDOUT] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:149)
15:13:12,765 INFO [STDOUT] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:128)
15:13:12,765 INFO [STDOUT] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
15:13:12,765 INFO [STDOUT] at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
15:13:12,765 INFO [STDOUT] at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:624)
15:13:12,765 INFO [STDOUT] at org.jboss.ejb.Container.invoke(Container.java:854)
15:13:12,765 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
15:13:12,765 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
15:13:12,765 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
15:13:12,765 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:597)
15:13:12,765 INFO [STDOUT] at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
15:13:12,765 INFO [STDOUT] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
15:13:12,765 INFO [STDOUT] at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
15:13:12,765 INFO [STDOUT] at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:242)
15:13:12,765 INFO [STDOUT] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642)
15:13:12,765 INFO [STDOUT] at org.jboss.invocation.local.LocalInvoker$MBeanServerAction.invoke(LocalInvoker.java:155)
15:13:12,765 INFO [STDOUT] at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:104)
15:13:12,765 INFO [STDOUT] at org.jboss.invocation.MarshallingInvokerInterceptor.invoke(MarshallingInvokerInterceptor.java:55)
15:13:12,765 INFO [STDOUT] at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46)
15:13:12,765 INFO [STDOUT] at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:55)
15:13:12,765 INFO [STDOUT] at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:97)
15:13:12,765 INFO [STDOUT] at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:86)
15:13:12,765 INFO [STDOUT] at $Proxy53.getCandidate(Unknown Source)
15:13:12,765 INFO [STDOUT] at esoft.CandidateDetailAction.setForm(CandidateDetailAction.java:129)
15:13:12,765 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
15:13:12,765 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
15:13:12,765 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
15:13:12,765 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:597)
15:13:12,765 INFO [STDOUT] at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:270)
15:13:12,765 INFO [STDOUT] at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:187)
15:13:12,765 INFO [STDOUT] at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
15:13:12,765 INFO [STDOUT] at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
15:13:12,765 INFO [STDOUT] at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
15:13:12,765 INFO [STDOUT] at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
15:13:12,765 INFO [STDOUT] at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
15:13:12,765 INFO [STDOUT] at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
15:13:12,765 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
15:13:12,765 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
15:13:12,765 INFO [STDOUT] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)
15:13:12,765 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
15:13:12,765 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
15:13:12,765 INFO [STDOUT] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
15:13:12,765 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
15:13:12,765 INFO [STDOUT] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
15:13:12,765 INFO [STDOUT] at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
15:13:12,765 INFO [STDOUT] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
15:13:12,765 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
15:13:12,765 INFO [STDOUT] at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:44)
15:13:12,765 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
15:13:12,765 INFO [STDOUT] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:169)
15:13:12,765 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
15:13:12,765 INFO [STDOUT] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
15:13:12,765 INFO [STDOUT] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
15:13:12,765 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
15:13:12,765 INFO [STDOUT] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
15:13:12,765 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
15:13:12,765 INFO [STDOUT] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
15:13:12,765 INFO [STDOUT] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
15:13:12,765 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
15:13:12,765 INFO [STDOUT] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
15:13:12,765 INFO [STDOUT] at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
15:13:12,765 INFO [STDOUT] at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
15:13:12,765 INFO [STDOUT] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
15:13:12,765 INFO [STDOUT] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
15:13:12,765 INFO [STDOUT] at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
15:13:12,765 INFO [STDOUT] at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
15:13:12,765 INFO [STDOUT] at java.lang.Thread.run(Thread.java:619)

   <<Less

Re: java.sql.SQLException: No data found

Posted By:   WarnerJan_Veldhuis  
Posted On:   Wednesday, August 22, 2007 06:30 AM

Make sure you use ResultSet.next() before calling the ResultSet.getXX() methods.
About | Sitemap | Contact