You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openjpa.apache.org by "Fay Wang (JIRA)" <ji...@apache.org> on 2008/06/24 18:44:44 UTC
[jira] Created: (OPENJPA-642) Sybase create foreign key on delete
set null failed with syntax error
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.
[jira] Commented: (OPENJPA-642) Sybase create foreign key on delete
set null failed with syntax error
Posted by "Michael Dick (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Updated: (OPENJPA-642) Sybase create foreign key on delete
set null failed with syntax error
Posted by "Fay Wang (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Resolved: (OPENJPA-642) Sybase create foreign key on delete
set null failed with syntax error
Posted by "Michael Dick (JIRA)" <ji...@apache.org>.
[ 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.