RE: [Reactor For CF] Oracle support for Reactor

2006-02-21 Thread Bowden, Beth \(NIH/NIEHS\) [E]
27709 -Original Message- From: Sean Corfield [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 21, 2006 1:55 AM To: reactor@doughughes.net Subject: Re: [Reactor For CF] Oracle support for Reactor On 2/20/06, Doug Hughes [EMAIL PROTECTED] wrote: So, when working with oracle you need

RE: [Reactor For CF] Oracle support for Reactor

2006-02-21 Thread Bowden, Beth \(NIH/NIEHS\) [E]
. BOX 12233, Research Triangle Park, NC 27709 From: Brian Kotek [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 21, 2006 8:18 AM To: reactor@doughughes.net Subject: Re: [Reactor For CF] Oracle support for Reactor Perhaps something user-configurable in the config set specifically

Re: [Reactor For CF] Oracle support for Reactor

2006-02-21 Thread Brian Kotek
CTED]] Sent: Tuesday, February 21, 2006 8:18 AM To: reactor@doughughes.net Subject: Re: [Reactor For CF] Oracle support for Reactor Perhaps something user-configurable in the config set specifically for Oracle (or any other DBs that don't have autonumber)? Maybe something like this (with autonumber

RE: [Reactor For CF] Oracle support for Reactor

2006-02-21 Thread Chris Blackwell
to an object and configure Reactor to automagically call it, that would be great. Chris From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Kotek Sent: 21 February 2006 13:47 To: reactor@doughughes.net Subject: Re: [Reactor For CF] Oracle support

Re: [Reactor For CF] Oracle support for Reactor

2006-02-21 Thread Sean Corfield
On 2/21/06, Bowden, Beth (NIH/NIEHS) [E] [EMAIL PROTECTED] wrote: How about just two pktypes, autonumber or function? Function would mean use the getUniqueID function. This would add additional flexibility to use any different numbering scheme. That sounds like a good solution to me but two

[Reactor For CF] Oracle support for Reactor

2006-02-20 Thread Bowden, Beth \(NIH/NIEHS\) [E]
Doug, I've run into one problem migrating the Reactor blog to Oracle. Oracle doesn't have an autonumber or identity equivalent. So the function, Convention.lastInseredIdSyntax, doesn't work. Oracle has sequences which can be used as a work-around. The code below is a modified version of the

RE: [Reactor For CF] Oracle support for Reactor

2006-02-20 Thread Doug Hughes
@doughughes.net; [EMAIL PROTECTED] Subject: [Reactor For CF] Oracle support for Reactor Doug, I've run into one problem migrating the Reactor blog to Oracle. Oracle doesn't have an autonumber or identity equivalent. So the function, Convention.lastInseredIdSyntax, doesn't work. Oracle has sequences which