[jira] Commented: (CAY-1064) Exception for unsupported expression comes too late

From: Andrus Adamchik (JIRA) ("Andrus)
Date: Tue Jun 03 2008 - 15:15:52 EDT

  • Next message: JIRA: "[jira] Commented: (CAY-1064) Exception for unsupported expression comes too late"

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

    Andrus Adamchik commented on CAY-1064:
    --------------------------------------

    > 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.

    Can't do that. Otherwise all DB's support will be downgraded to that of SQLite (the one with the least amount features)

    > 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.

    This archive was generated by hypermail 2.0.0 : Tue Jun 03 2008 - 15:16:20 EDT