Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (nike.apache.org: domain of linuxhippy@gmail.com designates
 209.85.214.172 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type;
        b=Ce2dqTglEzRf3BGBh4mr7HVD/20lBYSq7gV3aqtIwk5NJEEoGAy53UJDAyvwYfcAAq
         RmLeCbVEak4HT5yCwC+fmD/75hNid1yZGEkmPwOGWVFuHUpr0GYnw/luf/3S+gpT+lTf
         dM5rMoWhS1nawu6pTN/Yyye1m3IKpwmF4V+V8=
MIME-Version: 1.0
In-Reply-To: <x662vl6jel.fsf@oracle.com>
References: <AANLkTimBSvGfAC-pVKk3hgzZWjPK4O=WBW+7uHNoFPjp@mail.gmail.com>
	<x662vl6jel.fsf@oracle.com>
Date: Fri, 26 Nov 2010 13:08:13 +0100
Message-ID: <AANLkTikndLqYS8TqxWAGr+ZTQ4a0LYv8zwS7yiJ+U_7S@mail.gmail.com>
Subject: Re: Calling updateRow() after insertRow() leads to
 "java.sql.SQLException: Invalid cursor state"
From: Clemens Eisserer <linuxhippy@gmail.com>
To: Derby Discussion <derby-user@db.apache.org>
Content-Type: text/plain; charset=UTF-8

Hi Dag,

Thanks a lot for talking the time and writing some sample code :)

> You need to do rowset.moveToInsertRow() first, I think. Without it you
>> rowset.updateString("name", "1");
>> rowset.updateString("short", "2");
>
> There is no column called "short" in the table, should be "ikey".

Sorry, those were some left-overs when I tried to reduce production
code to a test-case in a hurry.


> Also, since you are using a scroll insensitive result set to support the
> rowset, you'd need to do another query to see the inserted row (in
> general, although you might get lucky, depending on whether the
> underlying result set has already been inserted into the Derby cache
> used to implement the insensitive semantics).

Thats it, thanks a lot - PostgreSQL's and MySQL's JDBC driver silently
append the row, even if it doesn't match the original query and
without the need to re-run the query.
Hmm, will take quite some time to make those changes, the original
code falls more or less under the "don't touch" category ^^

Thanks again, Clemens