What is the default isolation level that is used by BusinesWorks when using a JDBC connection to select data from a DB2 database? Isthere a way to force an "Uncommitted Read" isolation level for selects from DB2?
Article ID: KB0092628
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks | - |
| Not Applicable | - |
Description
Resolution:
BW doesn't set any default isolation level for its JDBC operations. But you can set the isolation levels to your JDBC operations in several different ways, please refer to the link below for the details.
http://www.db2mag.com/showArticle.jhtml?articleID=186500771
When the isolation level for an application isn't explicitly set using one of these methods, the cursor stability isolation level is used as the default. This default applies to DB2 commands, SQL statements, and scripts executed from the Command Line Processor (CLP) as well as to embedded SQL, ODBC/CLI, JDBC, and SQLJ applications.
Appending "WITH UR" at the end of select statement is the easiest to force Uncommitted Read.
BW doesn't set any default isolation level for its JDBC operations. But you can set the isolation levels to your JDBC operations in several different ways, please refer to the link below for the details.
http://www.db2mag.com/showArticle.jhtml?articleID=186500771
When the isolation level for an application isn't explicitly set using one of these methods, the cursor stability isolation level is used as the default. This default applies to DB2 commands, SQL statements, and scripts executed from the Command Line Processor (CLP) as well as to embedded SQL, ODBC/CLI, JDBC, and SQLJ applications.
Appending "WITH UR" at the end of select statement is the easiest to force Uncommitted Read.
Issue/Introduction
What is the default isolation level that is used by BusinesWorks when using a JDBC connection to select data from a DB2 database? Isthere a way to force an "Uncommitted Read" isolation level for selects from DB2?
Feedback
Yes
No
Powered by
