Re: Updating result set in Java

FYI:  I think I learned enough yesterday that I wouldn't have made the
change even if it was desired by the group.  In talking a little with the
people who really know the database, I got basically this (I paraphase a
little here):

"Yeah, you could do that, I suppose.  That might be kinda nice.  Although
you have to be prepared for the fact that some queries can't be updated.
For example, the query optimizer is going to issue an error if you have a
group by over an index on..."

At this point, I ran away.  My question was answered, and Joe's believe was
upheld.

Regards,

Richard D. Dettinger
AS/400 Java Data Access Team

"Biologists have a special word for stability -- dead"

                Larry Wall
                Open Source Developers Journal
                Issue 1, Jan  2000


"Joe Pluta" <joepluta@plutabrothers.com>@midrange.com on 02/06/2001
08:11:34 AM

Please respond to JAVA400-L@midrange.com

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


To:   <JAVA400-L@midrange.com>
cc:
Subject:  Re: Updating result set in Java



I have to chime in here and agree with the general sentiment: let the
programmer do his thing.  There's nothing more difficult to debug than an
"intelligent" API (no offense!).  I've been bitten more than once by a well
meaning API designer who "assumed" what I meant to do and kindly went and
did it for me.  From a debugging standpoint, it can be very time-consuming;
from an application standpoint, it can be devastating.

Let me make my own mistakes, Richard <grin>.

---------- Original Message ----------------------------------
From: Glenn Holmer <gholmer@weycogroup.com>
Reply-To: JAVA400-L@midrange.com
Date: Tue, 06 Feb 2001 07:52:35 -0600

>Richard Dettinger wrote:
>
> What do people think?  Should the JDBC driver check for this clause and
> append it if missing?

Clearly the programmer's responsibility.

--
____________________________________________________________
Glenn Holmer                          gholmer@weycogroup.com
Programmer/Analyst                       phone: 414.908.1809
Weyco Group, Inc.                          fax: 414.908.1601
+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---

+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---



+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---