[jira] [Updated] (DERBY-4237) scrollable updatable ResultSets should show rows added with insertRow()

["Mamta A. Satoor (JIRA)" <ji...@apache.org>]

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

Mamta A. Satoor updated DERBY-4237:
-----------------------------------

    Urgency: Normal
     Labels: derby_triage10_11  (was: )
    
> 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: 10.5.1.1
>         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-10.5.1.1-bin\lib\derby.jar] 10.5.1.1 - (764942)
>            Reporter: Daniel White
>              Labels: derby_triage10_11
>
> 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.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira