[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-5356) Sybase 15 does not support cross join
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5356?page=c...
]
David Boden commented on HHH-5356:
----------------------------------
Also affects 4.0.0.Final. We've worked around it successfully by updating to
SybaseASE15Dialect which fortunately works for us on Sybase 12.5 as well.
My view is that the basic SybaseASEDialect should definitely have the
getCrossJoinSeparator() method overridden to return ", " like in
SybaseASE15Dialect. I doubt whether we really need 2 dialects anyway; should the contents
of SybaseASE15Dialect just be moved to SybaseASEDialect? (we'll have to keep
SybaseASE15Dialect for backwards compatibility now I suppose)?
There's a comment on SybaseASE15Dialect that says:
TODO : verify if this also works with 12/12.5
As far as I can tell, it does! I'll post back if I see any issues with 12.5.
Sybase 15 does not support cross join
-------------------------------------
Key: HHH-5356
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5356
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.5.3
Environment: Hibernate 3.5.3-Final, Sybase 15.0.3 ASE
Reporter: Alexis Kofman
Assignee: Strong Liu
Priority: Minor
Fix For: 3.6.0.CR1
Original Estimate: 10m
Remaining Estimate: 10m
It seems cross join is not yet implemented in Sybase. However the implemented Sybase 15
ASE Dialect in Hibernate use this kind of join :
SybaseASE15Dialect is a subsubclass of Dialect in which we can find :
public String getCrossJoinSeparator() {
return " cross join ";
}
A workaround is to override this method as it is done in Sybase11Dialect.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira