jQuery in Action, 3rd edition
The moose likes JDBC and Relational Databases and the fly likes Temporary Table Returning 0 Rows Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Temporary Table Returning 0 Rows" Watch "Temporary Table Returning 0 Rows" New topic

Temporary Table Returning 0 Rows

Josue Cedeno
Ranch Hand

Joined: Feb 06, 2001
Posts: 71
First, I am using the jdbc-odbc driver.
Using I-SQL I am retrieving a resultset of one row, but in my servlet I am retrieving "0" rows.
Any ideas?
Dave Vick
Ranch Hand

Joined: May 10, 2001
Posts: 3244
Given all of the information you put in the post above the first and most obvious answer is that there is no data in the database.
Now, your next post will say that there is indeed data in the database. then someone will ask you to post the statement you are executing and the code you use to process it. Then you post it and then someone will look at it and answer it...
Let's skip the next few steps and you post all of the info about the problem you can, processing code, the SQL statement, and anything else you think is pertinent.
sorry if this came off as rude, but you didn't tell us anyhting, so how can we answer a question...

Josue Cedeno
Ranch Hand

Joined: Feb 06, 2001
Posts: 71
I can understand your response. It really wasn't a lot to go on, but I do appreciate the summary. And I especially appreciate you taking time to respond.
I was able to solve the problem. I was assuming that it was a problem with the driver (and it still may be). I was testing a "null" result in the stored procedure and the result was not understood. So I changed the test and it worked.
Thanks again.
I agree. Here's the link: http://aspose.com/file-tools
subject: Temporary Table Returning 0 Rows
It's not a secret anymore!