You are viewing limited content. For full access, please sign in.

Question

Question

Workflow & Forms SQL Isolation Levels

Workflow Forms
Updated December 29, 2022
asked on December 23, 2022 • Show version history

When using the Custom Query or the Query Data activities in Workflow, do they set the Isolation Level to Read Uncommitted or just use the SQL default of Read Committed? I know with the Custom Query activity Read Uncommitted can be added as part of the query, just wanted to make sure I was thinking about it correctly.

The same question goes for queries from Forms, does it use the default Read Committed or do its queries just use Read Uncommitted?

If the answer to either of these is that it uses the SQL default of Read Committed, are there any plans to be able to set them individually to Read Uncommitted?

0 0

Replies

replied on December 23, 2022

SQL Server Transaction Isolation Level and Isolation Levels in SQL Server for reference.

I cannot imagine the Custom Query and Query Data activities would deliberately deviate from the SQL Server default of Read Committed behind the scenes. Can you provide some context on why you'd want to allow "dirty reads"?

0 0
replied on December 23, 2022

We have a custom database that is used quite heavily in one of our approval processes. Some of the queries we perform against it do not care if the data is necessarily "dirty" so we have been asked by our DBA's to set the isolation levels to READ UNCOMMITTED in those cases to help prevent locks.

0 0
replied on December 29, 2022

Gotcha. I'd stick with Workflow Customer Query activities where possible and add the parameter yourself. 

While this won't be a feature for the foreseeable future, if it were in Forms, what's the level/granularity you would want/expect to be able to specify the isolation level at? Data source as a whole? Individual lookups?

0 0
replied on December 29, 2022

I had actually thought of about that question before you asked it. I think I would want to do it for the Data Source as a whole. If I happened to need to Read Uncommitted and Read committed for the same data source I would create 1 for each in Forms and name them accordingly. Basically treat them the same way as an ODBC connection. 

1 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...