cross join issue in hibernate

Question

I have been using Hibernate 3.2 intailly for my J2EE application with Spring 2.5.Recently I wanted a feature of hibernate 3.5(BigInt Identity support).So I have upgraded my hibernate and now I facing a different issue with my queries.

HQL Query:-

select table from tableVO table where tableVO.subTableVO.id=:tableVO.id

SQL Query:-

select table_1_ID from table cross join subTable where subTable.id =table.id

I see that cross join is being done by hibernate which is not accepted by Sybase ASE. How can I fix this?

spoulson · Answer 1 · 2012-11-30T20:34:34.793

3

Check the dialect you have set in hibernate configuration. I'm going to assume you're running on Sybase ASE 15.x. As you found out, Sybase does not (yet) support CROSS JOIN, which is what the SybaseDialect attempts to use. Instead, use SybaseASE157Dialect or SybaseASE15Dialect. It will generate syntax that should look like:

select table_1_ID from table, subTable where subTable.id =table.id

edited Nov 30 '12 at 20:34

answered Nov 29 '12 at 20:33

spoulson

21,335
15
77
102

How was this not upvoted!? Thank you a year and a half later, sir. – jgitter Apr 04 '14 at 14:38

Aba Dov · Answer 2 · 2011-01-31T09:18:02.867

1

You can change hibernate dialect,

in hibernate.cfg

<property name="hibernate.dialect">com.YourProject.YourDialect</property>

in your dialect class you should enter the syntax you want executed.

example dialect change for DB2

public class DB2390Dialect extends DB2Dialect 
{

    public String getIdentitySelectString() {
        return "select identity_val_local() from sysibm.sysdummy1";
    }...
}

Hope this helps

edited Jan 31 '11 at 09:18

answered Jan 31 '11 at 08:28

Aba Dov

962
4
12
20

I am using a SybaseAnyWhereDialect.Any hints on this?? – Dwarakanath Jagadeesan Jan 31 '11 at 10:10
@user288794 you need to override the method that generates the faulty sql. try looking in your dialect class for the syntax generated. – Aba Dov Jan 31 '11 at 10:39
Yes.I am still not able to crack it. – Dwarakanath Jagadeesan Jan 31 '11 at 15:13
@user288794 did you try changing the dialect? – Aba Dov Jan 31 '11 at 16:37
Yes.Used Syabse11 dialect which avoids ANSI joins. – Dwarakanath Jagadeesan Feb 16 '11 at 03:29
@user288794 Great. so why not approve the answer? – Aba Dov Feb 16 '11 at 13:10

score 0 · Answer 3 · answered Nov 30 '12 at 20:41

0

This is a bug with implicit joins in Hibernate. You can fix it by aliasing your joins:

select table from tableVO table
join tableVO.subtableVO subtable
where subtable.id=:tableVO.id

answered Nov 30 '12 at 20:41

Matt Brock

5,337
1
27
26

cross join issue in hibernate

3 Answers3