cayenne-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Рябицкий Евгений <eryabits...@diasoft.ru>
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???

 

Evgeny.

 


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