[CAY-1067] likeIgnoreCase is not supported for CLOBs in MS SQL adapter

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0
• Fix Version/s: 3.0RC1
• Component/s: Core Library
• Assignee: Andrus Adamchik
• Reporter: Øyvind Harboe
• Created: 05/Jun/08 09:42
• Updated: 30/Oct/09 15:56
• Resolved: 30/Oct/09 15:56

Description

I'd like to see likeIgnoreCase be supported for CLOBs in MS SQL w/paged queries.

Is this hard to add?

I'm interested to have a stab at it...

at org.apache.tapestry.listener.ListenerMap.invokeTargetMethod(ListenerMap.java:257)
... 29 more
Caused by: org.apache.cayenne.CayenneException: [v.3.0-SNAPSHOT May 21 2008 12:37:01] Error getting ResultIterator: Query Exception:
java.sql.SQLException: Argument data type text is invalid for argument 1 of upper function.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:364)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2754)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2195)