[jira] Created: (CAY-1063) Derby adapter is not able to remove NOT NULL relationship

From: JIRA (Øyvind)
Date: Tue Jun 03 2008 - 03:18:52 EDT

  • Next message: Andrey Razumovsky (JIRA): "[jira] Updated: (CAY-1060) CM: Allow multiple item selections"

    Derby adapter is not able to remove NOT NULL relationship
    ---------------------------------------------------------

                     Key: CAY-1063
                     URL: https://issues.apache.org/cayenne/browse/CAY-1063
                 Project: Cayenne
              Issue Type: Bug
              Components: Cayenne Core Library
        Affects Versions: 3.0
             Environment: Does Derby even support this operation?
                Reporter: Øyvind Harboe
                Assignee: Andrus Adamchik
                Priority: Minor

    31000 [SocketListener0-9] INFO org.apache.cayenne.access.QueryLogger - Detected and installed adapter: org.apache.cayenne.dba.derby.DerbyAdapter
    45641 [SocketListener0-9] INFO org.apache.cayenne.access.QueryLogger - ALTER TABLE log_email ALTER COLUMN sender DROP NOT NULL
    45704 [SocketListener0-9] INFO org.apache.cayenne.access.QueryLogger - *** error.
    java.sql.SQLException: Syntax error: Encountered "DROP" at line 1, column 43.
            at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
            at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
            at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
            at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
            at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
            at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
            at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
            at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
            at org.apache.cayenne.merge.ExecutingMergerContext.executeSql(ExecutingMergerContext.java:60)
            at org.apache.cayenne.merge.AbstractToDbToken.execute(AbstractToDbToken.java:41)

    -- 
    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 - 03:19:20 EDT