[jira] Created: (CAY-1067) likeIgnoreCase is not supported for CLOBs in MS SQL adapter

From: JIRA (Øyvind)
Date: Thu Jun 05 2008 - 05:43:52 EDT

  • Next message: JIRA: "[jira] Commented: (CAY-1067) likeIgnoreCase is not supported for CLOBs in MS SQL adapter"

    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.

    This archive was generated by hypermail 2.0.0 : Thu Jun 05 2008 - 05:44:21 EDT