[
https://issues.apache.org/jira/browse/OPENJPA-642?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Fay Wang updated OPENJPA-642:
-----------------------------
Attachment: openjpa-642.patch
> 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
> 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.
