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

From: Tore Halset (JIRA) ("Tore)
Date: Fri Jun 06 2008 - 02:30:52 EDT

  • Next message: JIRA: "[jira] Commented: (CAY-1063) Derby adapter is not able to remove NOT NULL relationship"

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

    Tore Halset commented on CAY-1063:
    ----------------------------------

    I do not have access (easily) to MS SQL Server these days, but will look at it later. If you are in a hurry, please run the junit tests and patch SQLServerMergerFactory if needed.

    http://cayenne.apache.org/running-unit-tests.html

    > 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: Tore Halset
    > Priority: Minor
    > Fix For: 3.0
    >
    >
    > 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 : Fri Jun 06 2008 - 02:31:15 EDT