Is there a way to map an sql statement to a java class that doesn’t exist. The reason I would want to do such a thing is because the reporting portion of my application returns result sets that do not directly map to domain objects.

Here is a simplified example of what I would like to do.



Is there anyway to do this sort of thing without creating a Java class that maps to the MyHeterogeneousResults reference. If this is possible it would be great because I wouldn’t have to create classes for every mix of data I need to return. I have some queries in my application that do not map nicely to objects however majority of my application utilizes hibernate, and I would like to keep with this framework for database interaction.

Thanks,

Keith

You can use the return-scalar element in you named query see section 17.3 of the doc for example
http://www.hibernate.org/hib_docs/v3/re ... medqueries

For this functionallity, Hibernate is probably not the righ tool.

Since you apparently want to retrieve different columns for each request, my suggestion would be to create a custom class that take a hash-map as parameter defining which columns to retrieve and what condition should be set for that column.

Then you could generate your own SQL-statement , execute it, and parse up the result anyway you want (Set of Object-arrays, vectors or any matrix you would feel comfortable reading from to present).

As notet at the last page in Hibernate In Action :

Please don't quote from Hibernate2 documentation when you talk about Hibernate3.

The quote was taken from Hibernate In Action, and it clearly states that most of it still is valid in Hibernate 3.

from the foreword :



I also believe this quote is valid regardless of which persistence-system you use.

I don't think the scalar-value approach is good enough, if the case is that the queries is defined at run-time. Then the actual columns isn't decided when the mapping is written, thus we can't name thye columns in the mapping-file, but have to dynamically generate the sql according to the choises made by the user.

I'm the author of your quote and I tell you it is _NOT_ valid.