Re: [GENERAL] Can I getting a unique ID from a select

2007-03-06 Thread Bruno Wolff III
On Mon, Mar 05, 2007 at 17:07:25 -0800, Timasmith <[EMAIL PROTECTED]> wrote: > > > > > > > create view myview as > > > > > select rownum, t1.field, t2.field > > > > > from tableOne t1, tableTwo t2 > > > > > where t1.key = t2.fkey > > Multiple rows with the same key renders Hibernate useless as i

Re: [GENERAL] Can I getting a unique ID from a select

2007-03-06 Thread Timasmith
On Mar 5, 3:35 am, [EMAIL PROTECTED] (Bruno Wolff III) wrote: > On Sat, Mar 03, 2007 at 16:46:45 -0800, > Timasmith<[EMAIL PROTECTED]> wrote: > > > On Mar 3, 7:12 pm, [EMAIL PROTECTED] (Bruno Wolff III) wrote: > > > On Thu, Mar 01, 2007 at 06:16:02 -0800, > > > Timasmith<[EMAIL PROTECTED]> wrote:

Re: [GENERAL] Can I getting a unique ID from a select

2007-03-05 Thread Bruno Wolff III
On Sat, Mar 03, 2007 at 16:46:45 -0800, Timasmith <[EMAIL PROTECTED]> wrote: > On Mar 3, 7:12 pm, [EMAIL PROTECTED] (Bruno Wolff III) wrote: > > On Thu, Mar 01, 2007 at 06:16:02 -0800, > > Timasmith<[EMAIL PROTECTED]> wrote: > > > > > create view myview as > > > select rownum, t1.field, t2.field

Re: [GENERAL] Can I getting a unique ID from a select

2007-03-04 Thread Timasmith
On Mar 3, 7:12 pm, [EMAIL PROTECTED] (Bruno Wolff III) wrote: > On Thu, Mar 01, 2007 at 06:16:02 -0800, > Timasmith<[EMAIL PROTECTED]> 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 > > s

Re: [GENERAL] Can I getting a unique ID from a select

2007-03-04 Thread Bruno Wolff III
On Sat, Mar 03, 2007 at 18:12:19 -0600, Bruno Wolff III <[EMAIL PROTECTED]> wrote: > On Thu, Mar 01, 2007 at 06:16:02 -0800, > Timasmith <[EMAIL PROTECTED]> 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. > > > > c

Re: [GENERAL] Can I getting a unique ID from a select

2007-03-03 Thread Bruno Wolff III
On Thu, Mar 01, 2007 at 06:16:02 -0800, Timasmith <[EMAIL PROTECTED]> 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

Re: [GENERAL] Can I getting a unique ID from a select

2007-03-01 Thread Bill Moran
In response to "Timasmith" <[EMAIL PROTECTED]>: > I am using hibernate, using a view like a read only table and I need a > primary key each time a select is issued. > > So in Oracle terms this might work, though I am skeptical that > Hibernate is going to return a cached result. > > create view