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 <[EMAIL PROTECTED]> 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
