Mailing-List: contact commits-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cayenne.apache.org
Message-ID: <1383771724.1256198819443.JavaMail.jira@brutus>
Date: Thu, 22 Oct 2009 08:06:59 +0000 (UTC)
From: "Andrus Adamchik (JIRA)" <jira@apache.org>
To: commits@cayenne.apache.org
Subject: [jira] Updated: (CAY-1067) likeIgnoreCase is not supported for
 CLOBs in MS SQL adapter
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable


     [ https://issues.apache.org/jira/browse/CAY-1067?page=3Dcom.atlassian.=
jira.plugin.system.issuetabpanels:all-tabpanel ]

Andrus Adamchik updated CAY-1067:
---------------------------------

    Fix Version/s:     (was: 3.0 beta 1)
                   3.0

> likeIgnoreCase is not supported for CLOBs in MS SQL adapter
> -----------------------------------------------------------
>
>                 Key: CAY-1067
>                 URL: https://issues.apache.org/jira/browse/CAY-1067
>             Project: Cayenne
>          Issue Type: Bug
>          Components: Cayenne Core Library
>    Affects Versions: 3.0
>            Reporter: =C3=98yvind Harboe
>            Assignee: Andrus Adamchik
>             Fix For: 3.0
>
>         Attachments: patch.txt
>
>
> I'd like to see likeIgnoreCase be supported for CLOBs in MS SQL w/paged q=
ueries.
> Is this hard to add?=20
> I'm interested to have a stab at it...
> at org.apache.tapestry.listener.ListenerMap.invokeTargetMethod(ListenerMa=
p.java:257)
> ... 29 more
> Caused by: org.apache.cayenne.CayenneException: [v.3.0-SNAPSHOT May 21 20=
08 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.ja=
va:364)
> at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2754)
> at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2195)

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