hi to all,
in our application view were created on runtime.
now we are migrating to hibernate.now what should i do,because if view were created on runtime how could i have a mapping class for it......

You can map to a view, but you still need to know the view name and the columns. There's no easy way to do that dynamically at runtime.

Hello Tarun,
what does the database view do for you? are you planning on to use it for Reporting purpose only? I mean just for read only purposes? Also what will be items you know for sure for the view that is going to be created at Runtime?

-Srilatha.

thanks.yes we are creating views just for reporting purpose,but these views are dynamic.i have no information before.

Hello Tarun,
even if the views are dynamic, if you know what columns its going to have and the names of them should be good enough i guess. You don't need a mapping file. All you need is a POJO with attributes named same as Database View column names and generic datatypes defined. Then you can use a ResultSetTransformer to load the data into the POJO.

Hope this helps,
Srilatha.

Thanks latha,now I am able to do with ResultSetTransformer,but is there any solution if i dont know the column attribute before.

I tried by generating class at run time using BCEL but got no succsess.is there any other way

Hi Tarun,
I was searching online after your post.. I was looking for anything that I can find to match your need. Nothing so far. Here is a link with some hints but nothing concrete.
http://docs.jboss.org/hibernate/stable/ ... asses.html
Please post us back and let us know if you find anything.

Sorry could not be of any help,
Srilatha.