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.229 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:mime-version:content-type:content-transfer-encoding:content-disposition;
        b=X26k0/1CS0cpFlmZVcXy2Qcphh5rIE5TJ8fhPR0pJOtle643DoDFLh5Pl2cCwlsEyX5rvof+7REP0IXOc+xmcBW7xkvpU7mu99bPx6hXtiqIJHRTcaXIdplO4UqPkaalO0YO7dzawmioExhj6ueJEuB0pPUxYOQsRZDfsMuFk5k=
Message-ID: <c25576af0609250702y5280032dx474ded589c9488e1@mail.gmail.com>
Date: Mon, 25 Sep 2006 07:02:40 -0700
From: "Myrna van Lunteren" <m.v.lunteren@gmail.com>
To: derbydev <derby-dev@db.apache.org>
Subject: q re XA transactions and test checkDataSource
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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