Geek Answers Handbook

To display a database view without a primary key, in hibernate xml mapping

I created a view that will be used to receive data only (read only)

View: Grid_View

My hibm hibernate file

<hibernate-mapping> <class name="hibernate.domain.View" table="Grid_View" mutable="false"> <property name="ACCT_BR_CD" type="string"> <column name="ACCT_BR_CD"/> </property> <property name="ACCT_NO" type="string"> <column name="ACCT_NO"/> </property> <property name="LGL_ENTY_NM" type="string"> <column name="LGL_ENTY_NM"/> </property> <property name="CUST_CTRY_CD" type="string"> <column name="CUST_CTRY_CD"/> </property> <property name="ACCT_SRC_SYS_CD" type="string"> <column name="ACCT_SRC_SYS_CD"/> </property> </class> </hibernate-mapping>

> Since they are not the primary key in my view, I did not mention the id field in my mapping. But a sleeping id is required.

My question

How to continue displaying without id in the hibernation mapping file. And they have no columns with unique values, so they have no chance of making them the key. Please help me solve this problem.

+6
source share
1 answer

You have two options: add a Composite key or add

 <id column="ROWID" type="string" />

Sleep mode requires a unique key to display. The best approach is to add a primary key.

+4
source

More articles:


All Articles