Make your own free website on Tripod.com

InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples
FAQs

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

InstantDB: Bug: Duplicate rows inserted on commit()


I am new to InstantDB and JDBC in general, so it is quite possible that
I am missing something (i've been in the OODBMS world).

At any rate, I have idb 3.26 running with JDK 1.3 under Win98.

In my program, I create a connection to my database and turn off
auto-commit.  I then select a result set with a simple query, e.g.:

    SELECT * FROM music

After I get the result set and go to a specific row, I do this:

    rs.updateObject("artist", "some string");
    rs.updateRow();

Then, on the same row without commiting yet, I do another update:

    rs.updateObject("title", "some other string");
    rs.updateRow();

Now I commit my changes:

    con.commit();

When I re-query and get a new result set, I have a duplicate of the row
that I was modifying, the first copy has "some string" in the "artist"
field and the second copy has "some other string" in the "title" field
-- all other fields are their original values, except as noted.

This is not good, especially since one of my fields is auto-increment,
which means that I now have duplicate values.

The editing is being done from my programs GUI, I essentially want the
user to be able to make a whole series of changes and then commit or
rollback en masse.

Am I missing something?

Thanks,

-> richard

-----------------------------------------------------------------------------
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.