Hibernate Community • View topic - How to union two tables with different columns

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

How to union two tables with different columns

Page 4 of 4

[ 47 posts ]

Go to page Previous 1, 2, 3, 4

Previous topic | Next topic

Author

Message

pepelnm

Post subject:

Posted: Thu Apr 13, 2006 6:08 pm

Expert

Joined: Thu Sep 22, 2005 10:29 am
Posts: 285
Location: Almassera/Valencia/Spain/EU/Earth/Solar system/Milky Way/Local Group/Virgo Supercluster

I cannot see anything strange.

try

Code:

<key-property name="id" type="integer"/>

instead of

Code:

<key-property name="id" type="int"/>

Top

meileng

Post subject:

Posted: Mon Apr 17, 2006 3:29 am

Beginner

Joined: Wed Jan 25, 2006 7:32 am
Posts: 34

Hi Peplmn,

I have tried to use both ways as what you have recommended.

Yet it didn't return the result as what is expected. I have even upgraded MYSQL 5.0 to allow the creation of view table.

Though I can retrieve the view table but the result returned is not as expected.Retriving the view table itself from MYSQL console, has not problem with the same primary key.

I notice that in Hibernate, any entity tables that are mapped either to a normal table or a view table, the result returns need to have a unique key on each of the row of the table. In fact I have set mutable="false".

I think Hibernate need to ensure that it supports for view table even with the same primary key which are union from two tables(these two tables have the same primary key format defined).

Anyway, thanks Pepelmn.! :)