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

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

  • Next message: Tore Halset (JIRA): "[jira] Closed: (CAY-1063) Derby adapter is not able to remove NOT NULL relationship"

        [ https://issues.apache.org/cayenne/browse/CAY-1067?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12920#action_12920 ]

    Øyvind Harboe commented on CAY-1067:
    ------------------------------------

    Just some working notes to self...

    Try something like

    SELECT * FROM xxx WHERE UPPER(CAST(foo as NVARCHAR(LEN(foo))) LIKE 'yyy'

    Need access to MS SQL server to try the above...

    From MS SQL docs on UPPER

    Remarks

    character_expression must be of a data type that is implicitly convertible to varchar. Otherwise, use the CAST function to explicitly convert character_expression.

    > 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 - 16:15:18 EDT