Re: Exception on resultset

> http://rifers.org/docs/api/com/uwyn/rife/database/DbResultSet.html#ha...()
>
> On 15 Apr 2009, at 11:04, Rahul wrote:
>
>
>
>
>
> > IS there a way for checking out the resultset for size.
>
> > I am doing something like this
>
> > select.from(TABLE_BOOKED_ROOMS).where("ROOM_room_id = " + room_id +
> > "");
>
> >    String result = (String)manager.executeQuery(select, new
> > DbResultSetHandler() {
> >            public Object concludeResults(DbResultSet resultset)
> >            throws SQLException
> >            {
>
> >                    resultset.next();
>
> >                    return resultset.getString("bookedroom_id");
> >            }
> >    });
>
> > However if booked_room table dosnt have any record for the given query
> > then it throws SQl exception java.sql.SQLException: Illegal operation
> > on empty result set.
>
> > Is there any way of checking out the size of resultset or may be other
> > way of doing it?
>
> --
> Geert Bevin
> Terracotta -http://www.terracotta.org
> Uwyn "Use what you need" -http://uwyn.com
> RIFE Java application framework -http://rifers.org
> Flytecase Band -http://flytecase.be
> Music and words -http://gbevin.com