Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cayenne.apache.org
Received-SPF: pass (athena.apache.org: domain of niparasc@gmail.com designates
 209.85.161.171 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:date:message-id:subject:from:to:content-type;
        b=lr2wPYI5VbEy2OirI38csZYaJS60LKBSU1e/ZuDnqZ3lRqrmcb27ev+TebEYo+wbzF
         p/L3zTJcPvejel1tNfzNx7jnJ+q5HOZ2P1jwKGLaNHW76N1D8GPEXdpBWtFasPbNJhJy
         /RWoZ0XeSrFXESHrF/LuuXsr42Spk5QfQpYi8=
MIME-Version: 1.0
Date: Wed, 18 Aug 2010 22:54:43 +0300
Message-ID: <AANLkTi=p6U8vSOJfddJ+0Q6RHbF-4O=AurE==qfvvyPP@mail.gmail.com>
Subject: How to stop a long running query?
From: Nikolaos Paraschou <niparasc@gmail.com>
To: user@cayenne.apache.org
Content-Type: multipart/alternative; boundary=000e0cd59250ddbb5f048e1e6f23

--000e0cd59250ddbb5f048e1e6f23
Content-Type: text/plain; charset=ISO-8859-1

Hello,

I have written a small application in java that interacts with db2 using
apache cayenne.
The application sends a long running query to the db2 server and awaits
response. The query starts executing from within SwingWorker's
doInBackground() method. During the query's execution, a cancel button
appears allowing the user to cancel the operation. When clicked,
SwingWorker's cancel() is called and everything seems to work fine regarding
java code. The SwingWorker thread is canceled (I can confirm that). But,
unfortunately, the other thread running the query doesn't stop (or perhaps
it stops but the query is already being processed by db2 until finished).

Is there any way to stop the query using cayenne specific methods? I tried
to create a new DataContext and bind it to the running thread (the following
code is executed inside doInBackground():

BaseContext.bindThreadObjectContext(DataContext.createDataContext());
ObjectContext oc = BaseContext.getThreadObjectContext();

return oc.performQuery(longRunQuery);

No success.

Thank you,
Nikos

--000e0cd59250ddbb5f048e1e6f23--