First, I want to excuse to me for my english.

I have a problem with the select generate by hibernate, because it exceds max number of tables accepted by sysbase (>50).

I have a great relations number between my tables in mapping files and I haven't to use lazy loading (lazy=true) in many-to one.

The problem is that Hibernate generate a big select with more than 50 tables name (left outer join table1 .... left outer join tablen). Then when I execute a test to recover a object, I recieve the following error:

<WARN > <org.hibernate.util.JDBCExceptionReporter> SQL Error: 106, SQLState: ZZZZZ
<ERROR> <org.hibernate.util.JDBCExceptionReporter> Too many table names in the query. The maximum allowable is 50.

How can I restrict the level of level o left outer joins generated automatically by hibernate.
I want to recover the first o second level on the hierarchy.

I am use hibernate 3.2 with Sybase

Thanks for your help and attention

You can limit the number of join levels in the generated query with hibernate.max_fetch_depth=n.... have you tried that? I think the mappings also allow a per class fetch depth setting....

hth,
Carl

Thanks, now It's work correctly