[
https://issues.apache.org/cayenne/browse/CAY-1063?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12900#action_12900
]
Ari Maniatis commented on CAY-1063:
-----------------------------------
Argh... sorry about that. What my brain was thinking and I meant to type was
ALTER TABLE log_email ALTER COLUMN sender NULL
This was implemented in Derby 10.2.1.6. I went and looked up the Jira issue for
it just to make sure. [https://issues.apache.org/jira/browse/DERBY-119]
> 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.
