Setting transaction isolation level for servlet and JavaServer Pages (JSP) database access
 Technote (troubleshooting)
 
Problem(Abstract)
Whenever a database connection is obtained from a WebSphere® Application Server data source by a Java™Server Pages (JSP) , servlet or application running in the Web container, the transaction isolation level defaults to TRANSACTION_REPEATABLE_READ.
 
Resolving the problem
When accessing a data source using application code, such as a JSP or servlet running in the Web container, there are fewer options to change the transaction isolation level for the connection than when using an EJB. To change the transaction isolation level for a JSP or servlet, you must insert a setTransactionIsolationLevel(value) in the code immediately after the getConnection(value).

This is also true for setIsolationLevel().

 
 
Cross Reference information
Segment Product Component Platform Version Edition
Application Servers Runtimes for Java Technology Java SDK
 
 


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > DB Connections/Connection Pooling
Operating system(s): Windows
Software version: 6.1
Software edition:
Reference #: 1168426
IBM Group: Software Group
Modified date: Mar 1, 2005