handle empty recordset

[KunkalaGuntala Samba Siva Rao]

try {            
    rs = testData.GetResultsByID mainPanel.id, "STORED_PROC_NAME");
    if (rs.next())            
     {                 
        new PopupPanel(new JFrame(), rs);                 
        rs.close();            
     }
     else    
     {         
        JOptionPane.showMessageDialog(mainPanel,"No records found");            
     }        
}        
catch (Exception e) {            
   e.printStackTrace();        
}

before opening the popup, i am trying to say a user message if there are no records returned..
-----
1.
if (rs==null)
doesn't seems to catch a empty resultset returned)
2.
if rs.next()
is used it is skipping to display one record in the popup.
how to get around this , i am hoping i don't have to make an extra database call or use another type of cursor

[Elouise Kivineva]

What class of object is rs ?

[KunkalaGuntala Samba Siva Rao]

Resultset rs;
just a resultset object
rs =...

[Elouise Kivineva]

Well, I don't KNOW but since no one else is taking a shot at this...
I found this in the API for the ResultSet interface
"The number, types and properties of a ResultSet object's columns are provided by the ResulSetMetaData object returned by the ResultSet.getMetaData method."
And the ResulSetMetaData interface has a method getColumnCount().
I'd try that.

[KunkalaGuntala Samba Siva Rao]

yep, this is about the row and records returned.. thanks anyway.. )))