Sybase Dialect - Override supportsCascadeDelete to return "false"

Description

It seems that Sybase doesn't supports "on cascade delete" [1][2]. Some tests under BulkManipulationTest fails due to this.
A possible solution is to override supportsCascadeDelete in SybaseDialect to return "false".

[1] http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15.0.sqlug/html/sqlug/sqlug351.htm
[2] http://groups.google.com/group/sybase.public.ase.general/browse_thread/thread/a74a285d150906ee

Environment

Hibernate from Branch_3_2_4_SP1_CP with Sybase 15.

Activity

Show:
Juraci Paixão Kröhling
October 1, 2008, 1:19 PM

Actually, the tests are failing due to another issue. But I guess that this is indeed an issue:

13:18:02,806 DEBUG SchemaExport:303 - alter table nonleafsubclass add constraint FK2C4413E3DED31D14 foreign key (sid) references rootclass on delete cascade
13:18:02,954 ERROR SchemaExport:274 - Unsuccessful: alter table nonleafsubclass add constraint FK2C4413E3DED31D14 foreign key (sid) references rootclass on delete cascade
13:18:02,954 ERROR SchemaExport:275 - Incorrect syntax near the keyword 'on'.

Gail Badner
December 18, 2008, 10:05 PM
Gail Badner
December 19, 2008, 9:13 PM

Since SQL Server supports cascade-delete and SQLServerDialect extends SybaseDialect, SQLServerDialect.supportsCascadeDelete() was added to return true.

Gail Badner
December 19, 2008, 9:14 PM

Fixed in Branch_3_2, Branch_3_2_4_SP1_CP, Branch_3_3, and trunk.

Steve Ebersole
March 21, 2011, 7:06 PM

Bulk closing stale resolved issues

Assignee

Gail Badner

Reporter

Juraci Paixão Kröhling

Fix versions

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

Priority

Major
Configure