The problem is not restricted to %CA. I have had problems using % as a wildcard in the FindGeneric screen and EntitySQLProcessor.
When I experience problems is when I try and search with a wildcard on a string that is longer than just a few characters. Any string field seems to be a problem, haven't tested with numeric fields.
Examples:
02S%000 - I searched on this string in the orderId field of OrderHeader. Got an error on this one:
(ERROR: invalid byte sequence for encoding "UTF8": 0x00)
When I shorten it or change it up a bit I don't get the error but the % get's replaced with a space and I get no results. For example:
02S%09070201 gets replaced with 02S 070201 (the % and 09 were removed).
Vince Clark
[hidden email]
(303) 493-6723
----- Original Message -----
From: "Matthieu Bollot" <
[hidden email]>
To:
[hidden email]
Sent: Friday, July 31, 2009 5:40:34 PM GMT -07:00 US/Canada Mountain
Subject: %CA bug
Hi,
I've got a strange bug, %CA in near every form is replaced by Ê
To reproduce it, you can go to :
https://localhost:8443/webtools/control/FindGeneric?entityName=WorkEffort&find=true&VIEW_SIZE=50&VIEW_INDEX=0in first field "%CA" and validate.
Since it is in every form i tried, it could be a tomcat bug…
I don't know, so I just wanted to let you know and may be someone more
experienced can find it.
best regards,
Matthieu.
P.S. : I did a lot of search for %CA in ofbiz source code, in tomcat
bugzilla and in tomcat source code but I didn't find anything else than
%CATALINA%