can I tell resultset size?

#1 09-05-2008, 11:13 AM

Hi.

I'm using java 1.4.2 JVM talking via thin client to oracle 10.2.0.2 (I
think this db flavor is irrelevant though).
I have a statement that is normal (forward etc from generic
'java.sql.Connection.createStatement()' invocation).
I'm sure there should be results, but the invocation of:
"while (theResults.next()) " is not returning any rows.

I'm not sure how to troubleshoot this deeper, i.e. why I'm not getting
any rows back.

Can someone offer a pointer, advice etc?
thanks
Jeff

#2 09-05-2008, 03:31 PM

kishjeff wrote:
> Hi.
>
> I'm using java 1.4.2 JVM talking via thin client to oracle 10.2.0.2 (I
> think this db flavor is irrelevant though).
> I have a statement that is normal (forward etc from generic
> 'java.sql.Connection.createStatement()' invocation).
> I'm sure there should be results, but the invocation of:
> "while (theResults.next()) " is not returning any rows.
>
> I'm not sure how to troubleshoot this deeper, i.e. why I'm not getting
> any rows back.
>
> Can someone offer a pointer, advice etc?

Have you tried running the query by hand using the command-line client
SQL*Plus?

Or running a "select count(*) from ..." query using the same table(s)
and "where" clause, to count the number of rows which meet the conditions?

Those are the first two things that I try when I'm faced with a
mysteriously-empty result set.

David Harper
Cambridge, England

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode