Details
-
Task
-
Status: Closed
-
Minor
-
Resolution: Fixed
-
3.0
-
None
-
None
Description
In UDDI v3, the user supplies entity keys that become the primary key for the entity. The problem is, databases handle case sensitivity with queries. The code currently handles key comparisons with case insensitivity in mind, however, the "find" operation of the JPA EntityManager may react differently depending on the DB. In this case, if the user supplies a key that isn't the exact case of the entity they meant to work with, it will be treated as a new entity. Other unexpected behavior may occur as well.
There are two ways to make this work for both case insensitive and case sensitive databases.
1) automatically convert all user-supplied keys to one case and store it that way (advantages: easy; disadvantages: doesn't preserve user case, for ex, if they want to use CamelCase for Ids)
2) No longer use the "find" operation and instead replace it with a case insensitive query (advantages: preserves user case; disadvantages: "find" is used quite a bit to test for existence, a SELECT query will need to be created for every entity that find was used)
Attachments
Issue Links
- is related to
-
JUDDI-404 Saved keys being converted to lowercase causes problems with keyedReference searches
- Closed