CustomRegistry Using a Datasource Causes CONM6000W with DBMgr Datasource
 Technote (FAQ)
 
Problem
Implementing the CustomRegistry interface with a data source to access user information causes the following error:
"CONM6000W: A resource was unable to process the two phase commit prepare request as it only supports the one phase commit protocol. The datasource was: DBMgr"
 
Cause
WebSphere® Application Server InfoCenter chapter 5.2 covers the use of custom registries and explains how to imlement them for use by an application. One of the possible implementations entails having a CustomRegistry interface connect to a database to manipulate the security information desired. A defect (PQ55941) has been reported when use of this interface is implemented through a datasource. The defect comes from an implicit architectural limitation where WebSphere uses a one phase commit driver to access the respository database.
 
Solution
WebSphere Application Server Release Notes for 4.0.3 and above address a circumvention for the above defect by applying a connection property for the DBMgr datasource as follows:

When using a data source in the CustomRegistry implementation, the following property needs to be set in the admin.config file which resides in $WAS_HOME\bin directory (where $WAS_HOME is WebSphere Appliation Server's installed directory) to avoid the 1PC (one phase) committing problem:

com.ibm.websphere.security.customuserregistry.datasource=true

This property should only be set when the CustomRegistry is using a data source. If the registry is changed to use LocalOS or LDAP or a CustomRegistry that does not use a data source this property should be set to false or removed completely from the admin.config file. If this is not done, the server may encounter a deadlock condition during initialization.

When using this property, it is very important that the CustomRegistry implementation not make calls to WebSphere Application Server System Management (SM) for example through use of WSCP or xmlConfig. These calls may result in a database deadlock or other unpredictable results.

 
 
 


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > Security
Operating system(s): HP-UX
Software version: 4.0
Software edition:
Reference #: 1145353
IBM Group: Software Group
Modified date: Nov 18, 2003