[CAY-1063] Derby adapter is not able to remove NOT NULL relationship

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 3.0
• Fix Version/s: 3.0M5
• Component/s: Core Library
• Environment: Does Derby even support this operation?
• Assignee: Tore Halset
• Reporter: Øyvind Harboe
• Created: 03/Jun/08 07:17
• Updated: 08/Nov/08 22:30
• Resolved: 05/Jun/08 21:12

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)