• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

In DB 1 row in resultset nothing

 
Isaac DurĂ¡
Ranch Hand
Posts: 859
2
Java Netbeans IDE Spring
  • 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 DurĂ¡
Ranch Hand
Posts: 859
2
Java Netbeans IDE Spring
  • 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: 3510
16
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
Pie
Posts: 49865
71
  • 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