What's the problem with the exception?


ResultSet rset = ...
try {
   if ( rset.next() ) {
      // yes, at lewast a single record found
      {
      } while ( rset.next() );
      // if you call next at this point you will get an exception
   } else {
      // no records found
   }
} catch (SQLException sqe ) {
   //
}

Rajesh_Singh wrote:

> here after a long time as i'm finding it difficult
> to solve...How to Check whether ResultSet is
> empty..?...as if it is empty then on executing the
> statement resultset.next()...it throws an execption..so how
> to check it....
>
> thanx
> Rajesh

--
Janco Tanis

------------------------------------------------------------
      COAS, Your partner in computer aided services

   Nijverheidsweg 34        Tel:   +31 (0) 187 49 3222
   Postbus 44               Fax:   +31 (0) 187 49 2912
   3250 AA Stellendam       Email: [EMAIL PROTECTED]

___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".

Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html

Reply via email to