openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Fay Wang (JIRA)" <j...@apache.org>
Subject [jira] Created: (OPENJPA-642) Sybase create foreign key on delete set null failed with syntax error
Date Tue, 24 Jun 2008 16:44:44 GMT
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.


Mime
View raw message