RE: JDBC Style

["Price, Chris" <chris_price@xxxxxxxxx>]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
Richard,

I understand that I can't have the File indicators. All I'm asking for is
Cursor indicators (vbg)...

More seriously I'm quite prepared to accept that I may be going  about
things the wrong way - that's why I asked.

I finally worked out why there was no getRowCount() to go with
getColumnCount() (I would have walked right into that performance trap...).
I just get get my head round there not being a isEmpty(), or similar.

May I go and hide in RLA for a while, until I'm ready to play with "proper"
objects. (vbg).

Chris.

-----Original Message-----
From: Richard Dettinger [mailto:cujo@us.ibm.com]
Sent: 27 November 2001 15:33
To: java400-l@midrange.com
Subject: RE: JDBC Style



Well, I'll probably not be appreciated for this, but I would ask the
question, "why do you need to/want to know that a ResultSet is empty before
you try to use it?"

When you want to do something that seems relatively simple like this with a
long existing technology and there is no obvious solution, it often
suggests that you
are designing something at least somewhat out of the norm from the way
applications are typically designed.

BTW:  You can't have your file indicators back because there is no file.
There is only a relation as a result of your executing a query.  If you
want to interact
with file indicators, you can;  they didn't go anywhere.  We keep them nice
and isolated in stored procedures.  Use them until your heart's content.  ;
-)

Richard D. Dettinger
AS/400 Java Data Access Team

Democracy's enemies have always underestimated the courage of the American
people.
It was true at Concord Bridge.  It was true at Pearl Harbor.  And it was
true today.

         Rochester Post-Bulletin
         Tuesday September 11, 2001


"Price, Chris" <chris_price@nsb.co.uk>@midrange.com on 11/27/2001 08:34:58
AM

Please respond to java400-l@midrange.com

Sent by:  java400-l-admin@midrange.com


To:   "'java400-l@midrange.com'" <java400-l@midrange.com>
cc:
Subject:  RE: JDBC Style



This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
Thanks for the answer Dan.

The "problem" I have with using next() to determine if a record set is
empty
, is that it moves the file pointer (oops - betraying my RPG origins now) I
mean cursor, so the result set is changed. I know I can move it back again,
but this seems a bit sloppy to me, hence my post.

The problem may well of course be mine, I'm that I'm still thinking like an
RPG programmer and want to know why I can't have my file indicators
back....(VBG)

Chris

-----Original Message-----
From: Dan Hoover [mailto:dan@hooversys.com]
Sent: 27 November 2001 14:20
To: java400-l@midrange.com
Subject: Re: JDBC Style


if (!rs.next() ) {}

HTH
Dan
----- Original Message -----
From: "Price, Chris" <chris_price@nsb.co.uk>
To: <java400-l@midrange.com>
Sent: Tuesday, November 27, 2001 9:11 AM
Subject: JDBC Style


> This message is in MIME format. Since your mail reader does not
understand
> this format, some or all of this message may not be legible.
> --
> [ Picked text/plain from multipart/alternative ]
> All,
>
> What the best (most elegant, most efficient) way to determine if a JBDC
> Result Set is empty?
>
> Chris
>
>
>
> _______________________________________________
> This is the Java Programming on and around the iSeries / AS400
(JAVA400-L)
mailing list
> To post a message email: JAVA400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
> or email: JAVA400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.
>
>


_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
or email: JAVA400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.
_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
or email: JAVA400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.




_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
or email: JAVA400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.