Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

In DB 1 row in resultset nothing

 
Isaac Ferguson
Ranch Hand
Posts: 835
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi

in my DB I have one row but when I execute it




thje resultset is empty
Aany idea, please?

Thanks
 
Seetharaman Venkatasamy
Ranch Hand
Posts: 5575
Eclipse IDE Java Windows XP
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
*public.person* ? *I am not good at DB even in basic level* .. but my guess is that what is the public?
 
Isaac Ferguson
Ranch Hand
Posts: 835
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yes it is very basic

It is the name if the DB scheme

Thats correct
 
K. Tsang
Bartender
Posts: 3349
12
Android Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The public.person seems ok if the public is the schema and person is the table. Did you run the query in the database?

Also how do you if the result set is empty? Did you check res.next()?
 
Campbell Ritchie
Sheriff
Posts: 48452
56
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is public the name of the schema or the table? It is a poor name for either, by the way.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic