likeIgnoreCase is not supported for CLOBs in MS SQL adapter
-----------------------------------------------------------

                 Key: CAY-1067
                 URL: https://issues.apache.org/cayenne/browse/CAY-1067
             Project: Cayenne
          Issue Type: New Feature
          Components: Cayenne Core Library
    Affects Versions: 3.0
            Reporter: Øyvind Harboe
            Assignee: Andrus Adamchik


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)

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to