Hi,
I am using JSp to retrieve data from a database. I need to check if the result set is empty.
My code is as follows :

stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSIT IVE,ResultSet.CONCUR_READ_ONLY);


if(!rs.next())
{
data not there
}
else
{
rs.beforeFirst;
while(rs.next()
{
data there
}
}
However, i notice that just the usage of this create statement is making teh code behave improperly. This is a very urgent requirement.
Thanks,
Shubha