openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michael Dick (JIRA)" <j...@apache.org>
Subject [jira] Resolved: (OPENJPA-642) Sybase create foreign key on delete set null failed with syntax error
Date Wed, 25 Jun 2008 15:48:45 GMT

     [ https://issues.apache.org/jira/browse/OPENJPA-642?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Michael Dick resolved OPENJPA-642.
----------------------------------

       Resolution: Fixed
    Fix Version/s: 1.2.0
         Assignee: Michael Dick

Committed fix under revision 671585

> Sybase create foreign key on delete set null failed with syntax error
> ---------------------------------------------------------------------
>
>                 Key: OPENJPA-642
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-642
>             Project: OpenJPA
>          Issue Type: Bug
>            Reporter: Fay Wang
>            Assignee: Michael Dick
>             Fix For: 1.2.0
>
>         Attachments: openjpa-642.patch
>
>
> The following alter table statement is rejected:
> ALTER TABLE dbo.JPADeptBean 
>     ADD CONSTRAINT FK_EmpBean_mgr FOREIGN KEY (MGR_EMPID) REFERENCES dbo.JPAEmpBean (empid)
ON DELETE SET NULL
> with com.sybase.jdbc3.jdbc.SybSQLException: Incorrect syntax near the keyword 'ON'.
> According to Sybase IQ 12.7, Sybase  only supports foreign key on delete/update restrict.
> http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc38151_1270/html/iqref/BABCGFHG.htm

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message