RPC problem

Last Post 08 Mar 2007 07:48 PM by trans53. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
trans53
New Member
New Member

--
08 Mar 2007 05:48 PM
Hi guys, we have this problem that i don't know where to look for:

We are calling stored procedure from another application that does simple insert inside the SP.
I can see the stored procedure call and the actual statement using Profiler but the actual insert never happen.

If i run the same sp using QA everything is ok.

What can be the problem in this case?

Thanks
trans53
New Member
New Member

--
08 Mar 2007 07:48 PM
It's interesting that application does not return any errors and it's using the same account that i am using in QA.


Here is what i found: if i issue COMMIT immidiatelly after the insert or update inside the stored procedure everything looks fine.This SP called from the java and java opens the transaction.

The actual transaction opens from the java side.


Acceptable Use Policy
---