cayenne-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Рябицкий Евгений <>
Subject How to run 2 queries in same connections.
Date Tue, 12 Jan 2010 08:08:55 GMT
Hello 2 everyone!


I have one potential problem:


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


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


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


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). 

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




  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message