Problem with: QualifierOperatorCaseInsensitiveLike
Problem with: QualifierOperatorCaseInsensitiveLike
- Subject: Problem with: QualifierOperatorCaseInsensitiveLike
- From: "James Cicenia" <email@hidden>
- Date: Mon, 21 Mar 2005 11:11:03 -0600
Hello -
I have been using this Qualifier for a year now, however,
with db2 it just doesn't like it. However, when I get the
sql it generates it works!!!!????
Anyone else have this problem? Know a work around?
Thanks,
James Cicenia
PS: In case you are wanting here is the error...
[2005-03-21 11:01:48 CST] <WorkerThread5>
<com.webobjects.appserver._private.WOComponentRequestHandler>:
Exception occurred while handling request:
com.webobjects.jdbcadaptor.JDBCAdaptorException:
EvaluateExpression failed:
<com.webobjects.jdbcadaptor.JDBCExpression: "SELECT
t0.add_date, t0.add_user_id, t0.last_mod_date,
t0.last_mod_user_id, RTRIM(t0.name), t0.portfolio_id,
t0.row_id, t0.sequence_order FROM portfolio_metric t0
WHERE (UPPER(t0.name) LIKE UPPER(?) ESCAPE '\' AND
t0.portfolio_id = ?)" withBindings: 1:"team SIZE"(name),
2:16(portfolioId)>:
Next exception:SQL State:42610 -- error code: -418 --
msg: DB2 SQL error: SQLCODE: -418, SQLSTATE: 42610,
SQLERRMC: null
Next exception:SQL State:56098 -- error code: -727 --
msg: DB2 SQL error: SQLCODE: -727, SQLSTATE: 56098,
SQLERRMC: 2;-418;42610;
Next exception:SQL State:56098 -- error code: -727 --
msg: DB2 SQL error: SQLCODE: -727, SQLSTATE: 56098,
SQLERRMC: 2;-418;42610;
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden