Mailing-List: contact dev-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cayenne.apache.org
Received-SPF: pass (nike.apache.org: local policy)
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----_=_NextPart_001_01CA935E.7C8FF5BA"
Subject: How to run 2 queries in same connections.
Date: Tue, 12 Jan 2010 11:08:55 +0300
Message-ID: <3DEE6BDD7473324C8320C35F924F1DF90553408F@PALLADA.diasoft.ru>
Thread-Topic: How to run 2 queries in same connections.
Thread-Index: AcqTXnyIix1YM2ZGS9GXPGs1WiDG6g==
From: =?koi8-r?B?8tHCycPLycog5dfHxc7Jyg==?= <eryabitskiy@diasoft.ru>
To: <dev@cayenne.apache.org>

------_=_NextPart_001_01CA935E.7C8FF5BA
Content-Type: text/plain;
	charset="koi8-r"
Content-Transfer-Encoding: quoted-printable

Hello 2 everyone!

=20

I have one potential problem:

=20

We have stored procedure on MS SQL Server. It's doing some job and =
return result in special table marked with connection id (@@SPID).

=20

So next query is to get result: SELECT * FROM SpecTable WHERE spid =3D =
@@SPID

=20

So these 2 queries should be in same connection (to have same @@SPID).

=20

In first solution there was huge transaction wrapping around this 2 =
queries and I think there was same connection.

But for performance proposes I can't use one huge transaction, so I =
switched to explicit transaction (to not have any transaction).=20

Now I am not sure how to make sure that these queries are performed in =
same connections???

=20

Evgeny.

=20


------_=_NextPart_001_01CA935E.7C8FF5BA--