Hi guys.

I'm using Hibernate 3.2.2 with annotations. My app required object inheritance for some of our objects, and we opted on joined inheritance type. The problem is that the root object of the inheritance tree is the most importante object of the system, having 6 subclasses, and the subs with lots of attributes.

I'm building a search method for this top-element object, but as hibernate is including all 6 subclasses tables on the query, it's getting oversized, resulting on the sql error "Maximum output rowsize (32767) exceeded.". Oh, I'm using Informix database with the latest JDBC drivers.

The search method only has to deal with the superclass's atributes, so I'm searching for a way to tell hibernate to fetch only the superclass's ones. Is there a way to do that using annotations? Maybe using xml overriding?

Thanks!

I have found a way to deal with this problem. It has resulted in a few more questions, but here it goes.

For Hibernate not to load all attributes of my subclasses, I'm using hql to select only the ones I want and passing them to an apropriate superclass constructor, like that (from Hibernate's manual):


It's working, but the problem is the returned instance seems to be transient... Is that a way to make it persistent?

Thanks again!