Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Received-SPF: pass (idunn.apache.osuosl.org: domain gmail.com designates
 64.233.184.227 as permitted sender)
DomainKey-Status: good
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=eV4rp9zwZNbI9RhAWDhPW/GdwW+a9/JttF/txGLe9J5uyh/qYO1tWJOD+W1Li8zPqRcT+Max4aYCdLHXerLS+bG5LM4fZtatkrdwVuz4oXjbH0dRdOHZ/WDxg7OxxTA4T6O5GrDkv2XK2hGXbT8gm6wmMqUkrR3vG1dHwDoYXDE=
Message-ID: <c25576af0609250935t6cd6b761yfbe97e7092f1b9e3@mail.gmail.com>
Date: Mon, 25 Sep 2006 09:35:24 -0700
From: "Myrna van Lunteren" <m.v.lunteren@gmail.com>
To: derbydev <derby-dev@db.apache.org>
Subject: Re: q re XA transactions and test checkDataSource
In-Reply-To: <c25576af0609250702y5280032dx474ded589c9488e1@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <c25576af0609250702y5280032dx474ded589c9488e1@mail.gmail.com>

Hi,

Just to be clear, my previous message wasn't accurate.
The lock is set when selects are done from the table ru.
However, once the xar.end() has been issued, with subsequent commit on
cs1, I can't find a way to release those locks so I can drop the
table.

Myrna

On 9/25/06, Myrna van Lunteren <m.v.lunteren@gmail.com> wrote:
> Hi,
>
> In connection to trying to do remote server / IPV6 testing for the
> release candidate, I ran into some behavior in the test
> checkDataSource that I'm trying to understand.
> I don't think there's a bug, but I do need some help.
>
> The problem is that the test doesn't clean up after itself. Thus,
> subsequent tests - e.g. checkDataSource30 - (which run on the same
> database with remote server testing) fail.
>
> This test used to pass because of a subtest that used to get skipped
> for DerbyNetClient.
>
> The problem I'm having is trying to drop the table ru at the end of
> the test. There's a lock on it.
> The lock gets set after this line in the test:
> -------------------------------
>        showStatementState("CS GLOBAL ", csruState);
>        resultSetQuery("Params-global-1", psParams.executeQuery());
> -->     xar.end(xid, XAResource.TMSUCCESS);
>
> My question is: how can I release the locks?
> I've tried closing all statements and committing/rolling back all
> connections I can see, but still the lock remains, or whatever I'm
> attempting gives an error. I probably need to reattach a resource to a
> connection?
> Something like:
>        xar.start(xid, XAResource.TMNOFLAGS);
> ?
> But what I tried so far didn't work (I've tried so many probably
> non-sensible things at this point to even mention them).
> How do I do this?
>
> Thx,
> Myrna
>