I have a view in my DB that has the following information

TableName ColumnName ColumnIndex

It is just a join of some system tables that will allow my web app to be more dynamic. How do I map this view with Hibernate?? I read that you can treat a view like a table but for this instance this view is not normalized meaning...

TableName ColumnName ColumnIndex
A dd 1
A sss 2
B a 1

That is in the table and a table name won't be exclusive for every entry


Any help or claificaiton would be great!!

Thanks in advace.

b

Just wanted an email reminder ;)

Well you'd have a composite key...

Beware that a lot of databases have strict rules about perfoming DML against views (inserts, updates, deletes).

Right, this is going to be just a reference table where that application writer can lookup when he or she wants to put all the columns with check boxes, the names of the columns are also in user friendly form.


Thanks, Ill keep whomever posted ;)

Views don't have primary keys in DB2.

How can I simply query a view that I have on the database side, and assign that resulting query to a bean????

Thanks

I said key. Whether or not you have a physical PK on the database is irrelevant to Hibernate. I suggest just trying things out.

Thank you.