Thanks again, John. Got it.
Pete
--
Peter Hearty peter.hearty@lutris.com
Lutris Technologies (UK) http://www.lutris.com
----- Original Message -----
From: "Cummings, John" <john.cummings@aetna.com>
To: <instantDB@enhydra.org>
Sent: Tuesday, November 07, 2000 3:33 PM
Subject: RE: InstantDB: scrollable result set minor issue
> peter,
>
> the only place i saw it referenced was in the jdbc tutorial
> http://java.sun.com/docs/books/tutorial/jdbc/jdbc2dot0/inserting.html
>
> john
>
> -----Original Message-----
> From: Peter Hearty [mailto:peter.hearty@lutris.com]
> Sent: Tuesday, November 07, 2000 8:14 AM
> To: instantDB@enhydra.org
> Subject: Re: InstantDB: scrollable result set minor issue
>
>
> John
>
> Thanks very much for pointing this out. I think you're right - a driver
> should indeed sit on the insert row until it's told to move off of it.
I'll
> see that this gets fixed in the next release.
>
> I've been looking over both the spec and JDK 1.2 javadocs and can't find
> anywhere where this is made explicit though. Just out of curiosity, could
> you point me to it?
>
> Regards
>
> Pete
>
> --
>
> Peter Hearty peter.hearty@lutris.com
> Lutris Technologies (UK) http://www.lutris.com
> ----- Original Message -----
> From: "Cummings, John" <john.cummings@aetna.com>
> To: "'instantdb l(istserver)'" <instantdb@enhydra.org>
> Sent: Monday, October 30, 2000 4:48 PM
> Subject: InstantDB: scrollable result set minor issue
>
>
> > hi,
> > sun's jdbc doc specfically states that multiple inserts can be performed
> > without re-issuing the "moveToInsertRow". under instantdb 3.21 i needed
to
> > reissue the moveToInsertRow after each insertRow. see code below
> >
> > stmt =
> >
>
dbPhoneConnect.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.C
> > ONCUR_UPDATABLE);
> > srs = stmt.executeQuery("SELECT * FROM PHONES");
> > srs.moveToInsertRow();
> > srs.updateLong("OID", 1);
> > srs.updateLong("CALLEROID", 2);
> > srs.updateString("PHONENUMBER", "203-488-4298");
> > srs.updateString("PHONETYPE", "OFFICE");
> > srs.updateString("PHONEEXT", "NONE");
> > srs.insertRow();
> > srs.moveToInsertRow();
> > ************* without this throws sql exception
> > srs.updateLong("OID", 2);
> > srs.updateLong("CALLEROID", 2);
> > srs.updateString("PHONENUMBER", "203-483-8052");
> > srs.updateString("PHONETYPE", "CELL");
> > srs.updateString("PHONEEXT", "NONE");
> > srs.insertRow();
>
> --------------------------------------------------------------------------
> ---
> > To unsubscribe from this mailing list, send email to
majordomo@enhydra.org
> > with the text "unsubscribe instantdb" in the body of the email.
> > If you have other questions regarding this mailing list, send email to
> > the list admin at owner-instantdb@enhydra.org.
> >
>
> --------------------------------------------------------------------------
--
> -
> To unsubscribe from this mailing list, send email to majordomo@enhydra.org
> with the text "unsubscribe instantdb" in the body of the email.
> If you have other questions regarding this mailing list, send email to
> the list admin at owner-instantdb@enhydra.org.
> --------------------------------------------------------------------------
---
> To unsubscribe from this mailing list, send email to majordomo@enhydra.org
> with the text "unsubscribe instantdb" in the body of the email.
> If you have other questions regarding this mailing list, send email to
> the list admin at owner-instantdb@enhydra.org.
>
-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.
|