Hi all,
I've a little problem with hibernate accessing an entity that has more than one Secondary Table.

My Entity is defined like this:




the generated query is like this one:



This sintax is not supported by the database I'm using (MSAccess. I know it's not officially supported but I cannot change it)

In order to have a working query it should be necessary to enclose the joins in parenthesis, like this:



Is it possible to obtain this behaviour, even extending some hibernate class?

I've also tried adding
@org.hibernate.annotations.Table(appliesTo="tab1", fetch=FetchMode.SELECT) annotation but the resulting query is not changed.

I was expecting to have 3 different selects instead of one with outer joins but this didn't appened.

Any Hint?

Best Regards
Fabio


Hibernate version:
3.3GA

Hi,

I have also used the @Table annotation to modify the join behaviour; but it doesnt work.

The only possibility I found is to change the join behaviour. Therefore you need to extend the database dialect in the hibernate.cfg.xml file; . Your dialect class need simply extend the access dialect and override the method, where you create you own join fragment class. Inside this class you override the method and you ignore the outer joins.

I hope I can help you.

Best regard,
michi

Thank you Michael for your reply.

I already have my own MSDialect class but overriding the create(outer)JoinFragment cannot help me. With this method I found no way to access the actual query string where the "From myTable" part is present.
I need it to insert a "(" just after the "From myTable" fragment when a join is created.

Actually I've solved my problem in a deeper way...I wrote a MS Access JDBC implementation that uses JACOB COM bridge and ADO and that works with Hibernate 3.3. My JDBC Driver parses the sql created by Hibernate and add the required parenthesis.

Actually it's just a ONE-DAY code but it does the work.

Best Regards
Fabio