You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@openjpa.apache.org by "Michael Dick (JIRA)" <ji...@apache.org> on 2008/06/25 17:48:45 UTC

[jira] Commented: (OPENJPA-642) Sybase create foreign key on delete set null failed with syntax error

    [ https://issues.apache.org/jira/browse/OPENJPA-642?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12608083#action_12608083 ] 

Michael Dick commented on OPENJPA-642:
--------------------------------------

Thanks for the patch Fay!

> 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.