Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

handle empty recordset

 
KunkalaGuntala Samba Siva Rao
Greenhorn
Posts: 20
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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
Ranch Hand
Posts: 154
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What class of object is rs ?
 
KunkalaGuntala Samba Siva Rao
Greenhorn
Posts: 20
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Resultset rs;
just a resultset object
rs =...
 
Elouise Kivineva
Ranch Hand
Posts: 154
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 20
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
yep, this is about the row and records returned.. thanks anyway.. )))
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic