|
»
« Return to Thread: Exception on resultset
Re: Exception on resultset
by Joshua Hansen
::
Rate this Message:
Hi Rahul,
Geert already answered your question (i.e. "Use
DbResultSet.hasResultRows()), so you're good there.
As an extra tip, instead of using:
------
select.from(TABLE_BOOKED_ROOMS).where("ROOM_room_id = " + room_id + "");
------
you should consider using:
------
select.from(TABLE_BOOKED_ROOMS).where("ROOM_room_id", "=", room_id);
------
This way your code will be safe from an SQL injection attack. If
'room_id' is an int or Integer, this is less of an issue, but it's still
a good default practice, and it's critical when you are using a String. :)
Josh
--
Joshua Hansen
Up Bear Enterprises
(541) 760-7685
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?
> >
>
--~--~---------~--~----~------------~-------~--~----~
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
| Free embeddable forum powered by Nabble | Forum Help |
