db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mike Matrigali (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-4237) scrollable updatable ResultSets should show rows added with insertRow()
Date Tue, 09 Jun 2009 19:30:07 GMT

     [ https://issues.apache.org/jira/browse/DERBY-4237?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel

Mike Matrigali updated DERBY-4237:

    Component/s: JDBC

> scrollable updatable ResultSets should show rows added with insertRow()
> -----------------------------------------------------------------------
>                 Key: DERBY-4237
>                 URL: https://issues.apache.org/jira/browse/DERBY-4237
>             Project: Derby
>          Issue Type: Improvement
>          Components: JDBC
>    Affects Versions:
>         Environment: Windows XP Pro
> Java Version:    1.6.0_13
> Java Vendor:     Sun Microsystems Inc.
> JRE - JDBC: Java SE 6 - JDBC 4.0
> [C:\Program Files\Apache Software Foundation\db-derby-\lib\derby.jar]
- (764942)
>            Reporter: Daniel White
> I have a database table with two fields: ID (integer, primary key, identity) and F1 (varchar,
default '').
> In my Java/JDBC program, I select 2 records from this table into a ResultSet that is
scrollable and updatable.
> I do rs.moveToInsertRow() and rs.insertRow() to add a record to the ResultSet.
> The record gets added to the database, but my ResultSet still has only 2 records in it.
 It doesn't show the new record unless I open a new ResultSet by querying the database again.
 I need to be able to see the record that I added as soon as I have added it, without having
to requery the database.

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message