Data Connections

Re: Transaction

AliMalek — Tue, 02 Dec 2008 18:56:28 GMT

I can't because the outer implicit transaction definition will cause the inner transaction to be rolled back.

Re: Transaction

Jim Cantwell — Tue, 02 Dec 2008 17:53:19 GMT

You can workaround the rollback by adding a begin transaction/commit transaction to your query command or the stored procedure.

Re: Transaction

AliMalek — Tue, 02 Dec 2008 14:22:10 GMT

Yes, It doesn't save the data.

It always puts rollback after stored procedure call.

Re: Transaction

Hilary Stoupa — Tue, 02 Dec 2008 01:36:32 GMT

So when you publish the form and fill it out, the data is not saved to the database, is that correct?

I understand what you are saying about the implicit transaction and rollback, but in my experience InfoPath only does this the first time it makes the database call, to generate the schema, then it runs the procedure again, without the rollback.

Re: Transaction

AliMalek — Tue, 02 Dec 2008 01:29:51 GMT

Thanks for clarification. When I publish the form on sharepoint and fill it, clicking on save button (uses the code specified above), will put implicit transaction before and rollback after stored procedure call.

Re: Transaction

Hilary Stoupa — Mon, 01 Dec 2008 23:49:35 GMT

Actually, the post I refer to, the second entry, he refers to the behavior of calling the stored procedure twice, once to generate schema. By "IP Query" I meant "InfoPath Query". I apologize for being unclear. What happens when you run your form and it actually calls the stored procedure? Is your data saved to the database?

Re: Transaction

AliMalek — Mon, 01 Dec 2008 21:31:01 GMT

Sorry, I don't know what do you refer to as "IP Query" and can't find any similarity between my case and the one in your posting.

Re: Transaction

Hilary Stoupa — Mon, 01 Dec 2008 21:12:51 GMT

I do know that when IP queries, the first query call will be to create the schema, the second query call with actually execute the sproc. This post has a little info on that.... When you test the form, does your sproc execute?

Re: Transaction

AliMalek — Fri, 28 Nov 2008 21:19:26 GMT

Any feedback?

I use something like the following code when I need to save data fields on SQL Server:

XDocument.QueryAdapter.Command = "exec dbo.SaveSQLComplexDBinfo " + SQLComplexDBID + ",'" + ComplexName + "','" + DBName + "','" + AppCode + "'";
XDocument.Query();

When I check database activity, I see that something like this will be issued to SQL Server:

set implicit_transactions on SET NO_BROWSETABLE ON
exec dbo.SaveSQLComplexDBinfo 96,SQLDA-CX02','ATT25','ACTT'
IF @@TRANCOUNT > 0 ROLLBACK TRAN

I need the data to be saved. Why does Query() method wrap the actual query in a transaction and how can I prevent that?

Thanks

Transaction

AliMalek — Thu, 27 Nov 2008 21:50:59 GMT

Hi,

How can I get rid of begin transaction and rollback that Infopath puts around any data change I have in user interface preview form? I would like to be able to test my form.

Thank

Ali