Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.java.databases > #234

Re: can I tell resultset

Show all headers | View raw

  To: comp.lang.java.databases
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

---
 * Synchronet * The Whitehouse BBS --- whitehouse.hulds.com --- check it out free usenet!
--- Synchronet 3.15a-Win32 NewsLink 1.92
Time Warp of the Future BBS - telnet://time.synchro.net:24

Back to comp.lang.java.databases | Previous | Next | Find similar

Thread

Re: can I tell resultset "David Harper" <david.harper@THRWHITE.remove-dii-this> - 2011-04-27 15:22 +0000

csiph-web