Hello everyone,

Can anyone clarify my understanding:

I have an entity ("Organization") that I often fetch by it's key (a
String).

In DB2 (v9.5 community) the ID field is a CHAR(10).

I've been using EntityManger.find(Class, String) to do the job for
months.

I was prettying-up URLs in my web layer when I noticed this behavior:

(1) When I pass in: "ORG-10   " (note the trailing spaces) I get an
entity with "ORG-10   " (with trailing spaces) as it's ID.

(2) When I pass in "ORG-10" (trimmed) I get an entity with "ORG-10"
(trimmed) as it's ID.

Behavior #2 surprised me! I expected "ORG-10   ", with trailing spaces,
just as it is in the database.

As an experiment, I changed my service implementation to use a query on
the key instead of find() and the behavior goes away. That is, I get
"ORG-10   " as the ID of the Organization regardless of whether the
input was trimmed or not.

Am I misunderstanding how it should work?

--Rich