You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cayenne.apache.org by "Øyvind Harboe (JIRA)" <de...@cayenne.apache.org> on 2008/06/05 11:43:52 UTC
[jira] Created: (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.
[jira] Updated: (CAY-1067) likeIgnoreCase is not supported for
CLOBs in MS SQL adapter
Posted by "Laurentiu Cocanu (JIRA)" <de...@cayenne.apache.org>.
[ https://issues.apache.org/cayenne/browse/CAY-1067?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Laurentiu Cocanu updated CAY-1067:
----------------------------------
Attachment: patch.txt
> 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
> Attachments: patch.txt
>
>
> 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.
[jira] Closed: (CAY-1067) likeIgnoreCase is not supported for CLOBs
in MS SQL adapter
Posted by "Andrus Adamchik (JIRA)" <de...@cayenne.apache.org>.
[ https://issues.apache.org/cayenne/browse/CAY-1067?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Andrus Adamchik closed CAY-1067.
--------------------------------
Resolution: Fixed
Fix Version/s: 3.0
To fix this I used the same idea as expressed in Laurentiu's patch (CAST...), but I impemented it differently to avoid making context assumptions during expression translation. Let me know how this works.
> 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
> Fix For: 3.0
>
> Attachments: patch.txt
>
>
> 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.
[jira] Commented: (CAY-1067) likeIgnoreCase is not supported for
CLOBs in MS SQL adapter
Posted by "Andrus Adamchik (JIRA)" <de...@cayenne.apache.org>.
[ https://issues.apache.org/cayenne/browse/CAY-1067?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13153#action_13153 ]
Andrus Adamchik commented on CAY-1067:
--------------------------------------
I have some doubts about Laurentiu's patch. Need to install SQLServer to try it out.
> 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
> Attachments: patch.txt
>
>
> 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.
[jira] Commented: (CAY-1067) likeIgnoreCase is not supported for
CLOBs in MS SQL adapter
Posted by "Øyvind Harboe (JIRA)" <de...@cayenne.apache.org>.
[ https://issues.apache.org/cayenne/browse/CAY-1067?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12915#action_12915 ]
Øyvind Harboe commented on CAY-1067:
------------------------------------
Somewhat related CAY-1064
> 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.
[jira] Commented: (CAY-1067) likeIgnoreCase is not supported for
CLOBs in MS SQL adapter
Posted by "Øyvind Harboe (JIRA)" <de...@cayenne.apache.org>.
[ 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.