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