Exception for unsupported expression comes too late
---------------------------------------------------

                 Key: CAY-1064
                 URL: https://issues.apache.org/cayenne/browse/CAY-1064
             Project: Cayenne
          Issue Type: Bug
         Environment: MS SQL server and Derby in combination
            Reporter: Øyvind Harboe
            Assignee: Andrus Adamchik


Cayenne MS SQL adapter does not support likeIgnoreCase for CLOB's(does a JIRA 
issue exist?).

However, the *main* problem is that I tested w/Derby and it worked fine. What 
I'd like to see is a way to have Derby(or any other database adapter) fail if a 
feature is not supported on all the adapters.

Ideally I'd like to catch this compile time, but if I can catch the use of 
features which are not supported for  a list of adapters I care about during 
normal smoketesting that will do nicely.


        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