Hey all!
I am using Hibernate3 with DB2 v9.5 via IBMs DB2JCC driver, and I have run into a weird problem with mapping a view in my webapp. I have created a view that fetches some data from a table and mapped it as I would a table in the .hbm file. Strange behavior follows: when my application calls the get() method that should in theory return the Set of all objects returned from that view, Hibernate hangs somewhere. It does create the SQL command, and it eats up a connection as was proven by connections running out if I call the get() method too many times, but the connection seems to just hang on the Select indefinitely.
Previously, when using a table in place of the view, everything was working dandy. Switching to a view introduced this strange behavior. I am very new to Hibernate, so it's possible I am missing something obvious. All tables work great, but this one view does not play nice.

Below is a mock-up of what my mapping looks like. I reduced the number of columns being mapped and the names of entities, but the gist is there.

And here's what a view backing the above mapping would look like:

You are not describing your problem in sufficient details. What is a view? If you are new to Hibernate, there are many mistakes you can make to make it hang. Even the simple example you posted has a mistake: your description string does not have a length="" attribute. Could it be that the string exceeds that length? Could that be possible in some other string somewhere?

If I were, you I would edit my problem description to be more detailed so people can get a grasp of your environment. I suspect that your problem might be in your class metadata file (*.hbm.xml) files but I can't be sure.

Hey! Thank you for the reply. To clarify, I am running IBM DB2 v9.5 and am using a View to select some fields from a table. I need a view for a somewhat complex query, but for this test I replaced it with a simple select ala:


I have edited my OP to reflect this information.