« Return to Thread: Exception on resultset

Exception on resultset

by Rahul-36 :: Rate this Message:

Reply to Author | View in Thread


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?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "rife-users" group.
To post to this group, send email to rife-users@...
To unsubscribe from this group, send email to rife-users+unsubscribe@...
For more options, visit this group at http://groups.google.com/group/rife-users?hl=en
-~----------~----~----~----~------~----~------~--~---

 « Return to Thread: Exception on resultset

 
 
 
Google
rifers.org web