Hibernate version 3.2.6
Oracle 10g

Hi,

I'm trying to perform a simple



but Hibernate is not returning the expected results. I have the "show_sql" enabled and when I execute the SELECT sql statement that Hibernate prints to the console it shows a different resultset than the one returned by createQuery through the object.

Could this be a mapping configuration problem? This is my first time using Hibernate but so far I have the same setup as all the sample codes I've found. If someone knows any possible reasons or any "must" please reply to this post.

Any help will be really appreciated! Thanks!

So, your list should be a collection of MyJavaObject types, correct? The list is holding lazy objects, that need to be cast into the appropriate type.

A list.get(0).getClass() would tell you exactly what class type the list contains. You might want to print that information to the console, assuming of course at least one record is returned. Otherwise you'll get an ArrayIndexOutOfBounds exception.

Shoot us a snippet of your Java code if you can.

Hi,

The list of MyJavaObjects is being returned but the problem is that Hibernate is filling them up with incorrect data. When I execute the SELECT statement that it prints (and that it apparenlty is using to retreive the data from the database) the results I get from an external tool such as SQL*Plus and Oracle SQL Developer is not compatible with the one that I got from the result set object (list). Sorry for not being able to provide you with the code snippet.

Thanks for your help!

Does this class have an association to another class? Could you please briefly explain the differences you got in your two results?

Can you post the sql statement which get generated from Hibernate

Thank

Hi to all,

I have finally solved the problem. I had to identify that my primary key was a <composite-id> in my hbm.xml file.

Thank you all very much for your help!

Thanks for the solution!