Uploaded image for project: 'Cayenne'
  1. Cayenne
  2. CAY-1063

Derby adapter is not able to remove NOT NULL relationship

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 3.0
    • 3.0M5
    • Core Library
    • None
    • Does Derby even support this operation?

    Description

      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)

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            halset Tore Halset
            oharboe Øyvind Harboe
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment