This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes JDBC and the fly likes Result set is empty Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Result set is empty" Watch "Result set is empty" New topic
Author

Result set is empty

sonia pandit
Ranch Hand

Joined: Apr 19, 2008
Posts: 137


I have checked in Sqlplus there are two entries in the table login. It does not go into the loop while(rs.next());

How do I fix this so it works?

Thanks,

Sonia
Edwin Dalorzo
Ranch Hand

Joined: Dec 31, 2004
Posts: 961
If you do this, what do you get?

sonia pandit
Ranch Hand

Joined: Apr 19, 2008
Posts: 137
I cannot do that. I have to use the connection and stmt to execute a query to the database.

THanks,

SOnia
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41599
    
  55
"System.out.println" has nothing to do with the DB - it serves as a debugging aid. The point Edwin was trying to make is that you should check what the actual query looks like that gets sent to the DB.

As a side note, it is much better to use a PreparedStatement than to construct the query on the fly using string concatenation. Amongst other benefits, it makes sure that the code isn't susceptible to SQL injection attacks.


Ping & DNS - my free Android networking tools app
sonia pandit
Ranch Hand

Joined: Apr 19, 2008
Posts: 137
The examples on prepared statements are not that complete.



Is this good? The print statement for the query gives me the following without a semicolon:

and n=0;

Thanks in advance,

Sonia
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41599
    
  55
What happens if you run that query directly against the DB? Are you getting results returned?
sonia pandit
Ranch Hand

Joined: Apr 19, 2008
Posts: 137
yes; i get results.

Sonia
Jaikiran Pai
Marshal

Joined: Jul 20, 2005
Posts: 10067
    
163

In your code are you sure you are connecting to the same database which contains these records?

[My Blog] [JavaRanch Journal]
sonia pandit
Ranch Hand

Joined: Apr 19, 2008
Posts: 137
It was a matter of case. I changed the column to uppercase and it works. I did not realize SQL was case sensitive.
I also changed it to use Prepared Statement. Now somebody has adviced me to use Hibernate and Spring. So I have to research that. Sure I will be posting questions with that.

Thanks,

Sonia
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Result set is empty