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