On Sat, Mar 03, 2007 at 18:12:19 -0600, Bruno Wolff III <bruno@xxxxxxxx> wrote: > On Thu, Mar 01, 2007 at 06:16:02 -0800, > Timasmith <timasmith@xxxxxxxxxxx> wrote: > > I am using hibernate, using a view like a read only table and I need a > > primary key each time a select is issued. > > > > create view myview as > > select rownum, t1.field, t2.field > > from tableOne t1, tableTwo t2 > > where t1.key = t2.fkey > > > > select * from myview > > > > But what I really need is > > > > select makemeauniquekey, t1.field, t2.field > > ... > > Is there some reason you can't use the join key? To expand on this, if you are joining on fields that will return only one record for each value, you should still be able to make a primary key for the returned records using a combination of the primary keys of both records being joined. If hibernate only works with primary keys consisting of one column, than you can create a new field using a function of the primary keys of the records being joined.
