WAS v8.5 > Develop applications > Develop data access resources > Develop data access applications > Develop data access applications > Benefits of resource references > Requirements for setting data access isolation levels > Access intent serviceCustom finder SQL dynamic enhancement
To ensure data integrity for applications using custom finders defined on EJB version 1.1 home interfaces, WebSphere Application Server v6.x uses custom finder SQL dynamic enhancement to maintain correct SQL locking semantics.
WAS uses SQL clauses applied to the custom finder SQL statements for those custom finders defined with the Update attribute and certain method-level isolation level settings. These dynamic enhancements are applied only if the backend data store supports these clauses.
This support takes affect at run time when the run time attempts to execute container-managed persistence persistence operations associated with the custom finders. To ensure the SQL dynamic enhancements occur correctly for custom finders defined on an EJB version 1.1 home interface accessing a backend data store that requires the special SQL locking clauses, WAS provides new Java Virtual Machine (JVM) and bean (module) properties. These properties enable you to indicate which custom finders should be enhanced, provided the backend store supports the SQL clauses. For more information about these properties, Custom finder SQL dynamic enhancement properties.
There are several important items to consider when using this functionality:
- This support only applies to EJB version 1.1 CMP Custom Finder methods
- Option A CMP beans and CMP beans involved in an inheritance relationship are not supported
Subtopics
- Custom finder SQL dynamic enhancement properties
Use this page to modify custom finder SQL dynamic enhancement properties settings.- Custom finder SQL dynamic enhancement properties
Use this page to modify custom finder SQL dynamic enhancement properties settings.
Related
Establish custom finder SQL dynamic enhancement server-wide
Establish custom finder SQL dynamic enhancement on a set of beans
Establish custom finder SQL dynamic enhancement for specific custom finders
Disable custom finder SQL dynamic enhancement for custom finders on a specific bean