Re: Exception on resultset

>
> 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?
> >